[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

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 sta

[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 tm:2013-04

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

M v$sysstat WHERE name = '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: >

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

FROM v$sgastat; Thank you Nik On Mon, Apr 8, 2013 at 3:18 AM, hubert depesz lubaczewski 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,

[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