| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Vilson farias <vilson(dot)farias(at)digitro(dot)com(dot)br> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Deleting large amount of data. |
| Date: | 2002-08-26 19:49:27 |
| Message-ID: | 20020826124628.C64199-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2002-08-26 21:07:59 | Re: [GENERAL] MSAcess databasse type X PostgreSQL database type |
| Previous Message | Vilson farias | 2002-08-26 19:26:14 | Deleting large amount of data. |