On 2/14/06, Neil Conway <[EMAIL PROTECTED]> wrote:
> On Tue, 2006-02-14 at 13:53 -0500, Kevin Murphy wrote:
> > A Windows PostgreSQL guru who cares (;-)) might help this guy with his
> > benchmark of mysql, firebird, sqlite, and postgresql:
> >
> > http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison
>
> Yeah, see recent discussion:
>
> http://archives.postgresql.org/pgsql-hackers/2006-02/msg00465.php
He turned on row level statistics in his postgresql.conf which is
either accidental goof or borderline cheating. This would have
mesurable impact on all rapid fire query tests. editing his wiki atm
merlin
---------------------------(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
