On Tue, Jun 3, 2008 at 7:41 AM, Henrik <[EMAIL PROTECTED]> wrote: > > To be able to handle versions we always insert new folders even though > nothing has changed but it seemd like the best way to do it. > > E.g > > First run: > tbl_file 500k new files. > tbl_folder 50k new rows. > tbl_file_folder 550k new rows. > > Second run with no new files. > tbl_file unchanged. > tbl_folder 50k new rows > tbl_file_folder 550k new rows.
On useful trick is to include a where clause that prevents the extra updates. I.e. update table set field=123 where field <> 123; -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
