Re: How to make runtime partition pruning work?

2019-10-14 Thread David Rowley
On Fri, 11 Oct 2019 at 21:49, Markus Heiden wrote: > > I partitioned a table "data_table" by the key "import_id" to reduce the > number of partitions to be loaded in my queries. > I used list partitions, each containing usually just one "import_id". I > used a primary key (id, import_id) > But Pos

Re: Postgres 10.7 Systemd Startup Issue

2019-10-14 Thread Tom Lane
"Lu, Dan" writes: > Is there a catalog view that I can query to see what options were used > to configure the PG instance? No, but pg_config should tell you. regards, tom lane

Re: Too many SET TimeZone and Application_name queries

2019-10-14 Thread Adrian Klaver
On 10/13/19 10:24 PM, Amarendra Konda wrote: Hi Adrian, Thanks a lot for the response. We are using JDBC Driver 42.2.8 along with the Tomcat Server on Java 8. As part of application code, We are *_not_* setting timezone (or) application names. One observation was, application was querying col