Re: trying to delete most of the table by range of date col

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: trying to delete most of the table by range of date col
Date: 2018-09-03 07:35:16
Message-ID: 4a0271e9-df9e-680e-9b21-636763cb674f@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

Am 03.09.2018 um 09:06 schrieb Justin Pryzby:
> Note, I believe it's planned in the future for foreign keys to support
> referenes to partitioned tables, at which point you could just DROP the monthly
> partition...but not supported right now.

the future is close, that's possible in 11 ;-)

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message pavan95 2018-09-03 07:50:28 Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
Previous Message Achilleas Mantzios 2018-09-03 07:13:47 Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4

Browse pgsql-performance by date

  From Date Subject
Next Message Mariel Cherkassky 2018-09-03 08:17:58 Re: trying to delete most of the table by range of date col
Previous Message Justin Pryzby 2018-09-03 07:06:24 Re: trying to delete most of the table by range of date col