Fedora core 3 is slower than Fedora core 1?

Поиск
Список
Период
Сортировка
От songsubo
Тема Fedora core 3 is slower than Fedora core 1?
Дата
Msg-id 20041124065617.F01893A42EA@svr1.postgresql.org
обсуждение исходный текст
Ответы Re: Fedora core 3 is slower than Fedora core 1?
Список 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.




В списке pgsql-general по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Upcoming Changes to News Server ...
Следующее
От: "Net Virtual Mailing Lists"
Дата:
Сообщение: pgdump of schema...