[ADMIN] Max files per process..

2007-02-20 Thread Eamonn Kent
Hi, We are using Postgres 8.1.4 for an embedded linux device. I have max_files_per_process unset - so it should take on the default value of 1000. However, it appears that at times, postmaster has 1023 files open (lsof). My understanding is that if postgres exceeds this limit, it will

[ADMIN] Setting CLIENT_MIN_MESSAGES dynamically...

2006-09-05 Thread Eamonn Kent
Hi, My config file has the following setting: log_min_messages = fatal This setting assures that postgres logging is minimal. However, I would like to change this setting dynamically while our embedded application is running, without restarting postgres. For example, in the case

[ADMIN] Vacuum issues..

2006-08-21 Thread Eamonn Kent
Hi, I am using PostgreSQL 8.1.4 for an embedded application. For some reason, vacuum is not able to identify rows that are candidates for removal (i.e., mark space as available). Background Info: I observed some performance problems our database seemed to be using an unusually