Re: Postgresql 8.0 RC1 not using indexes

Hi Tom,
Yes I did a vacuum analyse right away.  As a  further test I  restored
the exact same data on another 7.4.5 server and  even without a  vacuum
analyse the importer program worked as expected(fast).
I posted some more info including screen shots of the importer running
in verbose mode on a 7.4.5 and a 8.0rc1 server, and much more info.  I
actually think I have it narrowed down to a select count(*)  in my
importer function.  It seems that the select count(*) is not using the
indexes that I have defined.  This same process has been in production
since June 04 and the indexes have not  been changed or deleted.   On
monday I am going to replace the count(*) with a for select and a
counter variable and see if the slowness goes away.  It really does seem
to be some issue/bug maybe or  just a difference in the 8.0 engine.

Thanks,

Tony Caduto


Tom Lane wrote:

>Tony Caduto <tony.caduto@amsoftwaredesign.com> writes:
>
>
>>I just installed 8.0 RC1 and then restored my database which was working
>>perfectly on 7.4.5.
>>I have a function that imports rows from a comma seperated file and on
>>7.4.5 using this same function I could get around 1000 rows every 2.5
>>seconds, now with 8.0 RC1 this has gone way up and it seems to be
>>because it is not using the indexes defined on the table.
>>
>>
>
>Have you done an ANALYZE or VACUUM ANALYZE since loading the data?
>
>            regards, tom lane
>
>
>
>
>