[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] PostgreSQL and Data Warehouse optimizations
From:       Daniel Franco <dpinheirofranco () gmail ! com>
Date:       2017-07-31 22:52:28
Message-ID: CAOzZ813oRFe-O-xEHv++4DJoR8ig=H92N1Vn0mui0L+y3zkuHg () mail ! gmail ! com
[Download RAW message or body]

Recently, I've been doing a research about data warehouse optimizations and
techniques. For example, Oracle uses parallel queries, materialized views
with different refresh modes, star transformations in queries, etc. Since
I've never worked with PostgreSQL in an OLAP environment, I thought maybe
the community could guide me to find what features and techniques
PostgreSQL provides for its users and it would be especially useful if
someone could point out a previous work comparing PostgreSQL with another
RDBMs in this regard. Also, I'm interested if there's any interesting
books, articles or anything related PostgreSQL and Data Warehouses
optimizations.

Thanks and Regards for all the community.

<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
 Livre
de vírus. www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>.
 <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>


[Attachment #3 (text/html)]

<div dir="ltr">Recently, I&#39;ve been doing a research about data warehouse \
optimizations and techniques. For example, Oracle uses parallel queries, materialized \
views with different refresh modes, star transformations in queries, etc. Since \
I&#39;ve never worked with PostgreSQL in an OLAP environment, I thought maybe the \
community could guide me to find what features and techniques PostgreSQL provides for \
its users and it would be especially useful if someone could point out a previous \
work comparing PostgreSQL with another RDBMs in this regard. Also, I&#39;m interested \
if there&#39;s any interesting books, articles or anything related PostgreSQL and \
Data Warehouses optimizations.<br><br>Thanks and Regards for all the \
community.</div><div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br> <table \
style="border-top:1px solid #d3d4de">  <tr>
      <td style="width:55px;padding-top:18px"><a \
href="https://www.avast.com/sig-email?utm_medium=email&amp;utm_source=link&amp;utm_campaign=sig-email&amp;utm_content=webmail" \
target="_blank"><img \
src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" \
alt="" width="46" height="29" style="width: 46px; height: 29px;"></a></td>  <td \
style="width:470px;padding-top:17px;color:#41424e;font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Livre \
de vírus. <a href="https://www.avast.com/sig-email?utm_medium=email&amp;utm_source=link&amp;utm_campaign=sig-email&amp;utm_content=webmail" \
target="_blank" style="color:#4453ea">www.avast.com</a>. 		</td>  </tr>
</table>
<a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div>



[prev in list] [next in list] [prev in thread] [next in thread]