PostgreSQL hot standby feedback. How it works.
From time to time, people come to us with a problem, „Our queries cancelled on standby servers, and we enabled hot_standby_feedback, but queries on standby get cancelled. Why?“. Indeed,…
Filter
3 reasons to use PgBouncer.
3 reasons to use PgBouncer. For those who do not know, PgBouncer a lightweight connections pooler for PostgreSQL. And below there are 3 reasons why it is…
PgbConsole – admin console for PgBouncers.
pgbConsole – top-like PgBouncer admin console. If you work with PostgreSQL you have probably heard about PgBouncer – a lightweight connection pooler for PostgreSQL. PgBouncer is often used in situations…
PostgreSQL OnLine Troubleshoot.
PostgreSQL Meetup on RITFest 2015 at Moscow, Russia. Today was the first day of the festival RIT. One of the events of the festival was a PostgreSQL…
Linux tuning for PostgreSQL at Secon’2015
Slides from Secon’2015 – Software Developers Conference. Penza, The database is an essential element of any project. The database must be stable and provide good performance. If you…
Warning: pgstat wait timeout… pgstat what???
pgstat wait timeout, what does it mean? Today I would like to tell about warning message „pgstat wait timeout„. Pretty uninformative message, right? If you see this…