[Pgpool-general] INSERT slow on one system not on another

Łukasz Jagiełło lukasz.jagiello at gforces.pl
Wed Mar 4 15:45:22 UTC 2009


2009/3/4 Derek Jones <scunacc at yahoo.com>:
> Dear Lukasz,
>
> Thanks for the feedback.
>
> The FS is ext3 on both - with default block sizes.

Strongly recommend check reiserfs.

> I can't easily change the kernel on a production system - but I quite
> appreciate the need to consider doing that if I had to - would be a *big*
> change to make and I'd have to significantly plan to do that over a
> collection of nodes.

You said you got 2 clusters with 4 nodes. Change kernel at one node
and see stats (cacti whatever), change FS and see stats. You can
always sync that node with others.

-- 
Łukasz Jagiełło
G-Forces Web Management Polska

T: +44 (0) 845 055 9040
F: +44 (0) 845 055 9038
E: lukasz.jagiello at gforces.pl
W: www.gforces.co.uk

This e-mail is confidential and intended solely for the use of the
individual to whom it is addressed. If you are not the intended
recipient, please notify the sender immediately. Do not disclose the
contents of this e-mail to any other person, use it for any purpose,
print, copy, store, or distribute it. This e-mail should then be
destroyed. Any views expressed in this message are those of the
individual sender except where the sender specifically states them to
be the views of G-Forces Web Management Ltd. Registered Office: 4 & 5
Kings Row, Armstrong Road, Maidstone, Kent. ME15 6AQ. Registered
Company No. 3863609. VAT Registration No. 7250 384 50


More information about the Pgpool-general mailing list