SELECT's take a long time compared to other DBMS

Поиск
Список
Период
Сортировка
От Relaxin
Тема SELECT's take a long time compared to other DBMS
Дата
Msg-id bj611t$1o2g$1@news.hub.org
обсуждение исходный текст
Ответы Re: SELECT's take a long time compared to other DBMS  (Rudi Starcevic <rudi@oasis.net.au>)
Re: SELECT's take a long time compared to other DBMS  (Rod Taylor <rbt@rbt.ca>)
Re: SELECT's take a long time compared to other DBMS  (Hannu Krosing <hannu@tm.ee>)
Re: SELECT's take a long time compared to other DBMS  (William Yu <wyu@talisys.com>)
Re: SELECT's take a long time compared to other DBMS  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список 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 по дате отправления:

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