Re: [ADMIN] Totally inappropriate by-line for a major representative of this organization

2009-02-05 Thread Simon Riggs
On Thu, 2009-02-05 at 17:57 +0100, Sylvain Avril wrote: > I think you should read this and especially article 18 and 19 of > this : > http://www.un.org/Overview/rights.html Interesting read, thanks. OT: I see that Article 27 (2) appears to run directly counter to open source software. And it wou

Re: [ADMIN] autovacuum question

2009-02-05 Thread Alvaro Herrera
Harald Fuchs escribió: > In article <20090204165933.gb32...@alvh.no-ip.org>, > Alvaro Herrera writes: > > > Marc Mamin wrote: > >> There are 2 features that would be helpfull in my case: > >> > >> - define vacuum properties on table groups rather than on given tables: > > Hmm. I'm not really s

Re: [ADMIN] Totally inappropriate by-line for a major representative of this organization

2009-02-05 Thread Sylvain Avril
I think you should read this and especially article 18 and 19 of this : http://www.un.org/Overview/rights.html But yes you can argue that it was inspired by a previous declaration of a silly group of frenchs :-). On Mon, Feb 2, 2009 at 10:57 PM, Scott Runnion wrote: > As a subscriber to many po

Re: [ADMIN] question about measuring shared_buffers usage

2009-02-05 Thread Rajesh Kumar Mallah
further , can pg_buffercache view serve as a guide to setting appropriate value of shared_buffers ? when i do SELECT count(*) from pg_buffercache where relfilenode is null ; to check unused buffers i find that it has been 0 most of the time. Can shared_buffers be raised to an extent that some buf

[ADMIN] question about measuring shared_buffers usage

2009-02-05 Thread Rajesh Kumar Mallah
Hi , I have following setting in my postgresql.conf file. shared_buffers = 1 (8k blocks) ; which is apprx 80MB my question is how can i know how much is the usage of the shared_buffers so that it can be increased or decreased. below is the output of ipcs , I am wondering is postgres using

Re: [ADMIN] autovacuum question

2009-02-05 Thread Harald Fuchs
In article <20090204165933.gb32...@alvh.no-ip.org>, Alvaro Herrera writes: > Marc Mamin wrote: >> There are 2 features that would be helpfull in my case: >> >> - define vacuum properties on table groups rather than on given tables: >> >> For example, I don't want to vacuum daily tables which ca