Re: Need help to decide Mysql vs Postgres

От: PFC
Тема: Re: Need help to decide Mysql vs Postgres
Дата: ,
Msg-id: op.srynillhth1vuj@localhost
(см: обсуждение, исходный текст)
Ответ на: Re: Need help to decide Mysql vs Postgres  (Amit V Shah)
Ответы: Re: Need help to decide Mysql vs Postgres  (Jan Wieck)
Список: pgsql-performance

Скрыть дерево обсуждения

Need help to decide Mysql vs Postgres  (Amit V Shah, )
 Re: Need help to decide Mysql vs Postgres  ("Joshua D. Drake", )
 Re: Need help to decide Mysql vs Postgres  (Amit V Shah, )
  Re: Need help to decide Mysql vs Postgres  ("Joel Fradkin", )
  Re: Need help to decide Mysql vs Postgres  ("Joshua D. Drake", )
   Re: Need help to decide Mysql vs Postgres  (Philip Hallstrom, )
 Re: Need help to decide Mysql vs Postgres  (Josh Berkus, )
 Re: Need help to decide Mysql vs Postgres  (Amit V Shah, )
  Re: Need help to decide Mysql vs Postgres  ("Steinar H. Gunderson", )
  Re: Need help to decide Mysql vs Postgres  (Josh Berkus, )
 Re: Need help to decide Mysql vs Postgres  (PFC, )
 Re: Need help to decide Mysql vs Postgres  ( (), )
 Re: Need help to decide Mysql vs Postgres  (Bill Ewing, )
  Re: Need help to decide Mysql vs Postgres  (Christopher Kings-Lynne, )
  Re: Need help to decide Mysql vs Postgres  (PFC, )
 Re: Need help to decide Mysql vs Postgres  (Jeffrey Tenny, )
  Re: Need help to decide Mysql vs Postgres  (Tobias Brox, )
   Re: Need help to decide Mysql vs Postgres  (Michael Fuhr, )
 Re: Need help to decide Mysql vs Postgres  (Amit V Shah, )
  Re: Need help to decide Mysql vs Postgres  (Alvaro Herrera, )
  Re: Need help to decide Mysql vs Postgres  (Rod Taylor, )
  Re: Need help to decide Mysql vs Postgres  (PFC, )
 Re: Need help to decide Mysql vs Postgres  (Amit V Shah, )
  Re: Need help to decide Mysql vs Postgres  (Christopher Browne, )
   Re: Need help to decide Mysql vs Postgres  (Ron Mayer, )
    Re: Need help to decide Mysql vs Postgres  (Tom Lane, )
  Re: Need help to decide Mysql vs Postgres  (PFC, )
   Re: Need help to decide Mysql vs Postgres  (Jan Wieck, )
    Re: Need help to decide Mysql vs Postgres  ("Joel Fradkin", )
     Re: Need help to decide Mysql vs Postgres  (PFC, )
      Re: Need help to decide Mysql vs Postgres  (Enrico Weigelt, )
       Re: Need help to decide Mysql vs Postgres  (Mark Lewis, )
        Re: Need help to decide Mysql vs Postgres  (Moises Alberto Lindo Gutarra, )


> Please pardon my ignorance, but from whatever I had heard, mysql was
> supposedly always faster than postgres !!!! Thats why I was so surprised
> !!

    I heard a lot of this too, so much it seems common wisdom that postgres
is slow... well maybe some old version was, but it's getting better at
every release, and the 8.0 really delivers... I get the feeling that the
PG team is really working and delivering improvements every few months,
compare this to MySQL 5 which has been in beta for as long as I can
remember.
    Also, yes, definitely mysql is faster when doing simple selects like
SELECT * FROM table WHERE id=constant, or on updates with few users, but
once you start digging... it can get a thousand times slower on some joins
just because the optimizer is dumb... and then suddenly 0.2 ms for MySQL
versus 0.3 ms for postgres on a simple query doesn't seem that attractive
when it's 2 ms on postgres versus 2 seconds on mysql for a not so
complicated one like pulling the first N rows from a join ordered by...
    PG is considered slower than mysql also because many people don't use
persistent connections, and connecting postgres is a lot slower than
connecting MySQL... But well, persistent connections are easy to use and
mandatory for performance on any database anyway so I don't understand why
the fuss.


> I will definately post the "analyze query" thing by end of today ...
>
> Thanks for all your helps !!
> Amit
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if
> your
>       joining column's datatypes do not match
>




В списке pgsql-performance по дате сообщения:

От: Neil Conway
Дата:
Сообщение: Re: Postgresql on an AMD64 machine
От: Tom Lane
Дата:
Сообщение: Re: Postgresql on an AMD64 machine