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
Re: SELECT's take a long time compared to other DBMS Re: SELECT's take a long time compared to other DBMS Re: SELECT's take a long time compared to other DBMS Re: SELECT's take a long time compared to other DBMS |
Список | 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 по дате отправления: