On Fri, Mar 30, 2012 at 9:32 PM, Tomas Vondra t...@fuzzy.cz wrote:
And it's not just about fsync operations - WAL is written in sequential
manner. By placing it on the same device as data files you're
effectively forcing it to be written randomly, because the the database
has to write a WAL
PostgreSQL 9.0.x
When PostgreSQL storage is using a relatively large raid 5 or 6 array is
there any value in having your tables distributed across multiple tablespaces
if those tablespaces will exists on the same raid array? I understand the
value if you were to have the tablespaces on
On Fri, Mar 30, 2012 at 02:45:36PM +, Campbell, Lance wrote:
PostgreSQL 9.0.x
When PostgreSQL storage is using a relatively large raid 5 or 6 array is
there any value in having your tables distributed across multiple tablespaces
if those tablespaces will exists on the same raid array?
On Fri, Mar 30, 2012 at 8:45 AM, Campbell, Lance la...@illinois.edu wrote:
PostgreSQL 9.0.x
When PostgreSQL storage is using a relatively large raid 5 or 6 array is
there any value in having your tables distributed across multiple
tablespaces if those tablespaces will exists on the
On 03/30/2012 10:45 AM, Campbell, Lance wrote:
PostgreSQL 9.0.x
When PostgreSQL storage is using a relatively large raid 5 or 6
array is there any value in having your tables distributed across
multiple tablespaces if those tablespaces will exists on the same raid
array? I understand
On Fri, Mar 30, 2012 at 10:02 AM, Andrew Dunstan and...@dunslane.net wrote:
Not answering your question, but standard advice is not to use RAID 5 or 6,
but RAID 10 for databases. Not sure if that still hold if you're using SSDs.
Yeah, for SSD the equations may change. Parity based RAID has two
On Fri, Mar 30, 2012 at 7:53 AM, k...@rice.edu k...@rice.edu wrote:
On Fri, Mar 30, 2012 at 02:45:36PM +, Campbell, Lance wrote:
PostgreSQL 9.0.x
When PostgreSQL storage is using a relatively large raid 5 or 6 array is
there any value in having your tables distributed across multiple
On 30.3.2012 16:53, k...@rice.edu wrote:
On Fri, Mar 30, 2012 at 02:45:36PM +, Campbell, Lance wrote:
PostgreSQL 9.0.x
When PostgreSQL storage is using a relatively large raid 5 or 6 array is
there any value in having your tables distributed across multiple
tablespaces if those