<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Mike,<br>
<br>
It might be easier to reduce the size of certain columns today. We
have an enormous amount of wasted space in the tables today.
Reducing them would make things more efficient regardless of the
database engine being used. On the flip side, if we were using SQL
Alchemy properly and not hard coding SQL statements, we could make
the database back-end more agnostic. It would be a major project to
fix this across all of the services today, but that may be the right
thing to do in the long term. InnoDB has it's own scaling issues and
at some point a larger shop (telco or cloud provider) will want
other options. <br>
<br>
Thanks,<br>
Octave<br>
<br>
<div class="moz-cite-prefix">On 2/3/2017 8:16 AM, Roman Podoliaka
wrote:<br>
</div>
<blockquote
cite="mid:CAKA_ueDtSWTf1pmwO8pXG-8s3nB3qrrP5rC1x+cK55OYN++ptw@mail.gmail.com"
type="cite">
<pre wrap="">On Fri, Feb 3, 2017 at 4:41 PM, Mike Bayer <a class="moz-txt-link-rfc2396E" href="mailto:mbayer@redhat.com"><mbayer@redhat.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Not sure if people on the list are seeing that we are simultaneously talking
about getting rid of Postgresql in the efforts to support only "one
database", while at the same time adding one that is in many ways a new
database.
</pre>
</blockquote>
<pre wrap="">
++
and, FWIW, moving columns between tables and changing of column types
in order to make NDB storage engine happy both seem to be a way more
intrusive than what we've had to do so far in the code of OpenStack
projects in order to support PostgreSQL.
__________________________________________________________________________
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: <a class="moz-txt-link-abbreviated" href="mailto:OpenStack-dev-request@lists.openstack.org?subject:unsubscribe">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a>
<a class="moz-txt-link-freetext" href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a>
</pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<br>
<p>
<a href="http://www.oracle.com/" target="_blank"><img
src="cid:part1.04020501.05040405@oracle.com" alt="Oracle"
border="0" height="26" width="114"></a><br>
<font color="#666666" size="2" face="Verdana, Arial, Helvetica,
sans-serif">Octave J. Orgeron | Sr. Principal Architect and
Software Engineer<br>
<font color="#ff0000">Oracle</font> Linux OpenStack<br>
Mobile: <a href="tel:+17206161550">+1-720-616-1550</a><br>
500 Eldorado Blvd. | Broomfield, CO 80021<br>
<a
href="http://www.oracle.com/us/solutions/enterprise-architecture/index.html"><img
src="cid:part4.06000904.07090007@oracle.com"
alt="Certified Oracle Enterprise Architect: Systems
Infrastructure" border="0" height="42" width="182"></a><br>
<a href="http://www.oracle.com/commitment" target="_blank"><img
src="cid:part6.02020102.01090006@oracle.com" alt="Green
Oracle" align="absmiddle" border="0" height="28"
width="44"></a>
<font color="#4B7D42" size="1" face="Verdana, Arial,
Helvetica, sans-serif">Oracle is committed to developing
practices and products that help protect the environment</font>
</font></p>
<font color="#666666" size="2" face="Verdana, Arial, Helvetica,
sans-serif">
</font></div>
</body>
</html>