Re: [PERFORM] filesystem option tuning

2004-05-29 Thread Tom Lane
Shridhar Daithankar <[EMAIL PROTECTED]> writes: > On Wednesday 19 May 2004 13:02, [EMAIL PROTECTED] wrote: > - If you can put WAL on separate disk(s), all the better. >> >> Does that mean only the xlog, or also the clog? > You can put clog and xlog on same drive. You can, but I think you shouldn

Re: [PERFORM] filesystem option tuning

2004-05-29 Thread Shridhar Daithankar
On Wednesday 19 May 2004 13:02, [EMAIL PROTECTED] wrote: > > - If you can put WAL on separate disk(s), all the better. > > Does that mean only the xlog, or also the clog? As far as I understand, the > clog contains some meta-information on the xlog, so presumably it is > flushed to disc synchrono

[PERFORM] Logging all query in one seperate File

2004-05-29 Thread rajaguru
Hai all,   I want to log my queries send to the Postgresql server. I heard that we can do this my specifying the file name in /etc/rc.d/init.d/Postgresql  initiating file. But I don’t know. If this is the way means how to do that. Or anyother way is there.   Thanks is advance