Postgres Pro
Downloads
Home   >   mailing lists

Re: Best way to delete big amount of records from big table - Mailing list pgsql-performance

From Rick Otten
Subject Re: Best way to delete big amount of records from big table
Date
Msg-id CAMAYy4KWhyibeK7dj2AHhm9RtJLdLGX1Zdg+C+nZtW1RKv9SQg@mail.gmail.com
Whole thread Raw
In response to Best way to delete big amount of records from big table  (Ekaterina Amez <ekaterina.amez@zunibal.com>)
List pgsql-performance
Tree view


On Fri, Mar 27, 2020 at 10:14 AM Ekaterina Amez <ekaterina.amez@zunibal.com> wrote:

it's there a better way to do this. I'm testing on version 9.2 BUT
production server is 8.4 (legacy application, supposed to be in at least
9.2 but recently discovered it was 8.4, planning upgrade but not now).
Config parameters are default ones.

PostgreSQL 8.4 came out in 2009 and hit EOL in 2014.   PostgreSQL 9.2 hit EOL in 2017.


pgsql-performance by date:

Previous
From: Ekaterina Amez
Date:
Subject: Re: Best way to delete big amount of records from big table
Next
From: Justin Pryzby
Date:
Subject: Re: Best way to delete big amount of records from big table