Skip site navigation (1) Skip section navigation (2)

Re: Background triggers?

From: Tino Schwarze <postgresql(at)tisc(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Background triggers?
Date: 2009-08-19 19:41:24
Message-ID: 20090819194124.GC11776@easy2.in-chemnitz.de (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2009-08-19 19:45:34
Subject: Re: Background triggers?
Previous:From: Dick VisserDate: 2009-08-19 19:23:22
Subject: Background triggers?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group