<html>
  <head>
    <meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    Ahoj, <br>
    Trochu OT, ale moc pěkný úvod do pgsql z pohledu nastavení a
    administrace je zde: <a class="moz-txt-link-freetext" href="https://www.youtube.com/watch?v=knUitQQnpJo">https://www.youtube.com/watch?v=knUitQQnpJo</a><br>
    <br>
    Tomáš A.<br>
    <br>
    <div class="moz-cite-prefix">On 30. 11. 2016 13:52, Martin Miksanik
      wrote:<br>
    </div>
    <blockquote
cite="mid:CAAwEaGWW8vSs4d9tCRfeJKmYL6S2Xn7MY3RYa0pHX+6YXBKGUA@mail.gmail.com"
      type="cite">
      <meta http-equiv="Context-Type" content="text/html; charset=UTF-8">
      <div dir="ltr">Kratce: sice to uz neni uplne pravda, ale postgres
        je databaze vhodna pro prumyslove/slozite komercni uziti a mysql
        je dobra tak na jednoduchsi weby.
        <div><br>
        </div>
        <div><br>
        </div>
        <div>Delseji:</div>
        <div>Postgres: nativne umi HA s master/slave rezimem. uz je i
          postregsXL ktera umi M2M. Ja osobne nemam rad veci M2M protoze
          ta rezije, co to obnasi neni uplne nejlepsi a aby nebyly
          konflikty, tak se stejne musi cekat na sync a ma to vice
          problemu.</div>
        <div><br>
        </div>
        <div>Postgres ma velkou paletu moznosti, od psani procedur v
          C/C++, python, plpgsql, pocitani na GPU, ma hodne rozsireni,
          detailni moznosti si nastavit skoro kazdou ptakovinu. Da se s
          tim fakt zajimave vyhrat.</div>
        <div>Z toho vyplyva, ze konfigurace je taky vyrazne slozitejsi.</div>
        <div>Dobra sranda je napr. kopirovani databaze ze sablony :)</div>
        <div><br>
        </div>
        <div>MySQL umi M2M nativne, ale technologicky background neni
          tak robustni, jako u postgres. Posledni test pri 3 MySQL
          nodech v M2M a soucasnem zapisu na vsechny 3 mista dostaval DB
          do dost divneho stavu.</div>
        <div><br>
        </div>
        <div>Co se tyka rychlosti, tak zalezi na uziti a programatorovi.
          Postgres ma veci jako pridelena ram uzivateli a shared buffer,
          takze si muze strasne hodne casto pouzivanych veci zacachovat.</div>
        <div>Kdyz se spravne nastavi velikosti stranek, work mem, shared
          buffer a dalsi veci, co muzou dost brzdit, tak pri
          jednoduchych DB je asi rychlejsi MySQL, ale kdyz do toho narvu
          100M zaznamu, tak uz mi postgres MySQL solidne valcovala.<br>
          <div><br>
          </div>
        </div>
      </div>
      <div class="gmail_extra"><br>
        <div class="gmail_quote">2016-11-30 9:52 GMT+01:00 Miroslav
          Marcišin <span dir="ltr"><<a moz-do-not-send="true"
              href="mailto:me@h00ked.cz" target="_blank">me@h00ked.cz</a>></span>:<br>
          <blockquote class="gmail_quote">
            <div dir="auto">
              <div>Co se tyce provozu, rezie a nasazeni, tak jsem v tom
                z moji strany nepozoroval zadny rozdil. Jen obcas se
                delalo neco trosku jinak.</div>
              <div id="m_6431489266057772875AppleMailSignature"><br>
              </div>
              <div id="m_6431489266057772875AppleMailSignature">Samozrejme
                je otazka, zda to umi nebo to budou "googlit" :)</div>
              <div id="m_6431489266057772875AppleMailSignature"><br>
              </div>
              <div id="m_6431489266057772875AppleMailSignature">V ostrem
                provozu jsem to predal adminum, ja se o to staral jen
                instalace + pilot ale nemyslim ze tam jsou nejaky vetsi
                rozdily nez byly. Vecer zkusim schvalne kouknout do
                infovisty jestli tam neco vykoukam :)</div>
              <div id="m_6431489266057772875AppleMailSignature"><br>
              </div>
              <div id="m_6431489266057772875AppleMailSignature">\M<br>
                <br>
                Odesláno z iPhonu</div>
              <div><br>
                30. 11. 2016 v 9:37, Jaroslav Týc <<a
                  moz-do-not-send="true"
                  href="mailto:jaroslavtyc@atlas.cz" target="_blank">jaroslavtyc@atlas.cz</a>>:<br>
                <br>
              </div>
              <div>
                <div class="h5">
                  <blockquote type="cite">
                    <div> Říkal jsem si že to bude hlavně náročnost
                      nasazení, co poskytovatele odrazuje (že to ztíží i
                      údržbu mě netrklo) - po zkušenostech s nimi s
                      nestandardními požadavky zůstanu raději u základní
                      verze, víc zatím nepotřebujeme.<br>
                      <br>
                      PostgreSQL potřebujeme hlavně kvůli geolokaci
                      (PostGIS), protože MySQL to neumí rozumně
                      indexovat a jiné technologie (Redis,
                      ElasticSearch) by se mi obtížněji propojovaly s
                      dalšími daty v relační databázi.<br>
                      <br>
                      <div class="m_6431489266057772875moz-cite-prefix">On
                        11/30/2016 08:51 AM, David Karban wrote:<br>
                      </div>
                      <blockquote type="cite">
                        <div dir="ltr">Ahoj, 
                          <div><br>
                          </div>
                          <div><br>
                          </div>
                          <div class="gmail_extra">
                            <div class="gmail_quote">Dne 30. listopadu
                              2016 8:34 Jaroslav Týc <span dir="ltr"><<a
                                  moz-do-not-send="true"
                                  href="mailto:jaroslavtyc@atlas.cz"
                                  target="_blank">jaroslavtyc@atlas.cz</a>></span>
                              napsal(a):<br>
                              <blockquote class="gmail_quote">
                                <div> Ahoj, řešíme souběžné nasazení
                                  MySQL (respektive MariaDB) a
                                  PostgreSQL, ovšem náš poskytovatel nás
                                  od toho opakovaně zrazuje s
                                  následujícími argumenty, kterým příliš
                                  nevěřím, rád bych se vás zeptal na
                                  praktické zkušenosti<br>
                                  <ul>
                                    <li><tt>PostgreSQL lze replikovat
                                        pouze v rezimu Master-Slave s
                                        tim, ze Slave je vzdy read-only</tt></li>
                                    <ul>
                                      <li>přitom pouhou namátkou najdu <a
                                          moz-do-not-send="true"
