Re: Scrub one large table against another

От: Tom Lane
Тема: Re: Scrub one large table against another
Дата: ,
Msg-id: 13912.1160520427@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: Scrub one large table against another  (Brendan Curran)
Ответы: Re: Scrub one large table against another  (Brendan Curran)
Список: pgsql-performance

Скрыть дерево обсуждения

Scrub one large table against another  (Brendan Curran, )
 Re: Scrub one large table against another  (Tom Lane, )
  Re: Scrub one large table against another  (Brendan Curran, )
   Re: Scrub one large table against another  (Tom Lane, )
    Re: Scrub one large table against another  (Brendan Curran, )
     Re: Scrub one large table against another  ("Jim C. Nasby", )
     Re: Scrub one large table against another  (Tom Lane, )
      Re: Scrub one large table against another  (Brendan Curran, )
       Re: Scrub one large table against another  ("Jim C. Nasby", )
        Re: Scrub one large table against another  (Brendan Curran, )
         Re: Scrub one large table against another  (Tom Lane, )
 Re: Scrub one large table against another (vmstat output)  (Brendan Curran, )
  Re: Scrub one large table against another (vmstat output)  (Markus Schaber, )

Brendan Curran <> writes:
> Tom Lane wrote:
>> Have you tried doing EXPLAIN ANALYZE of each of the INSERT/DELETE steps?

> FIRST INSERT (Just the select is explained):

EXPLAIN ANALYZE, please, not just EXPLAIN.

            regards, tom lane


В списке pgsql-performance по дате сообщения:

От: Brian Herlihy
Дата:
Сообщение: Re: Simple join optimized badly?
От: "Bucky Jordan"
Дата:
Сообщение: Re: Simple join optimized badly?