On Wednesday 16 April 2003 07:10, Pedro C. Arias wrote:
> 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 ?
There are too many variables to tune for. To start with, tune postgresql.conf.
Look for number of shared buffers and sort mem. Also vacuum periodically.
More specific information would help.
Shridhar