[GENERAL] Need to update all my 60 million rows at once without transactional integrity

2008-04-23 Thread christian_behrens
Hi! How can I make a Update of a column in a very large table for all rows without using the double amount of disc space and without any need for atomic operation? I have a very large table with about 60 million rows. I sometimes need to do a simple update to ALL rows that resets a status-flag

Re: [GENERAL] Need to update all my 60 million rows at once without transactional integrity

2008-04-23 Thread A. Kretschmer
am Mon, dem 21.04.2008, um 0:19:34 +0200 mailte [EMAIL PROTECTED] folgendes: Hi! How can I make a Update of a column in a very large table for all rows without using the double amount of disc space and without any need for atomic operation? I have a very large table with about 60

Re: [GENERAL] Need to update all my 60 million rows at once without transactional integrity

2008-04-23 Thread Pavan Deolasee
On Wed, Apr 23, 2008 at 1:52 PM, A. Kretschmer [EMAIL PROTECTED] wrote: am Mon, dem 21.04.2008, um 0:19:34 +0200 mailte [EMAIL PROTECTED] folgendes: If I do a batched loop like this: UPDATE table SET flag=0 where id=0 and id 200; UPDATE table SET flag=0 where id=200 and id 400;

Re: [GENERAL] Need to update all my 60 million rows at once without transactional integrity

2008-04-23 Thread Alvaro Herrera
[EMAIL PROTECTED] wrote: How can I make a Update of a column in a very large table for all rows without using the double amount of disc space and without any need for atomic operation? I have a very large table with about 60 million rows. I sometimes need to do a simple update to ALL rows

Re: [GENERAL] Need to update all my 60 million rows at once without transactional integrity

2008-04-23 Thread Merlin Moncure
On Wed, Apr 23, 2008 at 9:04 AM, Alvaro Herrera [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: How can I make a Update of a column in a very large table for all rows without using the double amount of disc space and without any need for atomic operation? I have a very large

Re: [GENERAL] Need to update all my 60 million rows at once without transactional integrity

2008-04-23 Thread Pavan Deolasee
On Mon, Apr 21, 2008 at 3:49 AM, [EMAIL PROTECTED] wrote: Could I use that to hack my way around transactions? Since you are asking for trouble, may there is something you can do with Before UPDATE Triggers and heap_inplace_update(). Before you try this out: I must say, *I have no idea if

Re: [GENERAL] Need to update all my 60 million rows at once without transactional integrity

2008-04-23 Thread Steve Crawford
[EMAIL PROTECTED] wrote: Hi! How can I make a Update of a column in a very large table for all rows without using the double amount of disc space and without any need for atomic operation? I have a very large table with about 60 million rows. I sometimes need to do a simple update to ALL

Re: [GENERAL] Need to update all my 60 million rows at once without transactional integrity

2008-04-23 Thread Simon Riggs
On Mon, 2008-04-21 at 00:19 +0200, [EMAIL PROTECTED] wrote: How can I make a Update of a column in a very large table for all rows without using the double amount of disc space and without any need for atomic operation? I have a very large table with about 60 million rows. I sometimes need

Re: [GENERAL] Need to update all my 60 million rows at once without transactional integrity

2008-04-23 Thread Tom Allison
Far from being an expert on postgres, but there are two ideas-- assuming that you cannot afford the time it would take to simply UPDATE and wait... Write a script to update all the rows, one at a time. Lowest impact to operations but would take a very long time. Assuming you have a

Re: [GENERAL] Need to update all my 60 million rows at once without transactional integrity

2008-04-23 Thread Alban Hertroys
On Apr 21, 2008, at 12:19 AM, [EMAIL PROTECTED] wrote: Hi! How can I make a Update of a column in a very large table for all rows without using the double amount of disc space and without any need for atomic operation? I have a very large table with about 60 million rows. I sometimes

Re: [GENERAL] Need to update all my 60 million rows at once without transactional integrity

2008-04-23 Thread Chris Browne
[EMAIL PROTECTED] writes: How can I make a Update of a column in a very large table for all rows without using the double amount of disc space and without any need for atomic operation? You may need to redefine the problem. I have a very large table with about 60 million rows. I sometimes

Re: [GENERAL] Need to update all my 60 million rows at once without transactional integrity

2008-04-23 Thread Dann Corbit
-Original Message- From: [EMAIL PROTECTED] [mailto:pgsql-general- [EMAIL PROTECTED] On Behalf Of Chris Browne Sent: Wednesday, April 23, 2008 3:20 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Need to update all my 60 million rows at once without transactional integrity