Problem with the numbers I reported yesterday
Michael Meskes <meskes@topsystem.de>
From: Michael Meskes <meskes@topsystem.de>
To: pgsql-hackers@postgresql.org (PostgreSQL Hacker)
Date: 1998-02-11T09:36:03Z
Lists: pgsql-hackers
I ran my performance tests some more times and it seems the numbers are not really comparable. When I run PostgreSQL without -F I get a sync after every insert. With -F I get no sync at all as all inserts fit well into the buffer. However, Oracle in comparison does sync. Simply hearing the disk access it seems as if they sync every two or three seconds. Does anyone know a way to really check both DBMSs? Michael -- Dr. Michael Meskes, Project-Manager | topsystem Systemhaus GmbH meskes@topsystem.de | Europark A2, Adenauerstr. 20 meskes@debian.org | 52146 Wuerselen Go SF49ers! Go Rhein Fire! | Tel: (+49) 2405/4670-44 Use Debian GNU/Linux! | Fax: (+49) 2405/4670-10