Postgres Pro
Downloads
Home   >   mailing lists

Re: Release SPI plans for referential integrity with DISCARD ALL - Mailing list pgsql-hackers

From yuzuko
Subject Re: Release SPI plans for referential integrity with DISCARD ALL
Date
Msg-id CAKkQ50_h8TcBkY5KYQfneejrZ_d3veFcK3nGmN-WxucEu_QrCw@mail.gmail.com
Whole thread Raw
In response to Re: Release SPI plans for referential integrity with DISCARD ALL  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
List pgsql-hackers
Tree view 
Hello,

Thank you for your comments.
Following Corey's advice, I applied Amit's patches proposed in this
email [1], and confirmed our memory pressure problem was solved.
So dropping cached plan with DISCARD is not necessary anymore.

[1] https://www.postgresql.org/message-id/CA%2BHiwqG1qQuBwApueaUfA855UJ4TiSgFkPF34hQDWx3tOChV5w%40mail.gmail.com

-- 
Best regards,
Yuzuko Hosoya
NTT Open Source Software Center

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Single transaction in the tablesync worker?
Next
From: Greg Nancarrow
Date:
Subject: Re: Parallel INSERT (INTO ... SELECT ...)