[SQL] Process priority.

2005-03-17 Thread Theo Galanakis
Title: Process priority. Hi, I wrote a C program that can be called through postgres via stored procedures. It allows you to change the current postmaster process priority. Essentially it's intended purpose would be to allow a highly resource intensive postmaster process to run at a lower

Re: [SQL] Process priority.

2005-03-17 Thread Tom Lane
Theo Galanakis [EMAIL PROTECTED] writes: I wrote a C program that can be called through postgres via stored procedures. It allows you to change the current postmaster process priority. You are aware that that's widely considered either useless or counterproductive? Renice-ing one backend

Re: [SQL] Process priority.

2005-03-17 Thread Theo Galanakis
Title: RE: [SQL] Process priority. It depends what the intended purpose if for. In our scenario, there are a number of ad-hoc export tasks running during the day that are quite cpu intensive. There is a noticeably slow response time when exports are being run. By lowering the priority