href="https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling"
                                          target="_blank">dlouhý seznam
                                          nástrojů</a>, které nabízí
                                        spoustu možností<br>
                                      </li>
                                    </ul>
                                  </ul>
                                </div>
                              </blockquote>
                              <div>Každá z těch možností má svá pro a
                                proti, nic z toho není ve smyslu vzít a
                                nasadit bez přemýšlení (to je asi jen ta
                                varianta master slave kterou má postgre
                                přímo v instalaci). Tzn. jde to ale je
                                to náročnější na provoz a údržbu. </div>
                              <blockquote class="gmail_quote">
                                <div>
                                  <ul>
                                    <ul>
                                      <li> <br>
                                      </li>
                                    </ul>
                                    <li><tt>PostgreSQL ma vyrazne vyssi
                                        naroky na systemove prostredky
                                        oproti MySQL (predevsim RAM a
                                        rezie spojena s pouzivanim
                                        shared memory) a na CPU
                                        (PostgreSQL se vzrustajicim
                                        poctem requestu casteji forkuje)</tt></li>
                                    <ul>
                                      <li>nevěřím, že pro stejná data a
                                        stejné queries spotřebuje
                                        Postrgres výrazně více
                                        systémových prostředků</li>
                                    </ul>
                                  </ul>
                                </div>
                              </blockquote>
                              <div>To nedokážu posoudit, spíše je otázka
                                co potřebujete z DB funkcí, co mysql
                                nemá?</div>
                              <blockquote class="gmail_quote">
                                <div>
                                  <ul>
                                    <ul>
                                    </ul>
                                  </ul>
                                  Jak to vidíte vy?<br>
                                  Díky, Jarda<br>
                                </div>
                                <br>
                                ______________________________<wbr>_________________<br>
                                Community-list mailing list<br>
                                <a moz-do-not-send="true"
                                  href="mailto:Community-list@lists.vpsfree.cz"
                                  target="_blank">Community-list@lists.vpsfree.c<wbr>z</a><br>
                                <a moz-do-not-send="true"
                                  href="http://lists.vpsfree.cz/listinfo/community-list"
                                  rel="noreferrer" target="_blank">http://lists.vpsfree.cz/listin<wbr>fo/community-list</a><br>
                                <br>
                              </blockquote>
                            </div>
                            <div>
                              <div
                                class="m_6431489266057772875gmail_signature">
                                <div dir="ltr">
                                  <div dir="ltr">
                                    <div dir="ltr">
                                      <div dir="ltr"><br
                                          class="m_6431489266057772875gmail-Apple-interchange-newline">
                                        David<br>
                                        Linux server specialist/Heavy
                                        Ansible user<br>
                                        <a moz-do-not-send="true"
                                          href="http://www.karban.eu/"
                                          target="_blank">www.karban.eu</a><br>
                                      </div>
                                      <div><br>
                                      </div>
                                    </div>
                                  </div>
                                </div>
                              </div>
                            </div>
                          </div>
                        </div>
                        <br>
                        <fieldset
                          class="m_6431489266057772875mimeAttachmentHeader"></fieldset>
                        <br>
                        <pre>______________________________<wbr>_________________
