Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
>> If I pg_dump that database then create a new database (e.g. "tempdb") 
>> and upload the dump file (thus making a duplicate) then the same query 
>> only takes 190ms !!
>> Vacuum, vacuum analyse, and vacuum full analyse does not seem to have an 
>> impact on these times.

> Damn, for some reason I didn't read that you had already tried vacuum 
> full.

I'm thinking index bloat, and a PG version too old for vacuum full to
recover any index space.  But without any information about PG version
or EXPLAIN ANALYZE results, we're all just guessing.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to