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$ (view raw, whole thread or download thread mbox)
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

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

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