> Is there any performance considerations that may make one technique
> better than the other?
(2) will me much faster. Assuming you're searching all columns, of course.
PostgreSQL Experts Inc.
In response to
pgsql-performance by date
|Next:||From: Ivan Voras||Date: 2009-09-30 13:20:36|
|Subject: Re: Bad performance of SELECT ... where id IN (...)|
|Previous:||From: Robert Haas||Date: 2009-09-29 21:28:06|
|Subject: Re: Speed while runnning large transactions.|