Postgres Pro
Downloads
Home   >   mailing lists

Re: optimization ideas for frequent, large(ish) updates in frequently accessed DB? - Mailing list pgsql-performance

From Manfred Koizar
Subject Re: optimization ideas for frequent, large(ish) updates in frequently accessed DB?
Date
Msg-id hovp20tm9ivkf4sc7dsgfqqjonfr3f22ub@email.aon.at
Whole thread Raw
In response to Re: optimization ideas for frequent, large(ish) updates in frequently accessed DB?  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-performance
Tree view 
On Fri, 13 Feb 2004 16:21:29 +0100, I wrote:
>Populate this table with
>    INSERT INTO idmap
>    SELECT id, id, true
>      FROM t;

This should be
    INSERT INTO idmap
    SELECT DISTINCT id, id, true
      FROM t;

Servus
 Manfred

pgsql-performance by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: optimization ideas for frequent, large(ish) updates in frequently accessed DB?
Next
From: Leon Out
Date:
Subject: Re: Disappointing performance in db migrated from MS SQL Server