Re: Slow Query - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Slow Query
Date
Msg-id 46DA9522.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Slow Query  (Shawn <postgres@xmtservices.net>)
Responses Re: Slow Query  (Shawn <postgres@xmtservices.net>)
List pgsql-performance
>>> On Sat, Sep 1, 2007 at 12:29 PM, in message
<20070901102947.0c0a50a3@boffin.xmtservices.net>, Shawn
<postgres@xmtservices.net> wrote:
> update shawns_data set alias = null;
> Even after VACUUM this simple line takes 35 sec to complete.

Would any rows already have a null alias when you run this?

If so, try adding 'where alias is not null' to the query.

-Kevin




pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slow Query
Next
From: Shawn
Date:
Subject: Re: Slow Query