On Mon, 2004-01-05 at 14:57, David Teran wrote: > ... wow: > > executing a batch file with about 4250 selects, including lots of joins > other things PostgreSQL 7.4 is about 2 times faster than FrontBase > 3.6.27. OK, we will start to make larger tests but this is quite > interesting already: we did not optimize a lot, just invoked VACUUM > ANALYZE and then the selects ;-) > > Thanks to all who answered to this thread.
I presume that batch file was executed linearly -- no parallelism? You're actually testing one of PostgreSQL's shortcomings. PostgreSQL (in my experience) does much better in such comparisons with a parallel load -- multiple connections executing varied work (short selects, complex selects, inserts, updates, deletes). Anyway, just a tip that you will want to test your actual load. If you do batch work with a single thread, what you have is fine. But if you have a website with tens or hundreds of simultaneous connections then your non-parallel testing will not reflect that work load. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster