Tom Lane <[EMAIL PROTECTED]> wrote:
>It seems highly unlikely that putting more stuff on the xlog disk will>improve performance --- at least not if your bottleneck is update speed.
Tom you are right.. i did some testing...
1) default config--- xlog on disk1 and data on disk2=>
27 mins and 22
My database has two scsi disks
my current configuration has pg_xlog on disk1 and data on disk2
the machine is used for database only
now did some logging and came to a conclusion that my disk2(data disk) is getting used around 3 times more than disk1(pg_xlog)
so wht is recommended
