From: | "songsubo" <songsubo(at)163(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org <pgsql-general(at)postgresql(dot)org> |
Subject: | Fedora core 3 is slower than Fedora core 1? |
Date: | 2004-11-24 06:53:32 |
Message-ID: | 20041124065617.F01893A42EA@svr1.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
in Fedora core 1:
abc=# select version();explain select * from abc;select count(*) from abc;
version
-------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 7.3.4 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 3.3.1 20030903 (Red Hat Linux 3.3.1-3)
(1 row)
Time: 0.35 ms
QUERY PLAN
--------------------------------------------------------
Seq Scan on abc (cost=0.00..20.00 rows=1000 width=16)
(1 row)
Time: 0.52 ms
count
-------
30167
(1 row)
Time: 35.84 ms
in Fedora core 3:
abc=# select version();explain select * from abc;select count(*) from abc;
version
-------------------------------------------------------------------------------------------------------------------------
PostgreSQL 7.4.5 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 3.4.1 20040815 (Red Hat 3.4.1-9)
(1 row)
Time: 0.456 ms
QUERY PLAN
----------------------------------------------------------
Seq Scan on abc (cost=0.00..479.67 rows=30167 width=16)
(1 row)
Time: 0.962 ms
count
-------
30167
(1 row)
Time: 29.876 ms
But the speed of ftp and http is sameness.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-11-24 07:33:20 | Re: Fedora core 3 is slower than Fedora core 1? |
Previous Message | Greg Stark | 2004-11-24 06:35:25 | Re: Upcoming Changes to News Server ... |