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

Re: Data Warehouse Reevaluation - MySQL vs Postgres --

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: ischamay(dot)andbergsay(at)activestateway(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Data Warehouse Reevaluation - MySQL vs Postgres --
Date: 2004-09-16 04:29:04
Message-ID: 41491690.6030901@familyhealth.com.au (view raw or flat)
Thread:
Lists: pgsql-performance
>> insert into X
>>   select a.keyA,
>>          a.keyB,
>>      a.colA,
>>      a.colB
>>   from Y a left join X b
>>        using (keyA, keyB)
>>   where b.keyA is NULL and
>>         b.keyB is NULL;
>>
>> With the appropriate indexes, this is pretty fast but I think a merge
>> would be much faster.

Problem is it's subject to race conditions if another process is 
inserting stuff at the same time...

Chris

In response to

pgsql-performance by date

Next:From: IainDate: 2004-09-16 05:08:34
Subject: Re: Data Warehouse Reevaluation - MySQL vs Postgres --
Previous:From: Steve AtkinsDate: 2004-09-16 04:17:03
Subject: Re: Data Warehouse Reevaluation - MySQL vs Postgres --

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