On Mon, Mar 22, 2010 at 3:58 PM, Dai, Tino <tdai@loc.gov> wrote:
> After many days of googling and referring to different web pages about performance, I'm
> turning to this list for help. We have a third party application that is running on 8.1.11 and the
> vendor has told us not to upgrade the database to 8.2.
>
> I have gone with the default values in postgresql.conf of 8.1.18 (the 8.1.11 was unavailable
> from the postgresql site so this is the closest one) and 8.2.14. I execute the same query with
> EXPLAIN ANALYZE on 8.1.18 and the 8.2.14. The 8.1.18 comes back with about 1000ms -1100ms
> while the 8.2.14 comes back with 5ms - 6ms.
That's a factor of about 200 times faster for 8.2.
> I have tried up the work_mem, effective_cache_size, and the shared_buffers with no noticeable effect.
> I'm not looking for a magic wand to allow 8.1.18 to become 8.2.14, but some performance gain would be
> nice. Can any shed some light on this?
Why?
> Filter: (((section)::text = (section)::text) AND (ref_id = ref_id))
> Total runtime: 6.905 ms
Is this the result from 8.2? Cause it's not 6 seconds, it's 6 milliseconds..