Re: PostgreSQL 8 on windows very slow

[Jasper Potts <jasper@xxxxxxxxxxxxxxx>]

In our testing Postgres came out on top, well MySql was faster if you 
use the non-transactional table type "MyISAM". If you use the InnoDb 
table type it comes out slower. All of this is very subjective depending 
on your querys and data set. Have you run the ANALYZE command on 
Postgres since you have added the data into the tables? It makes a huge 
difference in performance for us.

Hope that helps, Jasper

lol wrote:

> Well, for SELECT request pgsql  runs well, although it's a little
> slower than firebird & MySQL.
> The problem is especially for INSERT request. It's strange there's a
> lot of disk access, as if it doesn't use the cache or something like
> that (I'm not a db expert).
> The application runs on windows 2000 SP4 english, developped in Delphi
> 7 and access the database using ZeosLib 6.1.5 (I have also tried with
> 6.5.1-alpha 2).
> We don't make a lot of request in our application. We use MS-Access 97
> and we want to change for an SQL compliant open source database.
> Out application with pgsql (but I think the problem is zeoslib)  is a
> little slower than ms-access ! We have good results with MySQL and
> Firebird (using zeoslib). 
>
> Thank you
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>      joining column's datatypes do not match
>  

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faqs/FAQ.html