Re: Advantages of PostgreSQL over MySQL 5.0 - Mailing list pgsql-general

From Qingqing Zhou
Subject Re: Advantages of PostgreSQL over MySQL 5.0
Date
Msg-id e0037g$1pbc$1@news.hub.org
Whole thread Raw
In response to Advantages of PostgreSQL over MySQL 5.0  ("Jimbo1" <jamestheboarder@googlemail.com>)
List pgsql-general
""Merlin Moncure"" <mmoncure@gmail.com> wrote
>
> In postgresql, queries executed over the parameterized/prepared C api
> are particularly fast...as much as a 70% speed reduction over vanilla
> PQexec.

Does it mean 70% time is spent on planning? I am a little bit interested in
this number. Can you specify what kind of queries or give some testing
numbers. By the way, if so, we can do it by PREPARE statement in SQL.

Regards,
Qingqing



pgsql-general by date:

Previous
From: Oisin Glynn
Date:
Subject: Re: PostgreSQL 8.1 v. Oracle 10g xe
Next
From: Tom Lane
Date:
Subject: Re: Parallel sequential scans