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.
Tom Lane wrote:
>Tony Caduto <tony(dot)caduto(at)amsoftwaredesign(dot)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
In response to
pgsql-bugs by date
|Next:||From: Bruce Momjian||Date: 2004-12-19 04:36:02|
|Subject: Re: BUG #1348: Wishlist: \pset expanded with value|
|Previous:||From: Tony Caduto||Date: 2004-12-18 22:27:31|
|Subject: problem with 8.0rc1 not using indexes (more info)|