<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"><meta name="Generator" content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang="EN-US"><div>Hello</div><div><br></div><div>This question is not possible to answer without more information like:</div><div><br></div><div>Did you have performance problems with PostGIS under PostgreSQL?</div><div>Why do you expect better performance from moving to EDB? What functionality in EDB did you expect to impact the performance?</div><div><br></div><div>What is the query that is slow? There are many functions in PostGIS, what are you using. Most performance problems with PostGIS is related to not having indexes where needed, or a query written in a way so PostGIS cannot gain from indexes.</div><div><br></div><div>Regards</div><div><br></div><div>Nicklas</div><div><br></div><div>On Thu, 2017-09-21 at 09:20 +0530, Pradeep Kanth G wrote:</div><blockquote type="cite"><div class="WordSection1"><p class="MsoNormal">Hi,<o:p></o:p></p><p class="MsoNormal"><o:p> </o:p></p><p class="MsoNormal">Recently , I have moved my PostGIS Spatial data from PostgreSQL to EDB(Enterprise DB) .After moving into EDB there is no much difference between Open Source PostgreSQL performance wise.<o:p></o:p></p><p class="MsoNormal">So kindly suggested to us ,how to improve the EDB performance with PostGIS.<o:p></o:p></p><p class="MsoNormal"><o:p> </o:p></p><p class="MsoNormal"><span style="color:black">Regards<o:p></o:p></span></p><p class="MsoNormal"><span style="color:black">Pradeep Kanth<o:p></o:p></span></p><p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p><p class="MsoNormal"><o:p> </o:p></p></div><br>
<br>
<div align="left"><b>Disclaimer </b>| The information contained in this electronic message (including any attachments) is intended for the exclusive use of the addressee(s) and may contain confidential or privileged information.If you have received this in error, please notify the sender immediately and delete the material from your machine. Any action including review, retransmission, dissemination of this email or the attachments present along with the email by persons or entities other than the intended recipient is prohibited.<br></div><br><br><br>
<pre>_______________________________________________
postgis-users mailing list
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre></blockquote></body></html>