"Dai, Tino" <tdai@xxxxxxx> writes: > 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. 8.2 was released in 2006. 8.1 is going to be desupported entirely at the end of 2010. You really need to be holding your vendor's feet to the fire about supporting modern versions of Postgres, rather than looking for workarounds. But having said that, I think 8.1 might generate a reasonable plan if it weren't getting misled by these useless constraints: > -> Seq Scan on role_setting (cost=0.00..964.50 rows=1 width=70) (actual time=0.036..121.443 rows=43833 loops=1) > Filter: (((section)::text = (section)::text) AND (ref_id = ref_id)) Can you get rid of those? regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
