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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
