Re: Scaling SELECT:s with the number of disks on a stripe

From: Peter Schuller <peter(dot)schuller(at)infidyne(dot)com>
To: Marc Mamin <M(dot)Mamin(at)intershop(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Scaling SELECT:s with the number of disks on a stripe
Date: 2007-04-02 10:34:44
Message-ID: 20070402103443.GA57038@hyperion.scode.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello,

> If you are dealing with timed data or similar, you may consider to
> partition your table(s).

Unfortunately this is not the case; the insertion is more or less
random (not quite, but for the purpose of this problem it is).

Thanks for the pointers though. That is sure to be useful in some
other context down the road.

--
/ Peter Schuller

PGP userID: 0xE9758B7D or 'Peter Schuller <peter(dot)schuller(at)infidyne(dot)com>'
Key retrieval: Send an E-Mail to getpgpkey(at)scode(dot)org
E-Mail: peter(dot)schuller(at)infidyne(dot)com Web: http://www.scode.org

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message ramachandra.bhaskaram 2007-04-02 10:35:28 Providing user based previleges to Postgres DB
Previous Message Thomas Pundt 2007-04-02 08:45:13 Re: How to determine which indexes are not using or using seldom in database