Postgres Pro
Downloads
Home   >   mailing lists

Re: table partition or index - Mailing list pgsql-general

From Stephen Frost
Subject Re: table partition or index
Date
Msg-id 20100613141746.GA21875@tamriel.snowman.net
Whole thread Raw
In response to table partition or index  (AI Rumman <rummandba@gmail.com>)
List pgsql-general
Tree view 
* AI Rumman (rummandba@gmail.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
Attachment

pgsql-general by date:

Previous
From: AI Rumman
Date:
Subject: table partition or index
Next
From: Ivan Sergio Borgonovo
Date:
Subject: how to alias a table