On 10/01/2008, Matthew T. O'Connor <matthew@xxxxxxxx> wrote: > Pavel Stehule wrote: > > pgbench test - default configuration > > > > Verze 7.3.15 7.4.13 8.0.8 8.1.4 8.2.beta1 8.3beta1 > > tps 311 340 334 398 423 585 > > > > but pgbench is simple test and thise numbers hasnot great value. > > Was that the same version of pgbench each time? Or was it the pgbench > that came with each version? I think pgbench has changed a few times, > if you are using different versions of pgbench, are these numbers at all > meaningful? > I used 8.3 pgbench. I know some problems with it. pgbench is only one view (one dimension) on PostgreSQL, nothing less and nothing more. Some cases can be much faster or equal. > Matt > ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match