Re: Moving pg_xlog

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 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 secs
2) xlog and some tables on disk1 and rest of tables on disk2=>
28 mins and 38 secs

but the most startling of the results is....
3) xlog on disk1 and half the tables on partition 1 of disk2 and other half on partition 2 of disk2
24 mins and 14 secs

??????????
shouldnt moving data to diff partitions degrade performance instead of enhancing it....

also in configuration 1, my heap_blks_hit/heap_blks_fetched was good enough....
but in configuration 3, its was really low.. something of the order of 1/15...
still the performance improved....

any ideas.....
does moving across partitions help...

Regards
Himanshu

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com