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.
