On Wednesday 04 October 2006 14:56, Lukas wrote:
> Hello,
>
>  We are running 5 servers with postgresql 8.1 and Slony 1.2.0. Our servers
> are fast enough, like 3.0 Gaz Xeon, with 2GB of RAM and 320 SCSI disks.
>  After putting two sets with 19 tables to replication our master database
> speed went down. With the selects everything is ok, but inserts are
> taking terrible log time, for example insert to the table with 5 columns
> and total 70 rows only takes up to 6000ms:
> insert into padalinys_teises (tk_objektas, tk_personalas, tk_padalinys)
> VALUES (1,10,0)
>
> There is explain analyse output:
>
> explain analyse insert into padalinys_teises (tk_objektas, tk_personalas,
> tk_padalinys) VALUES (1,10,0);
>
> "Result  (cost=0.00..0.01 rows=1 width=0) (actual time=0.021..0.022 rows=1
> loops=1)"
> "Trigger for constraint fk_teises_klubuose_padalinys: time=0.055 calls=1"
> "Trigger for constraint teises_klubuose_tk_personalas_fkey: time=0.053
> calls=1"
> "Trigger _replikiukas_logtrigger_3: time=0.140 calls=1"
> "Total runtime: 0.416 ms"

I'm not sure where you are getting 6000ms from, this explain clearly shows 
less than 1/2 millisecond



>
> Is it normal? is it possible to do something about it?
>
> thx for any info
>
> Lukas