Speed comparison to Oracle. Why was this query slower on pgsql?
От | Francisco Reyes |
---|---|
Тема | Speed comparison to Oracle. Why was this query slower on pgsql? |
Дата | |
Msg-id | 20020222134233.M86656-100000@zoraida.natserv.net обсуждение исходный текст |
Ответы |
Re: Speed comparison to Oracle. Why was this query slower on pgsql?
|
Список | pgsql-general |
I have been instructed to "learn Oracle" by my boss. among the firs things I am doing is trying to get a feeling for speed. For instance I have a query like: select field1, count(*) from mytable group by field1; On postgresql it takes about 15 seconds while on Oracle it took about 10 seconds. I thought maybe it was due to disks, but I did a couple of other queries which would also do a table scan and postgresql actually seemed faster. For instance I did another query like: select field1, field2 from mytable where field1 between 1930 and 1940; The both were very fast, but it seemed the PostgreSQL was slightly faster every time. Is Oracle better at aggregate functions? Another point worth mentioning. The Oracle table has 40K records less. Postgresql has 770K, Oracld has 730K. I am pushing for using PostgreSQL for reporting and my boss seems to be agreeing so far. So I hope we will continue using PostgreSQL no matter what, but I am trying to learn what types of things each does better than the other. Is there any resource which compares pgsql to other major DBMS in terms of their strenghts and weaknesses?
В списке pgsql-general по дате отправления: