Re: Slow Bulk Delete

2010/5/17 Віталій Тимчишин <tivv00@gmail.com>:
>
>
> 2010/5/17 Jon Nelson <jnelson+pgsql@jamponi.net>
>>
>> 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?
>>
>>
>
> 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