How many records to delete ?

From: shulkae <shulkae(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How many records to delete ?
Date: 2010-01-06 21:03:24
Message-ID: 7dc5b11a-fb35-4fee-b597-3f8a2efd1e2a@a21g2000yqc.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am writing a shell script which runs as a cron entry. The objective
is to delete older records from postgresql DB.

I have thousands of records. What is the optimum number of records to
delete in one delete command

( my script will delete records in a loop and I want to ensure that
the swap file created during delete will not cause delete failure
during low disk space condition )

thanks
Shul

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-01-06 22:13:56 Re: timestamp fields and order by?
Previous Message Steve Wampler 2010-01-06 20:57:18 Re: timestamp fields and order by?