Skip site navigation (1) Skip section navigation (2)

Re: problem with 8.0rc1 not using indexes(solved)

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: problem with 8.0rc1 not using indexes(solved)
Date: 2004-12-21 12:28:15
Message-ID: cq94ss$nic$1@floppy.pyrenet.fr (view raw or flat)
Thread:
Lists: pgsql-bugs
Tony Caduto wrote:
> 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.

Is not solved because is a bad idea run the server with that parameter
disabled.


Regards
Gaetano Mendola



In response to

pgsql-bugs by date

Next:From: PostgreSQL Bugs ListDate: 2004-12-21 15:17:32
Subject: BUG #1352: 100's of postgres.exe tasks created
Previous:From: Joerg SchubertDate: 2004-12-21 10:13:37
Subject: unsubscribe pgsql-bugs@postgresql.org

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group