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
Read cache of course does not need to be flushed and can simply be
dumped when the memory is needed, and so Linux will keep more or
less unlimited amounts of read cache until it needs the memory for
something else
Right, that's the normal behavior. Except not on this machine.
So
Hi,
On 29.3.2012 19:59, Campbell, Lance wrote:
PostgreSQL 9.0.x
We have around ten different applications that use the same database.
When one particular application is active it does an enormous number of
inserts. Each insert is very small. During this time the database
seems to slow
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