Re: Configuration tips for very large database - Mailing list pgsql-performance

From Nico Sabbi
Subject Re: Configuration tips for very large database
Date
Msg-id 54DD2DAD.3090503@poste.it
Whole thread Raw
In response to Re: Configuration tips for very large database  (Kevin Grittner <kgrittn@ymail.com>)
Responses Re: Configuration tips for very large database
List 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 by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Configuration tips for very large database
Next
From: Kevin Grittner
Date:
Subject: Re: Configuration tips for very large database