Postgres Pro
Downloads
Home   >   mailing lists

Re: continuous copy/update one table to another - Mailing list pgsql-general

From Szymon Guz
Subject Re: continuous copy/update one table to another
Date
Msg-id e4edc9361003010059w37c8884aof6f66893228e32a8@mail.gmail.com
Whole thread Raw
In response to Re: continuous copy/update one table to another  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Responses Re: continuous copy/update one table to another  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view

W dniu 1 marca 2010 09:40 użytkownik Grzegorz Jaśkiewicz <gryzman@gmail.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).

pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: continuous copy/update one table to another
Next
From: Adrian von Bidder
Date:
Subject: Optimizer: ranges and partial indices? Or use partitioning?