Re: Best way to delete big amount of records from big table

From: Rick Otten <rottenwindfish(at)gmail(dot)com>
To: Ekaterina Amez <ekaterina(dot)amez(at)zunibal(dot)com>
Cc: "pgsql-performa(dot)" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Best way to delete big amount of records from big table
Date: 2020-03-27 15:03:10
Message-ID: CAMAYy4KWhyibeK7dj2AHhm9RtJLdLGX1Zdg+C+nZtW1RKv9SQg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Mar 27, 2020 at 10:14 AM Ekaterina Amez <ekaterina(dot)amez(at)zunibal(dot)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.
https://en.wikipedia.org/wiki/PostgreSQL#Release_history

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pryzby 2020-03-27 15:09:54 Re: Best way to delete big amount of records from big table
Previous Message Ekaterina Amez 2020-03-27 14:56:47 Re: Best way to delete big amount of records from big table