Re: PostgreSQL 9.2.4 temp files never released?

Em 28/09/2013 15:16, Edson Richter escreveu:
> I've a 12Gb database running without problems in Linux Centos 64bit
> for years now.
> Looking database statistics (in pgAdmin III), I can see that there are
> 366 temporary files, and they sum up 11,863,839,867 bytes in size.
>
> Is that normal? When will this space be released?
>
> I've restarted the server, but seems those files (in number and in
> size) are just growing and growing...
>
> Regards,
>
> Edson Richter
>
>
>
Forgot to mention: it is currently running 9.2.4.
Configuration files has currently the following configuration regarding
work_mem and temporary files:

shared_buffers = 1500MB
temp_buffers = 32MB
max_prepared_transactions = 0
work_mem = 64MB
maintenance_work_mem = 16MB
max_stack_depth = 2MB
temp_file_limit = 4GB
max_files_per_process = 2000

ulimit -a shows:

core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 62703
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 1048576
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 62703
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited