Re: Should I partition this table?

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

Kevin,

What would be the advantages of partitioning on ranges of ParentID? Each
query will touch at most one partition. I might or might not get PK indexes
one level of depth less.

I understand that I will CLUSTER these smaller tables and benefit from that.
Other than clustering, what are other advantages?

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yves Dorfsman 2014-07-10 18:56:22 checkpoint
Previous Message Kevin Grittner 2014-07-10 18:14:20 Re: Should I partition this table?