Re: Should I use table partitions - Mailing list pgadmin-support

From Stephen Frost
Subject Re: Should I use table partitions
Date
Msg-id 20181011005157.GD4184@tamriel.snowman.net
Whole thread Raw
In response to Should I use table partitions  ("Campbell, Lance" <lance@illinois.edu>)
List pgadmin-support
Greetings,

* Campbell, Lance (lance@illinois.edu) wrote:
> Question:
> Should I use table partitions if my table meets the below parameters?  The size of the table should remain relatively
consistentin 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

Attachment

pgadmin-support by date:

Previous
From: "Campbell, Lance"
Date:
Subject: Should I use table partitions
Next
From: Dean
Date:
Subject: pgadmin4