Re: Keeping temporary tables in shared buffers

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Keeping temporary tables in shared buffers
Дата
Msg-id 20180620151749.GC7500@momjian.us
обсуждение исходный текст
Ответ на Re: Keeping temporary tables in shared buffers  (Asim Praveen <apraveen@pivotal.io>)
Ответы Re: Keeping temporary tables in shared buffers  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
On Sat, Jun  2, 2018 at 05:18:17PM -0400, Asim Praveen wrote:
> Hi Amit
> 
> On Mon, May 28, 2018 at 4:25 AM, Amit Kapila <amit.kapila16@gmail.com> wrote:
> >
> > This is one way, but I think there are other choices as well.  We can
> > identify and flush all the dirty (local) buffers for the relation
> > being accessed parallelly.  Now, once the parallel operation is
> > started, we won't allow performing any write operation on them.  It
> 
> We talked about this in person in Ottawa and it was great meeting you!
>  To summarize, the above proposal to continue using local buffers for
> temp tables is a step forward, however, it enables only certain kinds
> of queries to be parallelized for temp tables.  E.g. queries changing
> a temp table in any way cannot be parallelized due to the restriction
> of no writes during parallel operation.

Should this be a TODO item?

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: add default parallel query to v10 release notes? (Re: [PERFORM]performance drop after upgrade (9.6 > 10))
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: PATCH: backtraces for error messages