"andremachado" <[EMAIL PROTECTED]> writes:
> continuing the saga,
> http://archives.postgresql.org/pgsql-performance/2006-04/msg00558.php ,
> my coleague created a test database with fake data (see below).
I tried to use this data to replicate your results, and could not.
I grabbed a copy of what
Hello, Jim
I did not want to clutter mailboxes of those who are not interested at
this weird problem.
So, i pointed to the archived message that contains 2 tar.gz files
(around 50 KB) with the two sets of queries (firebird and postgresql
respectively), its results, explain analyze, pg configuration
"andremachado" <[EMAIL PROTECTED]> writes:
> continuing the saga,
> http://archives.postgresql.org/pgsql-performance/2006-04/msg00558.php ,
> my coleague created a test database with fake data (see below).
Thanks. I played around with this a bit, and got results like these:
original query, 8.1 b
Jim C. Nasby wrote:
On Fri, May 12, 2006 at 12:48:52PM -0200, andremachado wrote:
Hello,
continuing the saga,
http://archives.postgresql.org/pgsql-performance/2006-04/msg00558.php ,
my coleague created a test database with fake data (see below).
The above archived message contains the the tim
On Fri, May 12, 2006 at 12:48:52PM -0200, andremachado wrote:
> Hello,
> continuing the saga,
> http://archives.postgresql.org/pgsql-performance/2006-04/msg00558.php ,
> my coleague created a test database with fake data (see below).
>
> The above archived message contains the the timings of fire
Hello,
continuing the saga,
http://archives.postgresql.org/pgsql-performance/2006-04/msg00558.php ,
my coleague created a test database with fake data (see below).
The above archived message contains the the timings of firebird and postgresql.
The weird problem are the 2 queries that firebird exe
"andremachado" <[EMAIL PROTECTED]> writes:
> After some time experimenting on windows, the conclusion is clear:
> windows is likely crap for databases other than MS-SQL.
Maybe. One thing that comes to mind is that you really should do some
performance tuning experiments. In particular it'd be a
Hello,
The performance comparison saga of the last month continues (see list archive).
After some time experimenting on windows, the conclusion is clear:
windows is likely crap for databases other than MS-SQL.
I guess that MS-SQL uses lot of undocumented api calls, may run in kernel
mode, ring 0
