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

2004-12-21 Thread Gaetano Mendola
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 wit

[BUGS] problem with 8.0rc1 not using indexes(solved)

2004-12-20 Thread Tony Caduto
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 = tr