On Sun, Jun 13, 2010 at 9:14 AM, AI Rumman <rumman...@gmail.com> wrote: > For how many records I should go for a table partition instead of using just > index? > Any idea please.
I concur with Stephen. We tend to split our tables when they exceed 100 million rows *if* they are experiencing performance issues, and target them to be no more than 10 million rows each after expected growth over the next few years. I have one table that is very hot that is about 70 million rows I'd like to partition, but it has many FK's pointing to it, which complicates it considerably. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
