On Jan 6, 2006, at 18:21 , Andy wrote:
> Yes I have indexes an all join fields. The tables have around 30
> columns each and around 100k rows. The database is vacuumed every
> hour.
Just to chime in, VACUUM != VACUUM ANALYZE. ANALYZE is what updates
database statistics and affects query planning. VACUUM alone does not
do this.
>> Do you have an index on report.id_order ? Try creating an index for
>> it if not and run a vacuum analyze on the table to see if it gets
>> rid of the sequence scan in the plan.
Michael Glaesemann
grzm myrealbox com