From: A. Kretschmer <andreas.kretschmer@schollglas.com>
To: pgsql-performance@postgresql.org
Subject: Re: Slow Bulk Delete
Date: Mon, 17 May 2010 14:28:16 +0200
Message-ID: <20100517122816.GA31501@a-kretschmer.de> (raw)
In-Reply-To: <AANLkTinEPzUlYprV0Cm5rvFPl5AQg08483pxAgSIxAnJ@mail.gmail.com>
References: <f923f5db-a6b1-4029-8ebe-a6d1cc35932a@e2g2000yqn.googlegroups.com>
<op.vcug7tj0eorkce@immo.peufeu.com>
<AANLkTinEPzUlYprV0Cm5rvFPl5AQg08483pxAgSIxAnJ@mail.gmail.com>
In response to Jon Nelson :
> On Mon, May 17, 2010 at 5:10 AM, Pierre C <lists@peufeu.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?
Something like this:
test=# select * from foo;
c1
----
1
2
3
4
(4 rows)
test=*# delete from foo using (values (1),(2) ) as bla where foo.c1=bla.column1;
DELETE 2
test=*# select * from foo;
c1
----
3
4
(2 rows)
values (1), (2) as bla -> returns a 'virtual table' bla with one
column column1.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: andreas.kretschmer@schollglas.com
Subject: Re: Slow Bulk Delete
In-Reply-To: <20100517122816.GA31501@a-kretschmer.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox