Re: At what point does a big table start becoming too big?

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: At what point does a big table start becoming too big?
Date: 2012-08-23 11:55:36
Message-ID: k155no$8pd$2@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2012-08-22, Nick <nboutelier(at)gmail(dot)com> wrote:
> I have a table with 40 million rows and haven't had any performance issues yet.
>
> Are there any rules of thumb as to when a table starts getting too big?

when you need to run a query that needs to fetch too many rows.

> For example, maybe if the index size is 6x the amount of ram,
> if the table is 10% of total disk space, etc?

If you only need one row at a time and you have the indices for it
no size is too big, the larger they are the more impressive
indices are. O(log(n)) beats O(n) more and more as n grows.

--
⚂⚃ 100% natural

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Anthony 2012-08-23 12:00:07 Re: Amazon High I/O instances
Previous Message Vincent Veyron 2012-08-23 11:39:47 Re: Amazon High I/O instances