Performance Problem - Mailing list pgsql-general

From Pedro C. Arias
Subject Performance Problem
Date
Msg-id 002601c303b9$3337bdb0$8dce44c8@pc2000
Whole thread Raw
Responses Re: Performance Problem
Re: Performance Problem
List pgsql-general
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

pgsql-general by date:

Previous
From: Medi Montaseri
Date:
Subject: Re: Postgres Compare
Next
From: "Jay O'Connor"
Date:
Subject: Disk usage