Andrew Sullivan ajs
Thu Oct 5 13:00:48 PDT 2006
On Thu, Oct 05, 2006 at 10:32:13PM +0300, Lukas wrote:
> Hello,
> 
>  6000ms is the time which I have to wait until query finishes. The pgadmin
> shows time 6000ms..

I dimly remember having a case where an AFTER trigger took a period
of time after it did its work to return.  This had something to do
with lousy statistics on one of the target tables.  Is everything
vacuumed and analysed?  And are you perfectly sure that this really
is a Slony issue, and not just coincidence?

In any case, a full EXPLAIN ANALYSE session from psql with the \timing
setting on would probably help show everything in question.

A

-- 
Andrew Sullivan  | ajs at crankycanuck.ca
When my information changes, I alter my conclusions.  What do you do sir?
		--attr. John Maynard Keynes



More information about the Slony1-general mailing list