Should I use table partitions

From: "Campbell, Lance" <lance(at)illinois(dot)edu>
To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Should I use table partitions
Date: 2018-10-09 14:18:01
Message-ID: 9398DF2A-8842-431D-98A3-2A12A7B2BFD6@illinois.edu
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgadmin-support

PostgreSQL 10.x

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
Table definition:

CREATE TABLE xyz.abc

(

fk_def_id integer NOT NULL,

id integer NOT NULL DEFAULT nextval(('xyz.abc_id_seq'::text)::regclass),

email_address text,

created_timestamp timestamp with time zone DEFAULT now(),

updated_timestamp timestamp with time zone DEFAULT now(),

provider text,

server_id integer DEFAULT 0,

read_count integer DEFAULT 0,

fk_group_id integer DEFAULT 0,

mail_log_timestamp timestamp with time zone DEFAULT now(),

mail_log_process_code integer DEFAULT '-1'::integer,

mail_log_message text DEFAULT,

mail_log_mail_id text DEFAULT '',

mail_log_rule text DEFAULT '',

is_listserv boolean DEFAULT false,

is_bad_email_address boolean DEFAULT false,

bad_email_address_message text DEFAULT '',

finder text DEFAULT '',

constituent_id text DEFAULT '',

CONSTRAINT abc_pkey PRIMARY KEY (id)

);

Thanks,

Lance Campbell

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Stephen Frost 2018-10-11 00:51:57 Re: Should I use table partitions
Previous Message Murtuza Zabuawala 2018-10-06 16:59:33 Re: PgAdmin 4 GUI is not launching properly in Windows desktop