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 06:19:48
Message-ID: 1463465988976-5903923.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Charles Clavadetscher wrote
> Hello
>
> This is quite weird... It there any other process locking the record or
> the table?
> Bye
> Charles

Yes, weird. The table is using by other process (keep inserting rows to the
table) at the same time but no one should lock the row as we dont touch rows
after they've been inserted).

--
View this message in context: http://postgresql.nabble.com/Fast-way-to-delete-big-table-tp5903787p5903923.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2016-05-17 07:22:40 Re: Ascii Elephant for text based protocols - Final
Previous Message Jeff Janes 2016-05-17 06:19:45 Re: Fast way to delete big table?