Re: Excessive memory usage in multi-statement queries w/partitioning - Mailing list pgsql-hackers

From Julian Schauder
Subject Re: Excessive memory usage in multi-statement queries w/partitioning
Date
Msg-id ab06f6d3b4a1775d7a05c03c5b311711f7bb2cc6.camel@credativ.de
Whole thread Raw
In response to Re: Excessive memory usage in multi-statement queries w/ partitioning  (David Rowley <david.rowley@2ndquadrant.com>)
List 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 by date:

Previous
From: David Rowley
Date:
Subject: Should we warn against using too many partitions?
Next
From: Peter Eisentraut
Date:
Subject: Re: "long" type is not appropriate for counting tuples