Postgres is too slow?

From: Paul Mamin <magamos(at)mail(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres is too slow?
Date: 2001-06-21 03:57:49
Message-ID: 291087834.20010621095749@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've created the same table with 0.5M records ~200 bytes each. And I
decided to compare its speed under Postgres 7.1.2, Linux (kernel 2.4.1) and undex MS
SQL 7.0 (SP3), Win2K Server on the same PC - PIII/500 MHz, 128 Mb RAM.
Under W2K the OS stealt about 64Mb, and Linux eated almost
nothing, cause XWindows doesnt work. The speed of data exchange with
HDD was almost the same under Linux and Win2K.

Under Postgres I filled this table by COPY FROM cause.

And I made the SELECT that browse the whole table:
-----
select field1, sum(field2-field3)/count(*)
from table1
group by field1;
-----
1) It's speed almost doesnt depend from index on field1.
2) I made VACUUM ANALYZE

And ... MSSQL 7.0 worked in 2-2.5 times faster that Postgres :((

Why so?

--
Best regards,
Paul mailto:magamos(at)mail(dot)ru

Responses

Browse pgsql-general by date

  From Date Subject
Next Message pgsql-general 2001-06-21 04:03:42 Quick RServ Question
Previous Message Tom Lane 2001-06-21 02:01:17 Re: postgres.h missing? (fwd)