Re: Adding and filling new column on big table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Jonathan Blitz <jb@xxxxxxxxxxxx>
Subject: Re: Adding and filling new column on big table
From: Francisco Reyes <lists@xxxxxxxxxxxxxxxx>
Date: Mon, 29 May 2006 23:22:36 -0400
Cc: pgsql-performance@xxxxxxxxxxxxxx
References: <01b401c6794f$f27355e0$ddf71005@jonathanlaptop>

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?

Follow-Ups:
- Re: Adding and filling new column on big table
  - From: Jonathan Blitz

References:
- Adding and filling new column on big table
  - From: Jonathan Blitz

Prev by Date: Split select completes, single select doesn't and becomes IO bound!
Next by Date: Re: Selects query stats?
Previous by thread: Re: Adding and filling new column on big table
Next by thread: Re: Adding and filling new column on big table
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux