Re: Deleting large amount of data.

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).