Quoting GH ([EMAIL PROTECTED]): > 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 <[EMAIL PROTECTED]>, not speaking for anybody A fool and his money are soon flying more airplane than he can handle. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
