Re: XLog vs SSD [Was: Re: [HACKERS] random write in xlog?]

2010-12-09 Thread James Cloos
JJ == Jeff Janes jeff.ja...@gmail.com writes: JJ So PG always writing 8K at a time is unlikely to make a difference JJ than if it wrote a smaller amount. Ah. Somehow I was thinking of the xlog files' 16M filesize rather than the internal 8k block size If it is only writing 8k blocks then

XLog vs SSD [Was: Re: [HACKERS] random write in xlog?]

2010-12-08 Thread James Cloos
JJ == Jeff Janes jeff.ja...@gmail.com writes: JJ Anyway, the writes are logically sequentially, but not physically. JJ If I remember correctly, it always writes out full blocks, even if JJ the last part of the block has not yet been filled with new data. JJ When the remainder gets filled, it

Re: XLog vs SSD [Was: Re: [HACKERS] random write in xlog?]

2010-12-08 Thread Jeff Janes
On Wed, Dec 8, 2010 at 12:15 PM, James Cloos cl...@jhcloos.com wrote: JJ == Jeff Janes jeff.ja...@gmail.com writes: JJ Anyway, the writes are logically sequentially, but not physically. JJ If I remember correctly, it always writes out full blocks, even if JJ the last part of the block has not