Re: Scaling SELECT:s with the number of disks on a stripe - Mailing list pgsql-performance

From Peter Schuller
Subject Re: Scaling SELECT:s with the number of disks on a stripe
Date
Msg-id 20070402103443.GA57038@hyperion.scode.org
Whole thread Raw
In response to Re: Scaling SELECT:s with the number of disks on a stripe  ("Marc Mamin" <M.Mamin@intershop.de>)
List 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.schuller@infidyne.com>'
Key retrieval: Send an E-Mail to getpgpkey@scode.org
E-Mail: peter.schuller@infidyne.com Web: http://www.scode.org


Attachment

pgsql-performance by date:

Previous
From: Andreas Kostyrka
Date:
Subject: Re: How to determine which indexes are not using or using seldom in database
Next
From: Gaetano Mendola
Date:
Subject: Re: Wrong plan sequential scan instead of an index one [8.2 solved it]