> -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
>
[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
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
ne
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 sequenc
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 n
[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 rows
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
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
[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
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 a
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 6
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
12 matches
Mail list logo
