Should I partition this table?

From: AlexK <alkuzo(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Should I partition this table?
Date: 2014-07-10 14:59:20
Message-ID: 1405004360176-5811130.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

My table currently uses up 62 GB of storage, and it has 450 M rows. This
narrow table has a PK on (ParentID, ChildNumber), and it has between 20K and
50K of child rows per parent.

The data is inserted daily, rarely modified, never deleted. The performance
of modifications is not an issue. The only select from it is as follows:

SELECT <column_lis> FROM MyChildTable WHERE ParentID=?
ORDER BY ChildNumber;

The selects are frequent, and their performance is essential.

Would you advice me to partition this table?

TIA

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Should-I-partition-this-table-tp5811130.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2014-07-10 15:20:30 Re: Should I partition this table?
Previous Message Marc Watson 2014-07-10 12:25:03 Re: BAKUP ISSUE