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

Why is this taking so damn long?

From: Paul Tomblin <ptomblin(at)xcski(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Why is this taking so damn long?
Date: 2001-04-28 18:18:42
Message-ID: 20010428141842.A15971@allhats.xcski.com (view raw or flat)
Thread:
Lists: 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(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.

Responses

pgsql-general by date

Next:From: GHDate: 2001-04-28 19:05:45
Subject: Re: Why is this taking so damn long?
Previous:From: Feite BrekeveldDate: 2001-04-28 16:59:03
Subject: Very long VACUUM time ...

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