Re: 7.3.2 vs 7.1.2

From: Victor Yegorov <viktors(dot)jegorovs(at)nordlb(dot)lv>
To: Eugene Fokin <elf(at)solvo(dot)ru>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: 7.3.2 vs 7.1.2
Date: 2003-05-20 15:58:01
Message-ID: 20030520155801.GC4580@nordlb.lv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

* Eugene Fokin <elf(at)solvo(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2003-05-20 16:30:20 Re: 7.3.2 vs 7.1.2
Previous Message scott.marlowe 2003-05-20 15:37:03 Re: postgres on a beowulf? (AMD)opteron?