Re: [PERFORM] Help interpreting explain analyze output

2004-08-15 Thread Richard Poole
On Sun, Aug 15, 2004 at 07:47:53PM +0200, Ole Tange wrote: > QUERY PLAN > - > Unique (cost=5680.00..5766.70 rows=8670 width=26) (act

Re: [PERFORM] Nested loop performance

2003-12-16 Thread Richard Poole
On Tue, Dec 16, 2003 at 12:11:59PM -0500, Nick Fankhauser wrote: > > I'm trying to optimize a query that I *think* should run very fast. > Essentially, I'm joining two tables that have very selective indexes and > constraining the query on an indexed field. (There's a third small lookup > table in