Re: [GENERAL] WAL internals

2006-07-07 Thread Martijn van Oosterhout
On Fri, Jul 07, 2006 at 11:49:13AM +0200, Fabrice Franquenk wrote: > 2. If the result of the transaction is within the shared buffers, we get > our result > instantly. Else some searching is done within the database datafiles to > get the result > which is copied to the shared buffers memory zone

[GENERAL] WAL internals

2006-07-07 Thread Fabrice Franquenk
Hello, I am currently working on a heavily stressed system and i am having some difficulties to make the background writer work properly. But before going any further, i would like to be sure that i understood how transaction processing, and management are handled by postgreSQL. Correct me if i'