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" Is it normal? is it possible to do something about it? thx for any info Lukas -- This message has been scanned for viruses and dangerous content, and is believed to be clean. _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
