pg.ddx.io  pgsql-general@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: veem v <veema0000@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Subject: Re: Not able to purge partition
Date: Sun, 24 Mar 2024 15:59:26 +0100
Message-ID: <7f7b1f46cbba679ebd7cd35a3cbf77fc8a4c6312.camel@cybertec.at> (raw)
In-Reply-To: <CAB+=1TWpW0zfrQ5d3FrYVeijggNuDWOak6Fk9e=2Ywg3fdyYUA@mail.gmail.com>
References: <CAB+=1TU3kCsNM7xSHTCCu1AJAbL2-5phVmisLB_uTg-q2wEFvg@mail.gmail.com>
	<c07417320869cfc1f0bededec98cb92298c37df0.camel@cybertec.at>
	<CAB+=1TUg+xCycqewFrMD7KWh6qwutDFHjhv5rO=CUuC2HTowHg@mail.gmail.com>
	<508cb815fafbb0a82c59e451b235a6b9b44a0575.camel@cybertec.at>
	<CAB+=1TW+bnifVFMtC4u5Ok2sjyse54iDK242v47txf4gotU7nw@mail.gmail.com>
	<CAB+=1TWkCnOgQwNAzjqoUYY6QRrwVR84E_vtF2=y7G6RocqO8A@mail.gmail.com>
	<16b303b8cc44eece159d144cf483517c99c61f2a.camel@cybertec.at>
	<CAB+=1TWpW0zfrQ5d3FrYVeijggNuDWOak6Fk9e=2Ywg3fdyYUA@mail.gmail.com>

On Sun, 2024-03-24 at 00:37 +0530, veem v wrote:
> > Instead, use foreign keys between the partitions.
> 
> I am struggling to understand how to maintain those partitions then?
> As because we were planning to use pg_partman for creating and dropping
> partitions automatically without much hassle.

I understand.

But do you want to pursue a way that is not working well, just because
the tool you chose cannot handle it?

Yours,
Laurenz Albe





view thread (17+ messages)  latest in thread

Message-ID: <7f7b1f46cbba679ebd7cd35a3cbf77fc8a4c6312.camel@cybertec.at>
Permalink:  ../7f7b1f46cbba679ebd7cd35a3cbf77fc8a4c6312.camel@cybertec.at/
Also on:    postgresql.org/message-id/7f7b1f46cbba679ebd7cd35a3cbf77fc8a4c6312.camel@cybertec.at

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-general@postgresql.org
  Cc: laurenz.albe@cybertec.at, veema0000@gmail.com, pgsql-general@lists.postgresql.org
  Subject: Re: Not able to purge partition
  In-Reply-To: <7f7b1f46cbba679ebd7cd35a3cbf77fc8a4c6312.camel@cybertec.at>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox