On Wed, Aug 22, 2012 at 4:06 PM, 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?
>
> For example, maybe if the index size is 6x the amount of ram, if the table is 10% of total disk space, etc?
>
>
Performance on a big table is going to depend very heavily on the
sorts of queries executed against it. I don't think you can come up
with a rule of thumb of that sort.
Best Wishes,
Chris Travers