Hmm, that is interesting. I have no experience in troubleshooting
jails, but that server was a pgsql db server (on Gentoo Linux) prior to
being borg, and has been very quick under heavy loads without any I/O
issues.
Gavin
Magnus Hagander wrote:
>>If there are performance issues on www.postgresql.org it
>>seems silly not to use borg. The machine is way under
>>utilized and you have more than enough donated bandwidth to
>>play with there.
>>
>>
>
>The only performance issues related to the base www site right now I
>think is the fact that I/O is horribly slow in the jail for svr2 (which
>runs wwwmaster) and that one is already on borg IIRC. The mirror script
>runs a *lot* faster on a heavily loaded linux server that I've tested it
>on. Not sure if it's the I/O bw on borg that's over the edge, or if it's
>the jails themselves causing it. I know Dave talked about comparing I/O
>on the main host vs the jails, not sure if he ever got through to doing
>it.
>
>
>//Magnus
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
>
