On 7/01/2010 5:03 AM, shulkae wrote:
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
shulkae wrote:
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
as many as you need to,
DELETE FROM yourtable AS t
On Wed, Jan 6, 2010 at 22:03, shulkae wrote:
[...]
> I have thousands of records. What is the optimum number of records to
> delete in one delete command
Optimum in which way?
--
- Rikard - http://bos.hack.org/cv/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
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
