Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YM2Rq-0005mL-LN for pgsql-performance@arkaria.postgresql.org; Thu, 12 Feb 2015 22:41:26 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YM2Rq-00024h-2R for pgsql-performance@arkaria.postgresql.org; Thu, 12 Feb 2015 22:41:26 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YM2Ro-00024b-VW for pgsql-performance@postgresql.org; Thu, 12 Feb 2015 22:41:25 +0000 Received: from relay-pt2.poste.it ([62.241.5.253]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YM2Rg-0002Lx-V4 for pgsql-performance@postgresql.org; Thu, 12 Feb 2015 22:41:23 +0000 Received: from localhost.localdomain (151.61.218.152) by relay-pt2.poste.it (8.5.142) (authenticated as nicola.sabbi@poste.it) id 54B70389008269A7; Thu, 12 Feb 2015 23:41:12 +0100 Message-ID: <54DD2DAD.3090503@poste.it> Date: Thu, 12 Feb 2015 23:48:13 +0100 From: Nico Sabbi User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130625 Thunderbird/17.0.7 MIME-Version: 1.0 To: Kevin Grittner CC: "pgsql-performance@postgresql.org" Subject: Re: Configuration tips for very large database References: <54DD2872.3070603@poste.it> <2034701464.2446674.1423780681188.JavaMail.yahoo@mail.yahoo.com> In-Reply-To: <2034701464.2446674.1423780681188.JavaMail.yahoo@mail.yahoo.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org 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? -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance