Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT's take a long time compared to other DBMS - Mailing list pgsql-performance

From Rod Taylor
Subject Re: SELECT's take a long time compared to other DBMS
Date
Msg-id 1062637505.84923.7.camel@jester
Whole thread Raw
In response to SELECT's take a long time compared to other DBMS  ("Relaxin" <me@yourhouse.com>)
List pgsql-performance
Tree view 
> 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?
Attachment

pgsql-performance by date:

Previous
From: Rudi Starcevic
Date:
Subject: Re: SELECT's take a long time compared to other DBMS
Next
From: "Relaxin"
Date:
Subject: Re: SELECT's take a long time compared to other DBMS