Re: how to efficiently update tuple in many-to-many relationship?

От: Tom Lane
Тема: Re: how to efficiently update tuple in many-to-many relationship?
Дата: ,
Msg-id: 14019.1176155022@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: how to efficiently update tuple in many-to-many relationship?  (Drew Wilson)
Ответы: Re: how to efficiently update tuple in many-to-many relationship?  (Drew Wilson)
Список: pgsql-performance

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

how to efficiently update tuple in many-to-many relationship?  (Drew Wilson, )
 Re: how to efficiently update tuple in many-to-many relationship?  ("Merlin Moncure", )
 Re: how to efficiently update tuple in many-to-many relationship?  (Tom Lane, )
  Re: how to efficiently update tuple in many-to-many relationship?  (Drew Wilson, )
   Re: how to efficiently update tuple in many-to-many relationship?  (Tom Lane, )
    Re: how to efficiently update tuple in many-to-many relationship?  (Drew Wilson, )
     Re: how to efficiently update tuple in many-to-many relationship?  (Tom Lane, )
      Re: how to efficiently update tuple in many-to-many relationship?  (Drew Wilson, )
       Re: how to efficiently update tuple in many-to-many relationship?  (Tom Lane, )
        Question about memory allocations  (Steve, )
         Re: Question about memory allocations  (Tom Lane, )
          Re: Question about memory allocations  (Steve, )
         Re: Question about memory allocations  (Greg Smith, )
          Re: Question about memory allocations  (Steve, )
         Re: Question about memory allocations  (Andrew McMillan, )
          Re: Question about memory allocations  (Steve, )
           Re: Question about memory allocations  (Ron, )
            Re: Question about memory allocations  (Tom Lane, )
           Re: Question about memory allocations  (Carlos Moreno, )
            Re: Question about memory allocations  ("Jan de Visser", )

Drew Wilson <> writes:
> I have 2 tables (A,B) joined in a many-to-many relationship via a
> join table ("membership"), where updating table A based on table B
> takes a very long time.
> ...
>     ->  Function Scan on a  (cost=0.00..12.50 rows=1000 width=4)

I think you've left out some relevant details ... there's nothing
in what you said about a set-returning function ...

            regards, tom lane


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

От: Tom Lane
Дата:
Сообщение: Re: how to efficiently update tuple in many-to-many relationship?
От: Drew Wilson
Дата:
Сообщение: Re: how to efficiently update tuple in many-to-many relationship?