Re: Slow Bulk Delete
От
Jon Nelson
Тема
Re: Slow Bulk Delete
Дата
Msg-id
AANLkTimtJy7hLkB5kI9VWBN2DNYg9SvmIiFUolWzV4it@mail.gmail.com
Ответ на
Re: Slow Bulk Delete (Віталій Тимчишин)
Список
Дерево обсуждения
Slow Bulk Delete thilo <thilo.tanner@gmail.com>
Re: Slow Bulk Delete Bob Lunney <bob_lunney@yahoo.com>
Re: Slow Bulk Delete "Pierre C" <lists@peufeu.com>
Re: Slow Bulk Delete Jon Nelson <jnelson+pgsql@jamponi.net>
Re: Slow Bulk Delete "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Re: Slow Bulk Delete Jon Nelson <jnelson+pgsql@jamponi.net>
Re: Slow Bulk Delete Grzegorz Jaśkiewicz <gryzman@gmail.com>
Re: Slow Bulk Delete Віталій Тимчишин <tivv00@gmail.com>
Re: Slow Bulk Delete Jon Nelson <jnelson+pgsql@jamponi.net>
Re: Slow Bulk Delete Grzegorz Jaśkiewicz <gryzman@gmail.com>
2010/5/17 Віталій Тимчишин : > > > 2010/5/17 Jon Nelson >> >> On Mon, May 17, 2010 at 5:10 AM, Pierre C 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
В списке pgsql-performance по дате отправления
