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.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
- Re: [GENERAL] performance question ernie cline
- Re: [GENERAL] performance question Thomas Lockhart
- [GENERAL] Performance question Tille, Andreas
- Re: [GENERAL] Performance question Roderick A. Anderson
- Re: [GENERAL] Performance question Herbert.Liechti
- Re: [GENERAL] Performance question Tille, Andreas
- Re: [GENERAL] Performance question Einar Karttunen
- Re: [GENERAL] Performance question Stephan Szabo
- [GENERAL] Performance question Jean-Christian Imbeault
- Re: [GENERAL] Performance question Tom Lane
- Re: [GENERAL] Performance question Joe Conway
- Re: [webmaster] [GENERAL] Performance... Bruce Momjian
