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
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
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;
[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
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
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
[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
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
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
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
[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
-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
12 matches
Mail list logo