[ADMIN] pg_buffercache - usagecount info

Hi All; Can someone point me in the direction of more info per the usagecount value in the pg_buffercache view, or send me a description beyond "Page LRU count" There's no README in my postgresql-8.3.5/contrib/pg_buffercache dir and I've found nothing more in the online manual. Thanks in adva

Re: [ADMIN] check to see when tables were last vacummed

Kevin Kempter wrote: Hi all; Anyone know where to look to see when tables were last vacuumed via autovacuum ? Also, can I run this check only in 8.3+ or did it work also in 8.2, 8.1 ? Thanks in advance In 8.3 look in the "pg_stat_user_tables" system table for the last_vacuum and last_a

[ADMIN] check to see when tables were last vacummed

Hi all; Anyone know where to look to see when tables were last vacuumed via autovacuum ? Also, can I run this check only in 8.3+ or did it work also in 8.2, 8.1 ? Thanks in advance -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://

Re: [ADMIN] PostgreSQL monitoring

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Marcelo Martins a écrit : > > Do you guys have any suggestions on monitoring tools for postgresql that > would provide graphing of data & alerts ? > I have looked and tried out hyperic, munin, Nimbus but was hoping to > something better. Note that yo

Re: [ADMIN] PostgreSQL monitoring

On Mon, Jan 19, 2009 at 4:38 PM, Marcelo Martins wrote: > Do you guys have any suggestions on monitoring tools for postgresql that > would provide graphing of data & alerts ? > I have looked and tried out hyperic, munin, Nimbus but was hoping to > something better. To monitor I use the following

Re: [ADMIN] tuning tips, speed problem

On Mon, Jan 19, 2009 at 5:35 AM, BRAHMA PRAKASH TIWARI wrote: > Hi Francesco > > most probabely this is due to the auto vacuum option on and if auto vacuum > is on then the in condition of high transaction on database it slows the > speed of the hole database.Set it off in postgres.conf and vacuum

[ADMIN] PostgreSQL monitoring

Do you guys have any suggestions on monitoring tools for postgresql that would provide graphing of data & alerts ? I have looked and tried out hyperic, munin, Nimbus but was hoping to something better. Thanks, Marcelo PostgreSQL DBA Linux/Solaris System Administrator -- Sent via pgsql-ad

Re: [ADMIN] tuning tips, speed problem

On Montag, 19. Januar 2009, BRAHMA PRAKASH TIWARI wrote: | most probabely this is due to the auto vacuum option on and if auto vacuum | is on then the in condition of high transaction on database it slows the | speed of the hole database.Set it off in postgres.conf and vacuum and | reindex transact

Re: [ADMIN] tuning tips, speed problem

Hi Francesco most probabely this is due to the auto vacuum option on and if auto vacuum is on then the in condition of high transaction on database it slows the speed of the hole database.Set it off in postgres.conf and vacuum and reindex transactional tables manualy with in every two million tra

Re: [ADMIN] tuning tips, speed problem

On Fri, Jan 16, 2009 at 4:37 PM, Oleg Bartunov wrote: > Just a quick question - why do you use quite old release 8.1 instead of > 8.3.5 ? I presume it's because it is the version that comes by default in Debian Etch. So I'll take this opportunity to comment about backports.org. If you use that r