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

Поиск
Список
Период
Сортировка
От Peter Schuller
Тема Re: Scaling SELECT:s with the number of disks on a stripe
Дата
Msg-id 20070402103443.GA57038@hyperion.scode.org
обсуждение исходный текст
Ответ на Re: Scaling SELECT:s with the number of disks on a stripe  ("Marc Mamin" <M.Mamin@intershop.de>)
Список 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


Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Andreas Kostyrka
Дата:
Сообщение: Re: How to determine which indexes are not using or using seldom in database
Следующее
От: Gaetano Mendola
Дата:
Сообщение: Re: Wrong plan sequential scan instead of an index one [8.2 solved it]