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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
