Robert-san, Thank you very much for your comment. I will try to modify it so that GUC can be added more generically. When specifying multiple GUC settings for PQconnectdbParams, is it correct to describe as follows?
-- keywords [n] = "options"; values [n] = "-c work_mem=8MB -c maintenance_work_mem=16MB"; conn = PQconnectdbParams (keywords, values, false); -- There is no explanation about multiple guc settings in the manual for "options". Best regards, Noriyoshi Shinoda. -----Original Message----- From: Robert Haas [mailto:robertmh...@gmail.com] Sent: Saturday, August 25, 2018 4:49 AM To: Shinoda, Noriyoshi (PN Japan GCS Delivery) <noriyoshi.shin...@hpe.com> Cc: pgsql-hack...@postgresql.org Subject: Re: [HACKERS] Proposal to add work_mem option to postgres_fdw module On Fri, Aug 17, 2018 at 2:07 AM Shinoda, Noriyoshi (PN Japan GCS Delivery) <noriyoshi.shin...@hpe.com> wrote: The attached patch adds a new option work_mem to postgres_fdw contrib module. Previously, it was impossible to change the setting of work_mem for remote session with connection by postgres_fdw. It would be nicer to have a generic way to set any GUC, vs. something that only works for work_mem. ...Robert -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
