On Mon, 26 Aug 2002, Vilson farias wrote:
> Greetings,
>
> I'm having some perfomance problems related with large amount of
> tuples in a table, so I decided to start programming some shell
> scripts to be placed in crontad to remove old data every night.
Hmm, you might want to send some info on the schema/queries/explain
output, maybe someone'll be able to help.
>
> Now, my questions are :
>
> If I just execute a DELETE * FROM WHERE call_start < '2002-08-21'
> and call_start > '2002-08-20', and that interval has 100.000 tuples,
> does DELETE start and commit a transaction for every single deletion?
No. It's all one statement, so it'll be in its containing transaction (if
you haven't started one, it'll be put into its own).