[PERFORM] firebird X postgresql 8.1.2 windows, performance comparison

2006-03-10 Thread Andre Felipe Machado
t tell postgresql to actually use windows disk cache. What parameter must be configured? Do you have some suggestions? Regards. Andre Felipe Machado www.techforce.com.br ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will i

Re: [PERFORM] firebird X postgresql 8.1.2 windows, performance comparison

2006-03-07 Thread Andre Felipe Machado
Hello, Many thanks for the valuable suggestions and insights. The defaults enable_bitmapscan and enable_seqscan were altered by my friend. He already re enabled them (maybe even while I was trying some of the queries). The machine is a P4 3.2GHz, 1 GBram, sata hd, windows 2000. I did not used pg on