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 <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
