PostgreSQL log warnings: open temporary statistics file, pgstat wait timeout

Asked Jan 20 '14 at 05:46

Active Aug 18 '15 at 08:31

Viewed 2,013 times

We frequently get the following warnings with our Postgresql Database

LOG: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp": No space left on device
WARNING: pgstat wait timeout

When we get the above two warnings, our database connectivity to our website throws a connectivity error and while restarting the Database service then the connectivity looks good for a while.

What could be possible reasons behind this?

I have checked the free space left in the server which is 14 GB.

edited Jan 20 '14 at 11:36

Craig Ringer

11,083
9
40
61

asked Jan 20 '14 at 05:46

Big Data

Please show: `SELECT version()`, how you installed PostgreSQL, and your OS/distro/version. – Craig Ringer Jan 20 '14 at 05:59
1

Also the output of the queries `SHOW data_directory;`, `SHOW temp_tablespaces;`, and the "df -h" command on the shell. – Craig Ringer Jan 20 '14 at 08:57

PostgreSQL log warnings: open temporary statistics file, pgstat wait timeout

0 Answers0