FW: very slow updates - Mailing list pgsql-general

From Xavier Bugaud
Subject FW: very slow updates
Date
Msg-id A4AAC8CD87A2D511B796004005420B1F64CED6@PMSERVER
Whole thread Raw
Responses Re: FW: very slow updates  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-general
> 1. Are you using transactions?
> 2. Do you have an index on id?

Hi,

Thanks for answering...

1. I tried with and without transctions : same result. In the
tests I make right now, I have disable transactions.

2. yes, a unique index.

Each time I run a "VACUUM FULL", the process is very fast
again for 6-7 times (10-15s). After that, it takes again
about 2-3 minutes...
When I only run a "VACUUM" (not FULL), it doesn't make any difference.

--
Xavier Bugaud

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: very slow updates
Next
From: g.hintermayer@inode.at (Gerhard Hintermayer)
Date:
Subject: Re: database shutdown with persistent client connections