Kasahara Tatsuhito
Kasahara Tatsuhito
Hi, >"2021-11-02 17:38:46.079 CST,,3954,,61810386.f72,3,,2021-11-02 17:23:18 CST,,0,LOG,00000, "received fast shutdown request",,,,,,,,,"" So it looks like a normal shutdown of PostgreSQL, not a crash. Is someone, or some external tool, stopping PostgreSQL...
Hi. Are you pointing out that the join between the chn(char_name) table and the other tables is not a Hash Join as a problem ? If so, please try following...
Hi. Which PostgreSQL version did you install ? PostgreSQL 11.x ? It seems to me that you installed Inappropriate PostgreSQL version for pg_hint_plan-REL11. Or if you installed PostgreSQL 11.x, please...
Hi, Do you have any other PostgreSQL version in the environment ? Which PATH did you install PostgreSQL 11.x ? Or if you used RPM packages, you need a postgresql11-devel....
Sorry for late reply and thanks for your PR and tests. I confirmed that passed installcheck with this PR and PostgreSQL12.3. will planning merge this PR and release new version...
Hi. Yeah, I think it's a reasonable fix. The time and interval types are also affected by this bug...
Hi. Thanks for your report. I confirmed and could reproduce this problem. When issue CREATE EXTENSION, pg_store_plans parses the query string for entire script per execute each query in the...
Hi, sorry for late reply. If you want to disable pg_dbms_stats, please remove "pg_dbms_stats" from shared_preload_libraries at postgresql.conf, and restart PostgreSQL (pg_ctl restart). regards,
> is there any way to archive that without restarting the postgreSQL server ? If you want to avoid server restart, please add "pg_dbms_stats.use_locked_stats = off" to postgresql.conf and reload...