Ravi Krishna <sravikrishna3@xxxxxxxxx> writes: > Is there a rule of thumb as to at what size does the partitioning > start performing better than non partitioned table. Personally I'd not worry about partitioning until I had a table approaching maybe a billion (1e9) rows. You could argue that an order of magnitude either way, but it's just not worth the extra complexity for data volumes very much less than that. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
