Re: SELECT's take a long time compared to other DBMS

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Relaxin <me(at)yourhouse(dot)com>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: SELECT's take a long time compared to other DBMS
Date: 2003-09-04 01:05:06
Message-ID: 1062637505.84923.7.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> Under PG: Data is returned in 26 secs!!
> Under SQL Server: Data is returned in 5 secs.
> Under SQLBase: Data is returned in 6 secs.
> Under SAPDB: Data is returned in 7 secs.

What did you use as the client? Do those times include ALL resulting
data or simply the first few lines?

PostgreSQL performance on windows (via Cygwin) is known to be poor.
Do you receive similar results with 7.4 beta 2?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rudi Starcevic 2003-09-04 01:06:26 Re: SELECT's take a long time compared to other DBMS
Previous Message Bruce Momjian 2003-09-04 00:36:52 Re: FreeBSD page size