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
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
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
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
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
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
-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
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:
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
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
10 matches
Mail list logo