Re: Configuration tips for very large database

Поиск
Список
Период
Сортировка
От Nico Sabbi
Тема Re: Configuration tips for very large database
Дата
Msg-id 54DD2DAD.3090503@poste.it
обсуждение исходный текст
Ответ на Re: Configuration tips for very large database  (Kevin Grittner <kgrittn@ymail.com>)
Ответы Re: Configuration tips for very large database  (Kevin Grittner <kgrittn@ymail.com>)
Список pgsql-performance
On 02/12/2015 11:38 PM, Kevin Grittner wrote:
>
> If you go to the http://wcca.wicourts.gov/ web site, bring up any
> case, and click the "Court Record Events" button, it will search a
> table with hundreds of millions of rows.  The table is not
> partitioned, but has several indexes on it which are useful for
> queries such as the one that is used when you click the button.
>
> --
> Kevin Grittner
> EDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>

Impressive. Can you give any hint on the configuration and on the
underlying hardware?


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

Предыдущее
От: Kevin Grittner
Дата:
Сообщение: Re: Configuration tips for very large database
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: Configuration tips for very large database