Re: Performance question - Mailing list pgsql-general

From Roderick A. Anderson
Subject Re: Performance question
Date
Msg-id Pine.LNX.4.10.10109100708530.16341-100000@tincan.org
Whole thread Raw
In response to Performance question  ("Tille, Andreas" <TilleA@rki.de>)
List 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.


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: "user"
Next
From: "Ben-Nes Michael"
Date:
Subject: install only pg_dump