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

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Excessive memory usage in multi-statement queries w/ partitioning
Дата
Msg-id CAKJS1f-StHT8ZKyC8rsK=nJim13qDWDiNO8NMirTBo_jk=z5Aw@mail.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  (Joe Conway <mail@joeconway.com>)
Список pgsql-hackers
On Sat, 25 May 2019 at 00:18, Joe Conway <mail@joeconway.com> wrote:
> I admittedly haven't followed this thread too closely, but if having 100
> partitions causes out of memory on pg11, that sounds like a massive
> regression to me.

For it to have regressed it would have had to once have been better,
but where was that mentioned?  The only thing I saw was
non-partitioned tables compared to partitioned tables, but you can't
really say it's a regression if you're comparing apples to oranges.

I think the only regression here is in the documents from bebc46931a1
having removed the warning about too many partitions in a partitioned
table at the end of ddl.sgml. As Amit mentions, we'd like to put
something back about that.

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services



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

Предыдущее
От: "Jonathan S. Katz"
Дата:
Сообщение: Re: initdb recommendations
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Aggregate error message