<html style="direction: ltr;">
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<style type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="UTF-8" text="#000000"
bgcolor="#FFFFFF">
<div class="moz-cite-prefix">On 10/10/2012 10:47 AM, Vineet Deodhar
wrote:<br>
</div>
<blockquote
cite="mid:CAP5=7opYu1y=uy=BxPeud-t9sRnMO_1-OJi_rKeG8cFU8SuivA(at)mail(dot)gmail(dot)com"
type="cite">Hi !<br>
At present, I am using MySQL as backend for my work.<br>
Because of the licensing implications, I am considering to shift
from MySQL to pgsql.<br>
Typically, my apps are multi-user, web based or LAN based.<br>
<br>
1) Read over the internet that --- <br>
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.<br>
<br>
MySQL is multi-threaded server so it can use many processors. A
separate thread is created for each connection.<br>
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</a><br>
<br>
In what way it might affect my app performance?<br>
</blockquote>
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). <br>
<br>
<blockquote
cite="mid:CAP5=7opYu1y=uy=BxPeud-t9sRnMO_1-OJi_rKeG8cFU8SuivA(at)mail(dot)gmail(dot)com"
type="cite">2) I run MySQL from a USB stick.<br>
There is no installation required (on WinXP.). (not tried on
Ubuntu)<br>
Is it the same for pgsql?<br>
</blockquote>
To use postgres on a USB stick, see
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<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</a><br>
<br>
<blockquote
cite="mid:CAP5=7opYu1y=uy=BxPeud-t9sRnMO_1-OJi_rKeG8cFU8SuivA(at)mail(dot)gmail(dot)com"
type="cite">3) Can I simulate MySQL's TINYINT data-type (using
maybe the custom data type or something else)<br>
</blockquote>
You can either use bool or smallint with a constraint.<br>
<br>
Sim<br>
</body>
</html>