Hi,
Could someone tell m how to measure postgres memory usage.
Is there a pg_* view to measure?
Thank you
NikT
Hi,
Could some please explain what these warnings mean in postgres.
I see these messages a lot when automatic vacuum runs.
1 tm:2013-04-10 11:39:20.074 UTC db: pid:13766 LOG: automatic vacuum
of table "DB1.nic.pvxt": could not (re)acquire exclusive lock for truncate
scan
1 tm:2013-04
Hi Bambi,
Thank you the prompt reply.
This table is very volatile, lot of inserts/updates happen on this
tables(atleast 20~30 inserts/min).
When auto vacuum tries to run on this table, I get this warning.
Is there a way, I force it to happen, because the table/indexes statistics
are becoming sta
Hi,
What is the recommended swap space for postgres or 9.0.11 or 9.2.3 on
linux(3.0.58-0.6)
RAM on the hox is 32GB.
Thank you
Nik
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