Re: Fast way to delete big table?

From: hmzha2 <Haiming(dot)Zhang(at)redflex(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Fast way to delete big table?
Date: 2016-05-17 05:03:44
Message-ID: 1463461424463-5903917.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Charles,

Thanks.

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.

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hmzha2 2016-05-17 05:22:47 Re: Fast way to delete big table?
Previous Message Charles Clavadetscher 2016-05-17 04:58:14 Re: Ascii Elephant for text based protocols - Final