nable ?
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 Rak
?
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] autovacum
t_ais_position(update_time)", so it is
suppose to be updated very frequently (as main table). The other index
"t_ais_position_pkey" is on primary key and values doesn't change at all
Could somebody explain me that ? (something more then autovacuum doesn't ke
>
To: Tomasz 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 autova
om: 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 wrote:
> Matthew,
;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 with frequently updated table (around 30.000 records a
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 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 stateme
