Postgres Pro
Downloads
Home   >   mailing lists

Re: 7.3.2 vs 7.1.2 - Mailing list pgsql-performance

From Victor Yegorov
Subject Re: 7.3.2 vs 7.1.2
Date
Msg-id 20030520155801.GC4580@nordlb.lv
Whole thread Raw
In response to Re: 7.3.2 vs 7.1.2  (Eugene Fokin <elf@solvo.ru>)
Responses Re: 7.3.2 vs 7.1.2
List pgsql-performance
Tree view 
* Eugene Fokin <elf@solvo.ru> [20.05.2003 18:38]:
> > (loads l JOIN (SELECT rcn_details.id, rcn_details.date_pour FROM rcn_details) r ON ((r.id = l.rcn_id)))
> >

Try changing the join above to:

loads l JOIN rcn_details r ON r.id = l.rcn_id

Also, give the full description of fields, involved in your
load_rcn_id_idx and rcn_detail_idx indicies.

--

Victor Yegorov

pgsql-performance by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: postgres on a beowulf? (AMD)opteron?
Next
From: Josh Berkus
Date:
Subject: Re: 7.3.2 vs 7.1.2