Skip site navigation (1) Skip section navigation (2)

Re: Need to update all my 60 million rows at oncewithout transactional integrity

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: christian_behrens(at)gmx(dot)net
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Need to update all my 60 million rows at oncewithout transactional integrity
Date: 2008-04-23 13:04:29
Message-ID: 20080423130429.GD4768@alvh.no-ip.org (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-general
christian_behrens(at)gmx(dot)net 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 that resets a status-flag to zero.

Perhaps you should rethink your data model.


> I would really like to kind of "skip transactions". Of course basic
> data integrity in on disc structures, but not atomicy for this bulk
> update!

There is no such thing on Postgres as "not a transaction".

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

pgsql-general by date

Next:From: Glyn AstillDate: 2008-04-23 13:08:19
Subject: Qty of WAL files
Previous:From: Alvaro HerreraDate: 2008-04-23 12:57:59
Subject: Re: plpgsql and logical expression evaluation

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group