?
Tomasz Rakowski
- Original Message
From: Matthew T. O'Connor [EMAIL PROTECTED]
To: Tomasz Rakowski [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Wednesday, June 27, 2007 9:50:42 AM
Subject: Re: [GENERAL] autovacumm not working ?
Tomasz Rakowski wrote:
I have problem
would be nice)
Is it still possible to use autovacuum for such tables or I really should
switch to VACUUM run from cron ?
Do you think that if I run VACUUM from cron every 5 minutes I would see exactly
the same behaviour ?
Tomasz Rakowski
- Original Message
From: Alvaro Herrera
?
Tomasz Rakowski
- Original Message
From: Alvaro Herrera [EMAIL PROTECTED]
To: Tomasz Rakowski [EMAIL PROTECTED]
Cc: Matthew T. O'Connor [EMAIL PROTECTED]; pgsql-general@postgresql.org
Sent: Wednesday, June 27, 2007 2:50:40 PM
Subject: Re: [GENERAL] autovacumm not working ?
Tomasz Rakowski
Hi everybody,
I have problem with frequently updated table (around 30.000 records and 1000
updates/minute, few indexes).
After a while all queries to that table become much slower then at the begining
(the number of records in the table is quite stable all the time).
I can see that
PROTECTED]
To: Tomasz Rakowski [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Wednesday, June 27, 2007 9:50:42 AM
Subject: Re: [GENERAL] autovacumm not working ?
Tomasz Rakowski wrote:
I have problem with frequently updated table (around 30.000 records and
1000 updates/minute, few indexes
Herrera [EMAIL PROTECTED]
To: Tomasz Rakowski [EMAIL PROTECTED]
Cc: Matthew T. O'Connor [EMAIL PROTECTED]; pgsql-general@postgresql.org
Sent: Wednesday, June 27, 2007 2:50:40 PM
Subject: Re: [GENERAL] autovacumm not working ?
Tomasz Rakowski wrote:
Matthew,
Thank you for reply.
I was trying
Rakowski [EMAIL PROTECTED]
Cc: Matthew T. O'Connor [EMAIL PROTECTED]; pgsql-general@postgresql.org
Sent: Wednesday, June 27, 2007 3:54:14 PM
Subject: Re: [GENERAL] autovacumm not working ?
Tomasz Rakowski wrote:
Alvaro,
I changed autovacuum parametrs for this specific table in pg_autovacuum
Hi ,
I'm facing frustrating problem with locking in
postgres server. I have application which do update
one table few thousands time each minute. From time to
time call to database is locked and is waiting for
something
(In pgAdmin3 in 'Server Status' window in 'Lock' tab I
can see UPDATE