Re: Adding and filling new column on big table

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: Jonathan Blitz <jb(at)anykey(dot)co(dot)il>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Adding and filling new column on big table
Date: 2006-05-30 03:22:36
Message-ID: cone.1148959356.787773.34675.1000@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jonathan Blitz writes:

> So, I have tried to run the following command. The command never finishes
> (I gave up after about and hour and a half!).

Did you ever find what was the problem?
Perhaps you needed to run a vacuum full on the table?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Francisco Reyes 2006-05-30 03:52:35 Re: Selects query stats?
Previous Message Anthony Ransley 2006-05-30 00:26:43 Split select completes, single select doesn't and becomes IO bound!