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 | [EMAIL PROTECTED]
When my information changes, I alter my conclusions. What do you do sir?
--attr. John Maynard Keynes
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
