SELECT's take a long time compared to other DBMS - Mailing list 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



pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: FreeBSD page size
Next
From: Rudi Starcevic
Date:
Subject: Re: SELECT's take a long time compared to other DBMS