[ADMIN] Pg max_connection

2013-06-18 Thread Nik Tek
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

Re: [ADMIN] Pg max_connection

2013-06-18 Thread Bambi Bellows
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

[ADMIN] Re: PG_UPGRADE issues "this utility can only upgrade to postgresql version 9.2."

2013-06-18 Thread jmfox180
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

Re: [ADMIN] Re: PG_UPGRADE issues "this utility can only upgrade to postgresql version 9.2."

2013-06-18 Thread Ziggy Skalski
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

Re: [ADMIN] WAL scenario valid?

2013-06-18 Thread prakhar jauhari
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