Why is this taking so damn long? - Mailing list pgsql-general

From Paul Tomblin
Subject Why is this taking so damn long?
Date
Msg-id 20010428141842.A15971@allhats.xcski.com
Whole thread Raw
Responses Re: Why is this taking so damn long?
List pgsql-general
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.

Why?

--
Paul Tomblin <ptomblin@xcski.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:

Previous
From: The Hermit Hacker
Date:
Subject: Re: Very long VACUUM time ...
Next
From: GH
Date:
Subject: Re: Why is this taking so damn long?