[BUGS] Re: [BUGS] BUG #7642: Unchecked “stats_temp_directory” causes server hang to requests

2012-11-07 Thread Tianyin Xu
Thanks for the reply, Tom. On Wed, Nov 7, 2012 at 10:53 AM, Tom Lane wrote: > t...@cs.ucsd.edu writes: > > I set the stats_temp_directory='' in my postgresql.conf file, with the > > expectation that the directory would be under the data directory. > > Why would you think that's a good idea? It

Re: [BUGS] BUG #7642: Unchecked “stats_temp_directory” causes server hang to requests

2012-11-07 Thread Tom Lane
t...@cs.ucsd.edu writes: > I set the stats_temp_directory='' in my postgresql.conf file, with the > expectation that the directory would be under the data directory. Why would you think that's a good idea? It's already going to be under the data directory. The only reason to change this setting

[BUGS] Re: [BUGS] BUG #7642: Unchecked “stats_temp_directory” causes server hang to requests

2012-11-07 Thread Tianyin Xu
OSH, why the format becomes so ugly?!! Here's the original mail. Hi, Postgresql, I set the stats_temp_directory='' in my postgresql.conf file, with the expectation that the directory would be under the data directory. However, the server convert the file to “/pgstat.tm

[BUGS] BUG #7642: Unchecked “stats_temp_directory” causes server hang to requests

2012-11-07 Thread tixu
The following bug has been logged on the website: Bug reference: 7642 Logged by: Tianyin Xu Email address: t...@cs.ucsd.edu PostgreSQL version: 9.2.1 Operating system: Linux Description: Hi, Postgresql, I set the stats_temp_directory='' in my postgresql.conf file, wi