Re: table partition or index

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: AI Rumman <rummandba(at)gmail(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: table partition or index
Date: 2010-06-13 14:17:46
Message-ID: 20100613141746.GA21875@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* AI Rumman (rummandba(at)gmail(dot)com) wrote:
> For how many records I should go for a table partition instead of using just
> index?
> Any idea please.

General rule of thumb is that you don't need partitioning until you're
into the 100's of millions of records.

Stephen

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2010-06-13 15:07:48 how to alias a table
Previous Message AI Rumman 2010-06-13 13:14:37 table partition or index