From: Smita Mahadik <smita.mahadik@fedex.com>
To: pgsql-sql@postgresql.org
Subject: Commiting after certain no of rows have been deleted
Date: Fri, 16 Dec 2005 13:37:33 -0600
Message-ID: <006d01c60278$2943d440$86ea52c7@smita> (raw)
Hi,
In my application I m deleteing large no of rows from table based on certain condition. This takes lot of time and if sometimes my application fails it starts all over again...since the coomit is done at the end of transactions. Is there a way i can do commit when certain no of rows have been deleted? For eg if i need to delete 2 million rows i should be able to commit after say 10,000 rows.
Regards
smita
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-sql@postgresql.org
Cc: smita.mahadik@fedex.com
Subject: Re: Commiting after certain no of rows have been deleted
In-Reply-To: <006d01c60278$2943d440$86ea52c7@smita>
* 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