[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 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
