Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group