Quick Links

SELECT's take a long time compared to other DBMS

From:	"Relaxin" <me(at)yourhouse(dot)com>
To:	pgsql-performance(at)postgresql(dot)org
Subject:	SELECT's take a long time compared to other DBMS
Date:	2003-09-04 00:28:26
Message-ID:	bj611t$1o2g$1@news.hub.org
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-performance

I have a table with 102,384 records in it, each record is 934 bytes.

Using the follow select statement:
SELECT * from <table>

PG Info: version 7.3.4 under cygwin on Windows 2000
ODBC: version 7.3.100

Machine: 500 Mhz/ 512MB RAM / IDE HDD

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.

This is the ONLY table in the database and only 1 user.

And yes I did a vacuum.

Is this normal behavior for PG?

Thanks

Responses

Re: SELECT's take a long time compared to other DBMS at 2003-09-04 01:05:06 from Rod Taylor
Re: SELECT's take a long time compared to other DBMS at 2003-09-04 01:06:26 from Rudi Starcevic
Re: SELECT's take a long time compared to other DBMS at 2003-09-04 11:01:53 from Hannu Krosing
Re: SELECT's take a long time compared to other DBMS at 2003-09-04 17:44:28 from William Yu
Re: SELECT's take a long time compared to other DBMS at 2003-09-04 22:28:36 from scott.marlowe

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Bruce Momjian	2003-09-04 00:36:52	Re: FreeBSD page size
Previous Message	scott.marlowe	2003-09-04 00:09:14	Re: Selecting random rows efficiently