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 12:28:38 |
Message-ID: | AANLkTimtJy7hLkB5kI9VWBN2DNYg9SvmIiFUolWzV4it@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
2010/5/17 Віталій Тимчишин <tivv00(at)gmail(dot)com>:
>
>
> 2010/5/17 Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>
>>
>> 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?
>>
>>
>
> delete from a using (values (1),(2),(5),(8)) b(x) where a.id=b.x
> See http://www.postgresql.org/docs/8.4/static/sql-values.html
This syntax I'm familiar with. The author of the previous message
(Pierre C) indicated that there is a concept of a virtual table which
could be joined to. I'd like to know what this virtual table thing
is, specifically in the context of joins.
--
Jon
From | Date | Subject | |
---|---|---|---|
Next Message | Grzegorz Jaśkiewicz | 2010-05-17 12:33:09 | Re: Slow Bulk Delete |
Previous Message | A. Kretschmer | 2010-05-17 12:28:16 | Re: Slow Bulk Delete |