On Mon, Mar 22, 2010 at 3:58 PM, Dai, Tino <[email protected]> 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.. -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
