Le mercredi 18 octobre 2006 23:02, Ioana Danes a écrit :
> I tried the partitioning scenario but I've got into
> the same problem. The max function is not using the
> indexes on the two partitioned tables...
> Any other thoughts?
Did you make sure your test included table inheritance?
I'm not sure the planner benefits from constraint_exclusion without selecting
the empty parent table (instead of your own union based view).
In response to
pgsql-performance by date
|Next:||From: Jeff Davis||Date: 2006-10-18 21:33:49|
|Subject: Re: Postgresql 8.1.4 - performance issues for select on|
|Previous:||From: Jim C. Nasby||Date: 2006-10-18 21:19:29|
|Subject: Re: UDF and cache|