[ADMIN] Find how much memory is postgres using

Hi, Could someone tell m how to measure postgres memory usage. Is there a pg_* view to measure? Thank you NikT

[ADMIN] Postgres log(pg_logs) have lots of message

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

Re: [ADMIN] Postgres log(pg_logs) have lots of message

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

[ADMIN] Recommended Swap space

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

[ADMIN] Pg max_connection

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