Thread: Postgres Internals

Hi All,

Im running some benchmarking tests on mysql, postgres and interbase
database servers.

does anyone know the reasons why or know where i can find out some
technical reasons why the postgres database server is particularly good
in relation to the others or just by itself e.g. use of query
optimisation or indexing etc. I'm only looking at creates, selects,
inserts, update and delete statements. I've noticed it is slow at
inserting data into tables, but especially quick at doing complex
selects (i.e. containing many joins). Why is this so?

I've tried to look around for this on the net, but all i seem to get is
a big arguement consisting of the features lacking in mysql that are in
other databases e.g. ACID!!

Thanks,

Dipesh

> Hi All,
> 
> Im running some benchmarking tests on mysql, postgres and interbase
> database servers.
> 
> does anyone know the reasons why or know where i can find out some
> technical reasons why the postgres database server is particularly good
> in relation to the others or just by itself e.g. use of query
> optimisation or indexing etc. I'm only looking at creates, selects,
> inserts, update and delete statements. I've noticed it is slow at
> inserting data into tables, but especially quick at doing complex
> selects (i.e. containing many joins). Why is this so?

Our optimizer is very good compared to MySQL.  Not sure about Interbase.
We even have GEQO for joins of >10 tables.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026