From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | maxim(dot)boguk(at)gmail(dot)com |
Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #15372: pg_stat_statements extension ignore stats_temp_directory setting and always write into pg_stat_tmp |
Date: | 2018-09-08 11:11:30 |
Message-ID: | 13344.1536405090@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
=?utf-8?q?PG_Bug_reporting_form?= <noreply(at)postgresql(dot)org> writes:
> pg_stat_statements extension always write pgss_query_texts.stat file into
> data_directory/pg_stat_tmp
> and ignore stats_temp_directory settings which supposed to overwrite stat
> directory location.
This is operating as designed, see comment in pg_stat_statements.c:
/*
* Location of external query text file. We don't keep it in the core
* system's stats_temp_directory. The core system can safely use that GUC
* setting, because the statistics collector temp file paths are set only once
* as part of changing the GUC, but pg_stat_statements has no way of avoiding
* race conditions. Besides, we only expect modest, infrequent I/O for query
* strings, so placing the file on a faster filesystem is not compelling.
*/
#define PGSS_TEXT_FILE PG_STAT_TMP_DIR "/pgss_query_texts.stat"
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2018-09-08 11:56:23 | Re: BUG #15367: Crash in pg_fe_scram_free when using foreign tables |
Previous Message | David G. Johnston | 2018-09-08 07:41:45 | Re: BUG #15371: a user who not a member of pg_read_server_files role can create a new user into pg_read_server_files |