Re: 110,000,000 rows

From: Vick Khera <vivek(at)khera(dot)org>
To: PostgreSQL - General <pgsql-general(at)postgresql(dot)org>
Subject: Re: 110,000,000 rows
Date: 2010-05-26 21:13:02
Message-ID: AANLkTikBL_67Y-6N1KtKkvspiAZJWSAUQlzhZOWUjPfU@mail.gmail.com
Views: Raw Message | Whole Thread | 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.

/me stands and waves hand. I have two tables in my primary app that
are on this magnitude. Each is served by 100 partitions split on mod
100 of the primary key as that worked out well for my use case.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2010-05-26 21:13:38 Re: 110,000,000 rows
Previous Message Alex Thurlow 2010-05-26 20:36:46 Re: 110,000,000 rows