Re: 110,000,000 rows - Mailing list pgsql-general

From Vick Khera
Subject Re: 110,000,000 rows
Date
Msg-id AANLkTikBL_67Y-6N1KtKkvspiAZJWSAUQlzhZOWUjPfU@mail.gmail.com
Whole thread Raw
In response to 110,000,000 rows  (John Gage <jsmgage@numericable.fr>)
List pgsql-general
On Wed, May 26, 2010 at 4:29 PM, John Gage <jsmgage@numericable.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.

pgsql-general by date:

Previous
From: Alex Thurlow
Date:
Subject: Re: 110,000,000 rows
Next
From: Thom Brown
Date:
Subject: Re: 110,000,000 rows