| From: | David Wilson <david(dot)t(dot)wilson(at)gmail(dot)com> |
|---|---|
| To: | John Gage <jsmgage(at)numericable(dot)fr> |
| Cc: | PostgreSQL - General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: 110,000,000 rows |
| Date: | 2010-05-26 22:06:29 |
| Message-ID: | AANLkTikMcx-e04C2KdDsB8bRrarZ9r2d3aqolhHjFVeV@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, May 26, 2010 at 4:29 PM, John Gage <jsmgage(at)numericable(dot)fr> wrote:
> Please forgive this intrusion, and please ignore it, but how many
> applications out there have 110,000,000 row tables? I recently multiplied
> 85,000 by 1,400 and said now way Jose.
>
>
I've got a DB with two 500,000,000+ row tables. Performance is quite good
even on very limited hardware if you set up the tables correctly (cluster,
indices, etc) and have a reasonable usage pattern.
--
- David T. Wilson
david(dot)t(dot)wilson(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | david | 2010-05-26 22:18:17 | Re: 110,000,000 rows |
| Previous Message | Dann Corbit | 2010-05-26 21:41:48 | Re: 110,000,000 rows |