From: Kevin Grittner <kgrittn@ymail.com>
To: Naresh Soni <jmnaresh@gmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Hi Community
Date: Mon, 2 Feb 2015 14:32:45 +0000 (UTC)
Message-ID: <1123309468.541729.1422887565854.JavaMail.yahoo@mail.yahoo.com> (raw)
In-Reply-To: <CADg8u6kEOrqzmVE8BY34RAE_XzxQE9ZvjFz--v1q7jZNxj58wg@mail.gmail.com>
References: <CADg8u6kEOrqzmVE8BY34RAE_XzxQE9ZvjFz--v1q7jZNxj58wg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Naresh Soni <jmnaresh@gmail.com> wrote:
> This is my first question on the list, I wanted to ask if
> postgres can handle multi millions records? for example there
> will be 1 million records per table per day, so 365 millions per
> year.
Yes, I have had hundreds of millions of rows in a table without
performance problems. If you want to see such a table in action,
go to the following web site, bring up a court case, and click the
"Court Record Events" button. Last I knew the table containing
court record events had about 450 million rows, with no
partitioning. The total database was 3.5 TB.
http://wcca.wicourts.gov/> Is yes, then please elaborate.
You will want indexes on columns used in the searches. Depending
on details you have not provided it might be beneficial to
partition the table. Do not consider partitioning to be some
special magic which always makes things faster, though -- it can
easily make performance much worse if it is not a good fit.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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-admin@postgresql.org
Cc: kgrittn@ymail.com, jmnaresh@gmail.com
Subject: Re: Hi Community
In-Reply-To: <1123309468.541729.1422887565854.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