Re: [PERFORM] optimization ideas for frequent, large(ish) updates in frequently accessed DB?

[Manfred Koizar]

On Fri, 13 Feb 2004 16:21:29 +0100, I wrote:
>Populate this table with
>       INSERT INTO idmap
>       SELECT id, id, true
>         FROM t;

Advertising

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

Servus
 Manfred

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html