| From: | "Charles Clavadetscher" <clavadetscher(at)swisspug(dot)org> |
|---|---|
| To: | "'hmzha2'" <Haiming(dot)Zhang(at)redflex(dot)com(dot)au>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Fast way to delete big table? |
| Date: | 2016-05-17 05:47:02 |
| Message-ID: | 00a301d1afff$8f3cc1e0$adb645a0$@swisspug.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello
> The reason I dont have condition when selecting is it's faster than having.
> Because my aim is to go through every row, find values of few columns and append them to a summary table. Then
> delete the row from the table. So find the rows on the fly is fine for me.
>
> I have tried to reduce the number of rows to be processed, even I process 1 row in production machine, it takes 24
> hours to finish.
This is quite weird... It there any other process locking the record or the table?
Bye
Charles
>
> Regards,
> Haiming
>
>
>
> --
> View this message in context: http://postgresql.nabble.com/Fast-way-to-delete-big-table-tp5903787p5903917.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org) To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2016-05-17 06:19:45 | Re: Fast way to delete big table? |
| Previous Message | hmzha2 | 2016-05-17 05:22:47 | Re: Fast way to delete big table? |