Skip site navigation (1) Skip section navigation (2)

Re: Why is this taking so damn long?

From: GH <grasshacker(at)over-yonder(dot)net>
To: Paul Tomblin <ptomblin(at)xcski(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Why is this taking so damn long?
Date: 2001-04-28 19:05:45
Message-ID: 20010428140545.A11337@over-yonder.net (view raw or flat)
Thread:
Lists: pgsql-general
On Sat, Apr 28, 2001 at 02:18:42PM -0400, some SMTP stream spewed forth: 
> I just added a boolean column to an existing database with 70,000 records.
> I then tried to set all the existing columns to true using
>     update waypoint set ispublic = TRUE;
> but it's taken over an hour so far.


Hm, we need some damn information. :)
Is there an index on this column?
What version of PostgreSQL are you using?
(Not as relevant) Have you vacuum'ed this table lately?


Thanks...

gh

> 
> Why?
> 
> -- 
> Paul Tomblin <ptomblin(at)xcski(dot)com>, not speaking for anybody
> "I have traveled the length and breadth of this country and talked with the
> best people, and I can assure you that data processing is a fad that won't
> last out the year." --Editor of business books for Prentice Hall, 1957.
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://www.postgresql.org/search.mpl

In response to

Responses

pgsql-general by date

Next:From: James ThorntonDate: 2001-04-28 19:28:24
Subject: IpcMemoryCreate: shmget failed (Invalid argument)
Previous:From: Paul TomblinDate: 2001-04-28 18:18:42
Subject: Why is this taking so damn long?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group