Hello, i use PostgresSQL 7.3.2 on Mandrake 9.0, I create a Database to test performance vs. SQL-Server, the idea is migrate SQL-Server to Postgres.
This test is retrieve a table sorted by a field ie: "select * from test order by id_field asc", postgress retrieve it in 43 seconds and SQL-Server in 8 seconds
The table has 100.000 records, why the diference, how acelerete the performance of postgres, have any tutorial on the web to optimize querys ?
Pedro
Rosario-Argentina