On 2012-08-22, 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? 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