Community-list mailing list
<a moz-do-not-send="true" class="m_6431489266057772875moz-txt-link-abbreviated" href="mailto:Community-list@lists.vpsfree.cz" target="_blank">Community-list@lists.vpsfree.<wbr>cz</a>
<a moz-do-not-send="true" class="m_6431489266057772875moz-txt-link-freetext" href="http://lists.vpsfree.cz/listinfo/community-list" target="_blank">http://lists.vpsfree.cz/<wbr>listinfo/community-list</a>
</pre>
    </blockquote>
    

  

</div></blockquote><blockquote type="cite"><div><span>______________________________<wbr>_________________</span>
<span>Community-list mailing list</span>
<span><a moz-do-not-send="true" href="mailto:Community-list@lists.vpsfree.cz" target="_blank">Community-list@lists.vpsfree.<wbr>cz</a></span>
<span><a moz-do-not-send="true" href="http://lists.vpsfree.cz/listinfo/community-list" target="_blank">http://lists.vpsfree.cz/<wbr>listinfo/community-list</a></span>
</div></blockquote></div></div></div>
______________________________<wbr>_________________

Community-list mailing list

<a moz-do-not-send="true" href="mailto:Community-list@lists.vpsfree.cz">Community-list@lists.vpsfree.<wbr>cz</a>

<a moz-do-not-send="true" href="http://lists.vpsfree.cz/listinfo/community-list" rel="noreferrer" target="_blank">http://lists.vpsfree.cz/<wbr>listinfo/community-list</a>


</blockquote></div>

<div>
</div>-- 
<div class="gmail_signature" data-smartmail="gmail_signature">S přáním pěkného dne,
Martin Mikšaník

gsm: +420 602 623 934
icq: 311047283
</div>
</div>


<fieldset class="mimeAttachmentHeader"></fieldset>
<pre wrap="">_______________________________________________
Community-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Community-list@lists.vpsfree.cz">Community-list@lists.vpsfree.cz</a>
<a class="moz-txt-link-freetext" href="http://lists.vpsfree.cz/listinfo/community-list">http://lists.vpsfree.cz/listinfo/community-list</a>
</pre>

</blockquote>
</body></html>