Re: [ADMIN] postgresql-server-8.4.4-1PGDG.el5 - ERROR: could not write block 503414 of temporary file: No space le,ft on device

24GB RAM total. The system is behaving normal now, it does create intermittant 'pgsql_tmp' files, but removes them after the SQL statement completes. We will monitor the logs and try to make informed tweaks to the postgresql settings as needed. Thanks to you and Tom Lane for your res

Re: [ADMIN] postgresql-server-8.4.4-1PGDG.el5 - ERROR: could not write block 503414 of temporary file: No space le,ft on device

ean it's disabled, yet it is creating 1GB files and NOT cleaning them up: -bash-3.2$ du -hs pgsql_tmp/* 15M pgsql_tmp/pgsql_tmp22192.3070 1.1Gpgsql_tmp/pgsql_tmp22192.4916 168Mpgsql_tmp/pgsql_tmp22192.4918 1.1Gpgsql_tmp/pgsql_tmp22192.4919 Thanks you. --irene

[ADMIN] postgresql-server-8.4.4-1PGDG.el5 - ERROR: could not write block 503414 of temporary file: No space le,ft on device

# -1 means use vacuum_cost_delay #autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for # autovacuum, -1 means use # vacuum_cost_limit #vacuum_freeze_min_age = 5000 #vacuum_fre