"Jim C. Nasby" <decibel(at)decibel(dot)org> writes:
> (SELECT b.bucket_id AS rrs_bucket_id, s.*
> FROM rrs.bucket b
> JOIN page_log.log s
> ON (
> b.prev_end_time < log_time
> AND b.end_time >= log_time )
> WHERE b.rrs_id = '1'
> AND b.end_time <= '2005-01-21 20:23:00+00'
> AND b.end_time > '1970-01-01 00:00:00+00'
> ) a
> Basically, it seems that it doesn't understand that each row in log will
> match up with at most one row in bucket. There is a unique index on
> bucket(rrs_id, end_time), so it should be able to tell this.
Why should it be able to tell that?
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Christopher Browne||Date: 2005-01-23 05:41:22|
|Subject: Re: PostgreSQL clustering VS MySQL clustering|
|Previous:||From: Tom Lane||Date: 2005-01-22 21:10:23|
|Subject: Re: PostgreSQL clustering VS MySQL clustering |