From: Kevin Grittner <kgrittn@ymail.com>
To: Nico Sabbi <nicola.sabbi@poste.it>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Configuration tips for very large database
Date: Thu, 12 Feb 2015 22:38:01 +0000 (UTC)
Message-ID: <2034701464.2446674.1423780681188.JavaMail.yahoo@mail.yahoo.com> (raw)
In-Reply-To: <54DD2872.3070603@poste.it>
References: <54DD2872.3070603@poste.it>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Nico Sabbi <nicola.sabbi@poste.it> wrote:
> Queries get executed very very slowly, say 20 minutes.
> I'd like to know if someone has already succeeded in running
> postgres with 200-300M records with queries running much faster
> than this.
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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: kgrittn@ymail.com, nicola.sabbi@poste.it
Subject: Re: Configuration tips for very large database
In-Reply-To: <2034701464.2446674.1423780681188.JavaMail.yahoo@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox