Re: Configuration tips for very large database

From: Nico Sabbi <nicola(dot)sabbi(at)poste(dot)it>
To: Kevin Grittner <kgrittn(at)ymail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Configuration tips for very large database
Date: 2015-02-12 22:48:13
Message-ID: 54DD2DAD.3090503@poste.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2015-02-12 22:55:20 Re: Configuration tips for very large database
Previous Message Kevin Grittner 2015-02-12 22:38:01 Re: Configuration tips for very large database