Re: Excessive memory usage in multi-statement queries w/partitioning
От
Julian Schauder
Тема
Re: Excessive memory usage in multi-statement queries w/partitioning
Дата
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 по дате отправления
От: Peter Eisentraut
Дата: