On Wed, Aug 22, 2012 at 4:06 PM, Nick <nboutel...@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? > > 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
