Re: continuous copy/update one table to another

From: Szymon Guz <mabewlun(at)gmail(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: continuous copy/update one table to another
Date: 2010-03-01 08:59:34
Message-ID: e4edc9361003010059w37c8884aof6f66893228e32a8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

W dniu 1 marca 2010 09:40 użytkownik Grzegorz Jaśkiewicz
<gryzman(at)gmail(dot)com>napisał:

> don't use 'NOT EXISTS', as this will be damn slow. Use LEFT JOIN.
>
>
Right, LEFT JOIN should be faster (with proper indices even much faster).

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian von Bidder 2010-03-01 09:43:31 Optimizer: ranges and partial indices? Or use partitioning?
Previous Message Grzegorz Jaśkiewicz 2010-03-01 08:40:21 Re: continuous copy/update one table to another