Hi Dick, On Wed, Aug 19, 2009 at 09:23:22PM +0200, Dick Visser wrote: > A bit of a long first story, hope someone is able to help... > > We have got a Ubuntu 8.04 server running Postfix, which reads its > mailing list subscription files, aliases, virtual, domains, etc from a > Postgres database. > > This used to work fine when we had only a couple of e-mail distribution > lists. However, recently a lot of new lists have been added and the > system becomes very slow. > > Turns out there a couple of very complicated views using other views, > using concatenated strings etc. A SELECT on this view takes about 2.5 > seconds. Tuning the resource allocation brought it down to 1.2 seconds. > We have looked at the queries and came to the conclusion that it would > not be feasible to bring this down any further. Are you sure you have finished tuning at the database level - indices, partitions etc.? What does EXPLAIN ANALYZE of a typical slow query show? BTW: Which version of PG are you running? Tino. -- "What we nourish flourishes." - "Was wir nähren erblüht." www.lichtkreis-chemnitz.de www.craniosacralzentrum.de -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
