From: Peter Childs <peterachilds@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Massive delete of rows, how to proceed?
Date: Sat, 25 Nov 2006 15:45:19 +0000
Message-ID: <a2de01dd0611250745je59cd36v77d5c7be76601cf2@mail.gmail.com> (raw)
In-Reply-To: <a2de01dd0611250744r4322a39ke886d43bf226b858@mail.gmail.com>
References: <45673D56.10707@andromeiberica.com>
<a2de01dd0611250744r4322a39ke886d43bf226b858@mail.gmail.com>
On 24/11/06, Arnau <arnaulist@andromeiberica.com> wrote:
> Hi all,
>
> I have a table with statistics with more than 15 million rows. I'd
> like to delete the oldest statistics and this can be about 7 million
> rows. Which method would you recommend me to do this? I'd be also
> interested in calculate some kind of statistics about these deleted
> rows, like how many rows have been deleted for date. I was thinking in
> creating a function, any recommendations?
Copy and drop old table. If you delete you will have a massive problem
with a bloated table and vacuum will not help unless you expect the
table to grow to this size regulally otherwise vacuum full will take
ages.
Peter.
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-performance@postgresql.org
Cc: peterachilds@gmail.com
Subject: Re: Massive delete of rows, how to proceed?
In-Reply-To: <a2de01dd0611250745je59cd36v77d5c7be76601cf2@mail.gmail.com>
* 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