Re: Performance question

From: "Roderick A(dot) Anderson" <raanders(at)tincan(dot)org>
To: "Tille, Andreas" <TilleA(at)rki(dot)de>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Performance question
Date: 2001-09-10 14:10:45
Message-ID: Pine.LNX.4.10.10109100708530.16341-100000@tincan.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 10 Sep 2001, Tille, Andreas wrote:

> Hello,
>
> Now I started some performance comparisons and did the following statement:

> The MS-SQL server represents the result "immediately" - you just not notice
> any delay. If I do it on the PostgreSQL server it takes 30s on comparable
> hardware :-(((.

Did you do a VACUUM ANALYZE after loading the data?

Rod
--
A small clue and no money
will get you further than
lots of money and no clue.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ben-Nes Michael 2001-09-10 14:24:06 install only pg_dump
Previous Message Peter Eisentraut 2001-09-10 13:55:40 Re: "user"