Re: Why is this taking so damn long?

Quoting GH (grasshacker@over-yonder.net):
> 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?
>

No, I just added the column, I didn't put an index on it.  It's Postgres
6.5.  And you're right, I haven't vacuumed it recently.  And the update is
still running.

--
Paul Tomblin <ptomblin@xcski.com>, not speaking for anybody
A fool and his money are soon flying more airplane than he can
handle.