SELECT's take a long time compared to other DBMS

Поиск
Список
Период
Сортировка
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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: FreeBSD page size
Следующее
От: Rudi Starcevic
Дата:
Сообщение: Re: SELECT's take a long time compared to other DBMS