Re: [PERFORM] batch update query performance

2014-04-12 Thread Hans Drexler
ngle value. We could use two tables (one with records from old cycles, one with records from the new cycle) and a view. But that means copying all records from the "new" to the "older" table in each cycle. Kind regards, Hans Drexler -- Sent via pgsql-performance mailin

[PERFORM] Batch update query performance

2014-04-07 Thread Hans Drexler
then needs to update all 15 indexes to make them point to the new rows. There does not seem to be a way to avoid that. Question: - Is our hypothesis correct? - Can the forum please advise us on possible ways to make the query faster? Any insight is much appreciated. regards, Hans Drexler