Hello people,
I have a large table to do update (in every tuple), the table (table1) has
about 8 millions tuples, and I had to add a new column (new_column).
The table1 is one of the most accessed table in my cluster, so I can't do a
direct update 'cause almost everyone stays in waiting.
Doing the
Rafael Domiciano wrote:
> I have a large table to do update (in every tuple), the table
> (table1) has about 8 millions tuples, and I had to add a new column
> (new_column). The table1 is one of the most accessed table in my
> cluster, so I can't do a direct update 'cause almost everyone stays
Hello Kevin, Thnks for response,
Doing the alter table to add the new column was fast: ALTER TABLE table1 ADD
COLUMN new_column date;
The problem is that I have to do a update in this column, and the values are
going to be the a misc of others 2 columns of the table1, something like
this:
update
Rafael Domiciano wrote:
> Doing the alter table to add the new column was fast: ALTER TABLE
> table1 ADD COLUMN new_column date;
So far, so good.
> The problem is that I have to do a update in this column, and the
> values are going to be the a misc of others 2 columns of the table1,
> some
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On Thu, Apr 23, 2009 at 4:06 PM, Kevin Grittner wrote:
> Rafael Domiciano wrote:
>
> > Doing the alter table to add the new column was fast: ALTER TABLE
> > table1 ADD COLUMN new_column date;
>
> So far, so good.
>
> > The problem is that I have to do a update in this column, and the
> > values
On Freitag 24 April 2009 Rafael Domiciano wrote:
> this table has about 15 indexes...
>
> How good are to Cluster table? Has any criteria to cluster table? How
> can I do it?
http://www.postgresql.org/docs/8.3/interactive/sql-cluster.html
CLUSTER tablename [ USING indexname after which you want da
On Thu, Apr 23, 2009 at 11:21 PM, Michael Monnerie
wrote:
> On Freitag 24 April 2009 Rafael Domiciano wrote:
>> this table has about 15 indexes...
>>
>> How good are to Cluster table? Has any criteria to cluster table? How
>> can I do it?
>
> http://www.postgresql.org/docs/8.3/interactive/sql-clus
