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

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: "Marinos J(dot) Yannikos" <mjy(at)geizhals(dot)at>, pgsql-performance(at)postgresql(dot)org
Subject: Re: optimization ideas for frequent, large(ish) updates in frequently accessed DB?
Date: 2004-02-13 16:47:07
Message-ID: hovp20tm9ivkf4sc7dsgfqqjonfr3f22ub@email.aon.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Leon Out 2004-02-13 20:56:52 Re: Disappointing performance in db migrated from MS SQL Server
Previous Message Manfred Koizar 2004-02-13 15:21:29 Re: optimization ideas for frequent, large(ish) updates in frequently accessed DB?