Re: Should I use table partitions

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: "Campbell, Lance" <lance(at)illinois(dot)edu>
Cc: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Should I use table partitions
Date: 2018-10-11 00:51:57
Message-ID: 20181011005157.GD4184@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Greetings,

* Campbell, Lance (lance(at)illinois(dot)edu) wrote:
> Question:
> Should I use table partitions if my table meets the below parameters? The size of the table should remain relatively consistent in size and number of rows. I would not expect it to vary more than 15% at any given time.
>
> Info:
> Table rows: 83,051,164
> Table size only: 25.6 G
> Total size of table including indexes: 38.6 G

Just based on the above info, I'd tend to say "no".

Thanks!

Stephen

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Dean 2018-10-11 15:15:27 pgadmin4
Previous Message Campbell, Lance 2018-10-09 14:18:01 Should I use table partitions