On Wed, Aug 22, 2012 at 4:06 PM, Nick <nboutelier@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
