problem with 8.0rc1 not using indexes(solved)

From: Tony Caduto <tony(dot)caduto(at)amsoftwaredesign(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: problem with 8.0rc1 not using indexes(solved)
Date: 2004-12-20 16:27:20
Message-ID: 41C6FD68.5080800@amsoftwaredesign.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Well, I got my 8.0 RC1 working the same as my 7.4.5 and it is for sure
because of some difference in the SQL engine.

On my 7.4.5 box I had the following in the postgresql.conf file:

enable_seqscan = true (this is the default setting)
7.4.5 had no problems using the indexes with this setting = true

on 8.0RC1 it refused to use certain indexes if enable_seqscan = true
I set this value to false on 8.0 and my performance came back to the
7.4.5 levels.

Is there some other setting in the conf file that would affect the
optimizer?

The weird part is if I ran each query in the function by itself Explain
would always report the index being used, but when run in the context of
the function the indexes where not being used.

Thanks,

Tony Caduto

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Helena Lourenco 2004-12-20 17:23:02 unsubscribe pgsql-bugs
Previous Message Belbin, Peter 2004-12-20 15:56:46 Re: solaris 10 with gcc 3.3.2