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.
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.
pgsql-general by date
|Next:||From: GH||Date: 2001-04-28 19:05:45|
|Subject: Re: Why is this taking so damn long?|
|Previous:||From: Feite Brekeveld||Date: 2001-04-28 16:59:03|
|Subject: Very long VACUUM time ...|