[PERFORM] 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

[PERFORM] 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

Re: [PERFORM] [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

Re: [PERFORM] Find how much memory is postgres using

lubaczewski dep...@depesz.com wrote: On Sun, Apr 07, 2013 at 09:27:42PM -0700, Nik Tek wrote: Thank you Depesz! But I have a naive question, why isn't a straight forword approach for postgres, unlike Oracle or MSSQL? No idea. And how do you get memory usage in Oracle or MSSQL? Best

Re: [PERFORM] Find how much memory is postgres using

= 'session pga memory') GROUP BY ROLLUP (nm); Sure, I will take up the task, will send you the script once it is ready, so you can bless it. :) Regards Nik On Tue, Apr 9, 2013 at 11:34 AM, hubert depesz lubaczewski dep...@depesz.com wrote: On Tue, Apr 09, 2013 at 11:24:22AM -0700, Nik Tek

[PERFORM] 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