Re: [HACKERS] why we need both the collector & buffer process

2002-12-25 Thread William.Jiang
Sorry to say that I cannot see which process is used to do checkpoints. I just see two main functions.  pgstat_recvbuffer(): this function is to receive the information from the postgres .this function is the main body of buffer process pgstat_min():this function is to do the job of  getting info

[HACKERS] MOVE strangeness

2002-12-25 Thread Jeroen T. Vermeulen
Here's something that's been bothering me for a while... Perhaps this is correct behaviour, but I can't quite see how. This does not happen if I replace the FETCHes by MOVEs. Here's the reference case: jtv=> begin; BEGIN jtv=> declare c cursor for select * from events; DECLARE CURSOR jtv=> fetc

Re: [HACKERS] why we need both the collector & buffer process

2002-12-25 Thread Tom Lane
"=?gb2312?q?William.Jiang?=" <[EMAIL PROTECTED]> writes: >I have read the code and I am wondering why we need two processes to do the work. >I think one process can work as well. Are there something special you considered when >you developed this feature? It's a buffering issue. Read the di

[HACKERS] GBorg feature requests

2002-12-25 Thread Jeroen T. Vermeulen
First off, happy holidays to all! Next, can anyone tell me the proper channel for reporting bugs and feature requests for GBorg itself? I've looked around, but I may have missed something. One feature I'd really like, is to have its automatic email notification (for bug reports, status changes e

Re: [HACKERS] why we need both the collector & buffer process

2002-12-25 Thread Bruce Momjian
=?gb2312?q?William.Jiang?= wrote: > > hi,all hackers of postgres > > when postmaster start as a service . another two > processes(collector & buffer ) start their work at the same > time. > >I have read the code and I am wondering why we need two >processes to do the work. I

[HACKERS] about the sql conformance

2002-12-25 Thread postgresql
Hi all, I will to make the SQL 92/99 conformance test for Postgresql, could you give me some advices on which tool can meet the demand ? Great thanks for any message. Josh