Re: time taking deletion on large tables - Mailing list pgsql-admin

On Thu, Dec 03, 2020 at 08:15:06PM +0530, Atul Kumar wrote:
> Hi,
> 
> The feed_posts table has over 50 Million rows.
> 
> When I m deleting all rows of a certain type that are over 60 days old.

The common solution to this problem is to partition, and then, instead
of deleting rows - delete old partitions.

depesz