Re: Performance Problem

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: "Pedro C(dot) Arias" <parias(at)unr(dot)edu(dot)ar>
Cc: "pgsql (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Performance Problem
Date: 2003-04-16 01:51:35
Message-ID: 20030415184749.A64533-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Tue, 15 Apr 2003, 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 ?

What is the definition of test and what indexes does it have and what does
explain show for the query above? If you haven't at least vacuumed or
analyzed the table it's likely running on the default statistics which is
probably not good, also you may want/need to look at raising sort_mem if
the sort is going out to disk.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alec Mitchell 2003-04-16 01:56:07 Re: Strange query optimization in 7.3.2
Previous Message Jay O'Connor 2003-04-16 01:41:26 Disk usage