On Fri, 30 Apr 2004, Gary Doades wrote:
> I should have also pointed out that MSSQL reported that same index scan
> as taking 65% of the overall query time. It was just "faster". The
> overall query took 103ms in MSSQL.
Are your results based on a single client accessing the database and no
Would adding more clients, and maybe having some client that
updates/inserts into the tables, still make mssql faster then pg? Maybe
it's so simple as pg being optimized for more concurrent users then mssql?
I'm just asking, I don't know much about the inner workings of
In response to
pgsql-performance by date
|Next:||From: Achilleus Mantzios||Date: 2004-04-30 05:49:41|
|Subject: Re: Use arrays or not?|
|Previous:||From: Tom Lane||Date: 2004-04-30 04:30:26|
|Subject: Re: Insert only tables and vacuum performance |