On 2012-08-22, Nick <nboutelier@gmail.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
