Ravi Krishna <sravikrishna3@gmail.com> 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