Re: short query becomes long - Mailing list pgsql-sql

From Tom Lane
Subject Re: short query becomes long
Date
Msg-id 9845.959913119@sss.pgh.pa.us
Whole thread Raw
In response to short query becomes long  (mikeo <mikeo@spectrumtelecorp.com>)
List pgsql-sql
mikeo <mikeo@spectrumtelecorp.com> writes:
> after about 50,000 updates, which fly right along, the process begins
> to really bog down.  we perform a vacuum analzye and it speeds right
> up again.

A plain "vacuum" should do the job in a bit less time.  The problem
is you need to reclaim the space occupied by deleted versions of rows.
No way around that with the current storage manager: vacuum is the
only way to get rid of the wasted space.
        regards, tom lane


pgsql-sql by date:

Previous
From: p.lam@altavista.net
Date:
Subject: Simulating CURSORS??
Next
From: Brian Powell
Date:
Subject: creating rules on joined views