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

From: James Cloos <cloos(at)jhcloos(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, flyusa2010 fly <flyusa2010(at)gmail(dot)com>
Subject: Re: XLog vs SSD [Was: Re: random write in xlog?]
Date: 2010-12-09 17:29:25
Message-ID: m3pqtayhv6.fsf@jhcloos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>>>>> "JJ" == Jeff Janes <jeff(dot)janes(at)gmail(dot)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 there is probably little hope of
making efficient use of flash.

-JimC
--
James Cloos <cloos(at)jhcloos(dot)com> OpenPGP: 1024D/ED7DAEA6

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tim Bunce 2010-12-09 17:32:32 Re: Optimize PL/Perl function argument passing [PATCH]
Previous Message Merlin Moncure 2010-12-09 17:08:17 Re: Solving sudoku using SQL