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
обсуждение исходный текст
Ответ на Re: Excessive memory usage in multi-statement queries w/ partitioning  (David Rowley <david.rowley@2ndquadrant.com>)
Список pgsql-hackers
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
Дата:
Сообщение: Should we warn against using too many partitions?
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: "long" type is not appropriate for counting tuples