PostgreSQL is slower on FC3?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



in  Fedora core 1:
abc=# select version();explain select * 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


in Fedora core 3:
abc=# select version();explain select * 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


But the speed of ftp and http is sameness.





[Index of Archives]     [Current Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [Yosemite Photos]     [KDE Users]     [Fedora Tools]     [Fedora Docs]

  Powered by Linux