christian_behrens@xxxxxxx 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.
