How many records to delete ? - Mailing list pgsql-general

From shulkae
Subject How many records to delete ?
Date
Msg-id 7dc5b11a-fb35-4fee-b597-3f8a2efd1e2a@a21g2000yqc.googlegroups.com
Whole thread Raw
Responses Re: How many records to delete ?  (Rikard Bosnjakovic <rikard.bosnjakovic@gmail.com>)
Re: How many records to delete ?  (John R Pierce <pierce@hogranch.com>)
Re: How many records to delete ?  (Craig Ringer <craig@postnewspapers.com.au>)
List 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

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Minimizing disk space
Next
From: Iain Barnett
Date:
Subject: How to call SETOF function?