Quick Links

Re: Slow Bulk Delete

From:	Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>
To:
Cc:	pgsql-performance(at)postgresql(dot)org
Subject:	Re: Slow Bulk Delete
Date:	2010-05-17 11:54:26
Message-ID:	AANLkTinEPzUlYprV0Cm5rvFPl5AQg08483pxAgSIxAnJ@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-performance

On Mon, May 17, 2010 at 5:10 AM, Pierre C <lists(at)peufeu(dot)com> wrote:
> - or use a JOIN delete with a virtual VALUES table
> - or fill a temp table with ids and use a JOIN DELETE

What is a virtual VALUES table? Can you give me an example of using a
virtual table with selects, joins, and also deletes?

--
Jon

In response to

Re: Slow Bulk Delete at 2010-05-17 10:10:31 from Pierre C

Responses

Re: Slow Bulk Delete at 2010-05-17 12:07:17 from Віталій Тимчишин
Re: Slow Bulk Delete at 2010-05-17 12:15:52 from Grzegorz Jaśkiewicz
Re: Slow Bulk Delete at 2010-05-17 12:28:16 from A. Kretschmer

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Віталій Тимчишин	2010-05-17 12:07:17	Re: Slow Bulk Delete
Previous Message	Scott Marlowe	2010-05-17 10:25:24	Re: old server, new server, same performance