Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group