Hi,
I have a question on max_connections.
I have a application which would require more connection at the startup
time(something like 500 connections), after the initial startup is done,
the connections drop to 50.
Question: If I set my max_connection to 500 at the db start-up time and
later aft
It is my understanding that connections consume 400b of memory apiece, and that
the memory is only held while the process is active; so, if you drop 450
connections, your memory usage will drop about 200k. In this day and age, that
doesn't mean a lot, but you should see mild performance improve
so after trying i advance just a little bit but when running pg_upgrade for a
check or upgrade
i get:
pg_control values:
First log file ID after reset:0
First log file segment after reset: 2
pg_control version number:922
Catalog version number: 201204301
Datab
On 13-06-18 02:06 PM, jmfox180 wrote:
so after trying i advance just a little bit but when running pg_upgrade for a
check or upgrade
i get:
pg_control values:
First log file ID after reset:0
First log file segment after reset: 2
pg_control version number:922
Catalog vers
Hey..
I am facing a similar kind of problem, but in a two node setup. Streaming
replication is being used with a high wal_keep_segments, using log shipping
to bump up timelines on the standby server to setup SR(streaming
replication).
DB1 - master
DB2 - standby
When a switchover happens DB2 becom