Josh Sacks <[EMAIL PROTECTED]> writes:
> I can't understand what's going on in this simple query:
If you are using anything older than PG 7.4, you should not expect good
performance from WHERE ... IN (sub-SELECT) queries. There's essentially
no optimization happening there.
Hi!
On Mon, May 17, 2004 at 06:04:54PM +0100, Richard Huxton wrote:
> [EMAIL PROTECTED] wrote:
> > [...]
>
> In no official capacity whatsoever, welcome aboard.
Thanks ;-)
> > There is just one point where I found the documentation lacking any
> > description and practical hints (as opposed to
I can't understand what's going on in this simple query:
select c.name from Candidate C where
C.candidate_id in (select candidate_id from REFERRAL R
where r.employee_id = 3000);
Where Candidate.CANDIDATE_ID is the primary key for Candidate.
Here's the EXPLAN ANALYZE:
Seq
OK. Thank fou your help.
In this moment the size of database its 2GB.
And the machine it´s only to postgresql.
Gracias
> Mario Soto wrote:
>
>>Hi. i hava a postresql 7.4.2 in a production server.
>>
>>tha machine is a Pentium IV 2,6 GHZ AND 1 GB IN RAM with lINUX RH 9.0.
>>
>>
> Mario,
>
> Sta
Dan Harris wrote:
I am torn right now between these two systems to replace my aging DB
server:
4 x 2.2 GHz Opteron
8GB RAM
Ultra320 15kRPM RAID5 with 128MB cache
and
2-way 1.2GHz POWER4+ IBM pSeries 615
8GB RAM
Ultra320 15kRPM RAID5 with 64MB cache
I don't know anything about the pSeries, but hav
