Re: Excessive memory usage in multi-statement queries w/partitioning

Поиск
Список
Период
Сортировка
Искать
От
Julian Schauder
Тема
Re: Excessive memory usage in multi-statement queries w/partitioning
Дата
в 09:18:37
Msg-id
ab06f6d3b4a1775d7a05c03c5b311711f7bb2cc6.camel@credativ.de
Ответ на
Список
Дерево обсуждения
Excessive memory usage in multi-statement queries w/ partitioning Andreas Seltenreich <andreas.seltenreich@credativ.de>
Re: Excessive memory usage in multi-statement queries w/ partitioning David Rowley <david.rowley@2ndquadrant.com>
Re: Excessive memory usage in multi-statement queries w/partitioning Julian Schauder <julian.schauder@credativ.de>
Re: Excessive memory usage in multi-statement queries w/ partitioning David Rowley <david.rowley@2ndquadrant.com>
Re: Excessive memory usage in multi-statement queries w/ partitioning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Excessive memory usage in multi-statement queries w/ partitioning Joe Conway <mail@joeconway.com>
Re: Excessive memory usage in multi-statement queries w/ partitioning David Rowley <david.rowley@2ndquadrant.com>
Re: Excessive memory usage in multi-statement queries w/ partitioning Joe Conway <mail@joeconway.com>
Re: Excessive memory usage in multi-statement queries w/ partitioning Tom Lane <tgl@sss.pgh.pa.us>
Re: Excessive memory usage in multi-statement queries w/ partitioning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Excessive memory usage in multi-statement queries w/ partitioning Tom Lane <tgl@sss.pgh.pa.us>
Re: Excessive memory usage in multi-statement queries w/ partitioning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: Excessive memory usage in multi-statement queries w/ partitioning Julien Rouhaud <rjuju123@gmail.com>
Re: Excessive memory usage in multi-statement queries w/ partitioning Amit Langote <amitlangote09@gmail.com>
Re: Excessive memory usage in multi-statement queries w/ partitioning Tom Lane <tgl@sss.pgh.pa.us>
Re: Excessive memory usage in multi-statement queries w/ partitioning Amit Langote <amitlangote09@gmail.com>
Re: Excessive memory usage in multi-statement queries w/partitioning Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Excessive memory usage in multi-statement queries w/ partitioning Amit Langote <amitlangote09@gmail.com>
Re: Excessive memory usage in multi-statement queries w/ partitioning Tom Lane <tgl@sss.pgh.pa.us>
Re: Excessive memory usage in multi-statement queries w/ partitioning Amit Langote <amitlangote09@gmail.com>
Re: Excessive memory usage in multi-statement queries w/ partitioning Julien Rouhaud <rjuju123@gmail.com>
Re: Excessive memory usage in multi-statement queries w/ partitioning Joe Conway <mail@joeconway.com>
Re: Excessive memory usage in multi-statement queries w/ partitioning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Hey David,


> "multiple statements in a single query", did you mean to write
> session
> or maybe transaction there?

Maybe the wording isn't perfect. It is required that the querys are
sent as a single batch. Try the exact bash-script Andreas used for
updating the parent.

> Which version?

Tested including 11.2. Initially found on 11.1. Memory-consumption
Scales somewhat linearly with existing partitions and ';' delimited
Querys per single Batch.


regards
-- 
Julian Schauder



В списке pgsql-hackers по дате отправления
От: David Rowley
Дата:
От: Peter Eisentraut
Дата:
FAQ