Re: moving from MySQL to pgsql

Поиск
Список
Период
Сортировка
От Sim Zacks
Тема Re: moving from MySQL to pgsql
Дата
Msg-id 50753D52.5010300@compulab.co.il
обсуждение исходный текст
Ответ на moving from MySQL to pgsql  (Vineet Deodhar <vineet.deodhar@gmail.com>)
Ответы Re: moving from MySQL to pgsql
Список pgsql-general
Дерево обсуждения 
body p { margin-bottom: 0cm; margin-top: 0pt; }

  <body style="direction: ltr;"
    bidimailui-detected-decoding-type="UTF-8" text="#000000"
    bgcolor="#FFFFFF">
    On 10/10/2012 10:47 AM, Vineet Deodhar
      wrote:

    <blockquote
cite="mid:CAP5=7opYu1y=uy=BxPeud-t9sRnMO_1-OJi_rKeG8cFU8SuivA@mail.gmail.com"
      type="cite">Hi !
      At present, I am using MySQL as backend for my work.
      Because of the licensing implications, I am considering to shift
      from MySQL to pgsql.
      Typically, my apps are multi-user, web based or LAN based.

      1) Read over the internet that ---
      Postgres is not threaded, but every connection gets it's own
      process. The OS will distribute the processes across the
      processors. Basically a single connection will not be any faster
      with SMP, but multiple connections will be.

      MySQL is multi-threaded server so it can use many processors. A
      separate thread is created for each connection.
      source: <a moz-do-not-send="true"

href="http://dcdbappl1.cern.ch:8080/dcdb/archive/ttraczyk/db_compare/db_compare.html#Comparison+of+Oracle%2C+MySQL+and+Postgres+DBMS">http://dcdbappl1.cern.ch:8080/dcdb/archive/ttraczyk/db_compare/db_compare.html#Comparison+of+Oracle%2C+MySQL+and+Postgres+DBMS

      In what way it might affect my app performance?

    Performance will not be affected negatively.  MySQL only has one
    thread per connection, so a single query will never use multiple
    threads (scary concept to think about).

    <blockquote
cite="mid:CAP5=7opYu1y=uy=BxPeud-t9sRnMO_1-OJi_rKeG8cFU8SuivA@mail.gmail.com"
      type="cite">2) I run MySQL from a USB stick.
      There is no installation required (on WinXP.). (not tried on
      Ubuntu)
      Is it the same for pgsql?

    To use postgres on a USB stick, see

    <a

href="http://www.postgresonline.com/journal/archives/172-Starting-PostgreSQL-in-windows-without-install.html">http://www.postgresonline.com/journal/archives/172-Starting-PostgreSQL-in-windows-without-install.html

    <blockquote
cite="mid:CAP5=7opYu1y=uy=BxPeud-t9sRnMO_1-OJi_rKeG8cFU8SuivA@mail.gmail.com"
      type="cite">3) Can I simulate MySQL's TINYINT data-type (using
      maybe the custom data type or something else)

    You can either use bool or smallint with a constraint.

    Sim

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