On Tue, May 15, 2018 at 03:02:48PM +0000, ChatPristi wrote: > I got the error with PG 10.3 and 10.4 on CentOS 7 up-to-date.The > command works with a smaller size database. > The command works with the same database with PG 9.3.19 on RHEL 6.9 > up-to-date. > > I attach the EXPLAIN SELECT command.
Well, instead of an explain output which takes 2.4MB compressed and 9.6MB uncompressed (take it as unreadable), could you produce a self-contained test case with a glimpse of the schema you are using? Where does the OOM happen, and how did you change your partitioned table schema? Are you using the native partitioning instead? -- Michael
signature.asc
Description: PGP signature
