Re: [ADMIN] tuning tips, speed problem

2009-01-19 Thread Jaume Sabater
On Fri, Jan 16, 2009 at 4:37 PM, Oleg Bartunov o...@sai.msu.su 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

Re: [ADMIN] tuning tips, speed problem

2009-01-19 Thread BRAHMA PRAKASH TIWARI
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

Re: [ADMIN] tuning tips, speed problem

2009-01-19 Thread Thomas Pundt
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

[ADMIN] PostgreSQL monitoring

2009-01-19 Thread Marcelo Martins
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

Re: [ADMIN] tuning tips, speed problem

2009-01-19 Thread Scott Marlowe
On Mon, Jan 19, 2009 at 5:35 AM, BRAHMA PRAKASH TIWARI prakashr...@gmail.com 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

Re: [ADMIN] PostgreSQL monitoring

2009-01-19 Thread Jaume Sabater
On Mon, Jan 19, 2009 at 4:38 PM, Marcelo Martins pgli...@zeroaccess.org 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

Re: [ADMIN] PostgreSQL monitoring

2009-01-19 Thread Cédric Villemain
-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 you

[ADMIN] check to see when tables were last vacummed

2009-01-19 Thread Kevin Kempter
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:

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

2009-01-19 Thread Steve Crawford
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

[ADMIN] pg_buffercache - usagecount info

2009-01-19 Thread Kevin Kempter
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