<?xml version="1.0" encoding="us-ascii"?>
<rss xmlns:dc="http://purl.org/dc/elements/1.1/" version="2.0">
  <channel>
    <title>Power PostgreSQL</title>
    <link>http://powerpostgresql.com</link>
    <description>PostgreSQL Performance Pontificated</description>
    <language />
    <item>
      <title>Presentations: SOLT sessions up</title>
      <link>http://powerpostgresql.com/article/25</link>
      <guid>http://powerpostgresql.com/article/25</guid>
      <description>
        <![CDATA[The SOLT 2007 speakers and sessions are up on the <a href="/SOLT_2007">SOLT page</a>.]]>
</description>
      <dc:creator>Undefined</dc:creator>
      <dc:date>2007-06-27T23:05:03-07:00</dc:date>
    </item>
    <item>
      <title>Presentations: More Presentations and Organization</title>
      <link>http://powerpostgresql.com/article/24</link>
      <guid>http://powerpostgresql.com/article/24</guid>
      <description>
        <![CDATA[So, in addition to putting up <a href="/Docs">yet more talks</a>, I've also re-arranged everything to make it easier to find the talk or doc you're looking for.]]>
</description>
      <dc:creator>Undefined</dc:creator>
      <dc:date>2007-06-02T12:19:08-07:00</dc:date>
    </item>
    <item>
      <title>Announcement: New Presentations Up</title>
      <link>http://powerpostgresql.com/article/22</link>
      <guid>http://powerpostgresql.com/article/22</guid>
      <description>
        <![CDATA[I've added my presentations from Brazil and the tutorial from PGCon.]]>
</description>
      <dc:creator>Undefined</dc:creator>
      <dc:date>2007-05-31T21:05:54-07:00</dc:date>
    </item>
    <item>
      <title>Announcement: Josh moving to Sun</title>
      <link>http://powerpostgresql.com/article/20</link>
      <guid>http://powerpostgresql.com/article/20</guid>
      <description>
        <![CDATA[I will be leaving Greenplum and going to Sun Microsystems on Monday.&nbsp;&nbsp; There, I will run Sun's initiative to support and contribute to PostgreSQL.&nbsp;&nbsp; Some Q&amp;A:<br/>
<br/>
<span style="font-weight: bold;">I am not leaving the Bizgres Project</span>:&nbsp; since Bizgres Database and Bizgres Stack are open source, I expect to continue working on them at Sun.&nbsp; Hopefully this will quickly mean official support for the Bizgres Project at Sun, and making it an actual multi-company project.<br/>
<br/>
<span style="font-weight: bold;">My primary job at Sun will be Open Source advocacy</span>, so expect to see me at even more conferences in the future.&nbsp; And maybe I'll even get time to work on the book!<br/>
<br/>
<span style="font-weight: bold;">GreenPlum is still a cool place to work with a great product</span>, I just felt I couldn't pass up this opportunity.&nbsp;&nbsp; If you are interested in doing data warehousing on PostgreSQL for a living, let them know ... they're hiring!]]>
</description>
      <dc:creator>Undefined</dc:creator>
      <dc:date>2006-03-24T17:17:49-08:00</dc:date>
    </item>
    <item>
      <title>Article: random_agg()</title>
      <link>http://powerpostgresql.com/article/19</link>
      <guid>http://powerpostgresql.com/article/19</guid>
      <description>
        <![CDATA[&nbsp;Put a new doc up, called <a href="/Random_Aggregate">random_agg().</a>&nbsp; Read about it on my <a href="http://blogs.ittoolbox.com/database/soup/archives/008336.asp">ITToolBox Blog</a>.<br/>]]>
</description>
      <dc:creator>Undefined</dc:creator>
      <dc:date>2006-03-17T23:10:58-08:00</dc:date>
    </item>
    <item>
      <title>Article: The 5 Types, in Portuguese</title>
      <link>http://powerpostgresql.com/article/18</link>
      <guid>http://powerpostgresql.com/article/18</guid>
      <description>
        <![CDATA[Fabio Telles just <a href="http://tellesr.multiply.com/journal/item/60">translated the 5 types of OSS projects into Portuguese</a>. Man, I love Brazillians!]]>
</description>
      <dc:creator>Undefined</dc:creator>
      <dc:date>2006-01-24T10:26:24-08:00</dc:date>
    </item>
    <item>
      <title>Musing: The hidden benefits of wal_buffers</title>
      <link>http://powerpostgresql.com/article/17</link>
      <guid>http://powerpostgresql.com/article/17</guid>
      <description>
        <![CDATA[&nbsp;Hmmmm ....<br/>
<br/>
Due to <a href=http://pgfoundry.org/docman/view.php/1000041/79/wal_buffer_test.pdf>some tests I did on wal_buffers</a>, it appears that the level of wal_buffers you set has a significant effect on performance in 8.0 and 8.1, unlike our tests 3 years ago on 7.3.&nbsp;&nbsp; <br/>
<br/>
As you can see, increasing wal_buffers to a level somewhere between 64 and 256 made a big difference on the STP&nbsp; DBT2 tests on 4-processor machines.&nbsp; Interestingly, the number of connections used in this test is about 150.&nbsp; I wonder if the idea level of wal_buffers is equal to the number of simultaneous write connections you have?<br/>
<br/>
Must test more.&nbsp;&nbsp; Outside data is wanted, too; DBT2 is a pretty specific case.<br/>
]]>
</description>
      <dc:creator>Undefined</dc:creator>
      <dc:date>2005-09-08T16:32:55-07:00</dc:date>
    </item>
    <item>
      <title>Announcement: Blogish Blogger Blogging Blogosphere Blaugh</title>
      <link>http://powerpostgresql.com/article/16</link>
      <guid>http://powerpostgresql.com/article/16</guid>
      <description>
        <![CDATA[&nbsp;I now have a syndicated blog at ITToolBox.com, called <a href=http://blogs.ittoolbox.com/database/soup/>database soup</a>.&nbsp; I'll be using that blog to post on &quot;general&quot; issues, and reserve this web page specifically for PostgreSQL performance.&nbsp; Speaking of which ....<br/>
]]>
</description>
      <dc:creator>Undefined</dc:creator>
      <dc:date>2005-09-06T12:09:42-07:00</dc:date>
    </item>
    <item>
      <title>Presentations: Presos, Presos Everywhere</title>
      <link>http://powerpostgresql.com/article/13</link>
      <guid>http://powerpostgresql.com/article/13</guid>
      <description>
        <![CDATA[Since the various convention sites don't yet have them up, I've posted a bunch of presentations on the <a href="Docs">Docs page.</a><br/>
<br/>
This includes:<br/>
Joy Of Index: Last year's OSCON presentation, about database indexing in general.<br/>
Terabytes of Business Intelligence: This year's OSCON presentation, with Joe Conway, about data warehouses on Postgres.<br/>
Database Dependence as a Design Strategy: Given to SF Perl a couple years ago in response to a some stupid online rants.<br />
<br/>
As usually, all presentations are available under the OPL unless otherwise stated on the slides.<br/>]]>
</description>
      <dc:creator>Undefined</dc:creator>
      <dc:date>2005-08-18T23:11:33-07:00</dc:date>
    </item>
    <item>
      <title>Announcement: Bizgres in Business</title>
      <link>http://powerpostgresql.com/article/12</link>
      <guid>http://powerpostgresql.com/article/12</guid>
      <description>
        <![CDATA[<a href="http://www.bizgres.org">Here</a> you can see what I've been working on for the past several weeks. Yes, I'm currently working for <a href="http://www.greenplum.com/">Greenplum</a>. It's pretty cool; they pay me to work on PostgreSQL performance, which I was doing anyway.<br /><br />Greenplum's approach is something I think you'll see increasingly now. They're promoting PostgreSQL as a base platform for business intelligence / data warehousing because a PostgreSQL standard makes their PostgreSQL-derived technology more valuable (and better as PostgreSQL improves). <br /><br />I've already written about 80K of hype about Bizgres, so I think I'll leave it out here. Check out <a href="http://www.bizgres.org">the website</a> if you want to know more. And now that we're public, I can start sharing more of what I'm doing here.<br /><br /><br />
]]>
</description>
      <dc:creator>Undefined</dc:creator>
      <dc:date>2005-04-17T19:04:28-07:00</dc:date>
    </item>
    <item>
      <title>Presentations: Database Dependance</title>
      <link>http://powerpostgresql.com/article/11</link>
      <guid>http://powerpostgresql.com/article/11</guid>
      <description>
        <![CDATA[
Per David Fetter's request, I'm putting up a presentation I did for Perlmongers last year called <a href="Downloads/database_depends_public.sxi">Database Dependance as A Design Strategy</a>.   It's an OpenOffice.org presentation; if you don't have OpenOffice.org (shame on you!), get it<a href="www.openoffice.org"> here.</a>  Or you can view<a href="Downloads/database_depends_public.swf"> the Flash version</a>, though it's not as cool.<br /><br />The idea behind the preso was to counteract some of the BS around the internet about Database Independance being an unalloyed Good Thing and a requirement for all serious application development.   Like most other design choices, it's a tradeoff with advantages and costs.<br /><br /><br />]]>
</description>
      <dc:creator>Undefined</dc:creator>
      <dc:date>2005-04-07T15:41:42-07:00</dc:date>
    </item>
    <item>
      <title>Article: 5 Types Final</title>
      <link>http://powerpostgresql.com/article/10</link>
      <guid>http://powerpostgresql.com/article/10</guid>
      <description>
        <![CDATA[
OK, <a href="/5_types" title="Five Types">The Five Types of Open Source</a> Projects is &quot;final&quot;, for some definition of &quot;final&quot; ...]]>
</description>
      <dc:creator>Undefined</dc:creator>
      <dc:date>2005-03-15T23:05:31-08:00</dc:date>
    </item>
    <item>
      <title>Article: Draft of 5 Types of OSS Projects Up</title>
      <link>http://powerpostgresql.com/article/9</link>
      <guid>http://powerpostgresql.com/article/9</guid>
      <description>
        <![CDATA[
I've put up a draft of <a title="The 5 Types" href="/5_types">The Five Types of Open Source Projects</a>.   I'd like to get some feedback from other members of the Open Source community; particularly, I'm concerned about the accuracy of my categorizations.<br /><br />Comments welcome!<br />]]>
</description>
      <dc:creator>Undefined</dc:creator>
      <dc:date>2005-03-13T12:26:56-08:00</dc:date>
    </item>
    <item>
      <title>Snippet: Perl Parse FTS</title>
      <link>http://powerpostgresql.com/article/8</link>
      <guid>http://powerpostgresql.com/article/8</guid>
      <description>
        <![CDATA[
<p>Some folks on the OpenFTS mailing list asked me for this, so I thought I'd post it here.   This is a simple PL/perl function which cleans up Boolean search logic submitted by users through a search form.  Currently, it handles AND, OR, and () parens.   It does not handle NOT or !.    It also assumes that, if an operator is left out, &amp; should be used.  Thus &quot;dogs cats fish&quot; becomes &quot;dogs &amp; cats &amp; fish&quot;.<br /></p><p><br />Improvements welcome!<br /></p>
<pre>create or replace function parse_fti_string (<br />        TEXT )<br />RETURNS TEXT AS '<br />my $result;<br />for (split /s+/, shift) {<br />    if (/^and$/i) {<br />        $result .= &quot; &amp;&quot; if defined $result and $result !~ /[|&amp;]$/;<br />    } elsif (/^or$/i) {<br />        $result .= &quot; |&quot; if defined $result and $result !~ /[|&amp;]$/;<br />    } else {<br />        if (!defined $result) {<br />            $result = $_<br />        } elsif ( $result =~ /[(|&amp;]$/ ) {<br />            $result .= &quot; &quot; . $_;<br />        } else {<br />            $result .= &quot; &amp; &quot; . $_;<br />        }<br />    }<br />}<br />return $result;<br />' language plperl immutable strict;</pre>

<p>P.S. a big thanks to David Wheeler for cleaning up my Perl.<br /></p>]]>
</description>
      <dc:creator>Undefined</dc:creator>
      <dc:date>2005-03-07T11:37:20-08:00</dc:date>
    </item>
    <item>
      <title>Article: How The Planner Uses Statistics</title>
      <link>http://powerpostgresql.com/article/7</link>
      <guid>http://powerpostgresql.com/article/7</guid>
      <description>
        <![CDATA[Mark Kirkwood drafted this for the PostgreSQL 8.1 docs.  However, I felt that people deserved to get a look at it now, so we're posting it here.<br /><a href="/PlanStats"><br />How The Planner Uses Statistics</a><br /><br />If you have corrections, don't e-mail me; e-mail the PGSQL-DOCS mailing list.<br />
]]>
</description>
      <dc:creator>Undefined</dc:creator>
      <dc:date>2005-02-16T21:24:55-08:00</dc:date>
    </item>
    <item>
      <title>Article: Annotated.Conf is finally here!</title>
      <link>http://powerpostgresql.com/article/6</link>
      <guid>http://powerpostgresql.com/article/6</guid>
      <description>
        <![CDATA[
Yes, it's finally online, only about a month late.   <br /><br />I've put up the <a href="/Downloads/annotated_conf_80.html">Annotated PostgreSQL.Conf</a> for your 8.0 configuration pleasure.  Here it is again,<a href="/Downloads/annotated_conf_80.pdf"> in PDF format</a>. <br /><br />Some remarks and caveats on this new version:<br /><ol><li>Any advice given in the new version supercedes the advice given at General Bits.  It's been a year and a half, we've learned a lot about PostgreSQL performance.</li><li>You'll notice on the new version that I did <span style="font-style: italic;">not </span>include any of the &quot;developer only&quot; GUCs.   This is on purpose; those are no longer included in PostgreSQL.conf, and before you use them you'd better be familiar with the main docs enough that you don't need help from me.</li><li>This document will be updated.  Heck, even now Simon is testing whether or not commit_delay actually has any effect in 8.0.</li><li>The order of individual conf parameters is not exactly the same as the .conf file or the runtime-config page in the docs. This is because these two have become out of sync, something I plan to fix before 8.1. The order of the sections is identical, though, so just scroll a bit.<br /></li></ol>So, enjoy, and e-mail me your comments until we have the online comment system working!<br />]]>
</description>
      <dc:creator>Undefined</dc:creator>
      <dc:date>2005-02-09T13:40:22-08:00</dc:date>
    </item>
    <item>
      <title>Announcement: Site Registration, Comments</title>
      <link>http://powerpostgresql.com/article/5</link>
      <guid>http://powerpostgresql.com/article/5</guid>
      <description>
        <![CDATA[We apologize that you can't currently register for the site and start posting comments here.  We're working on fixing it. Watch this space for updates.
]]>
</description>
      <dc:creator>Undefined</dc:creator>
      <dc:date>2005-02-02T23:53:44-08:00</dc:date>
    </item>
    <item>
      <title>Article: The Configuration Checklist is up!</title>
      <link>http://powerpostgresql.com/article/3</link>
      <guid>http://powerpostgresql.com/article/3</guid>
      <description>
        <![CDATA[Folks,<br /><br />OK, the <a href="/PerfList/" title="Go There">PostgreSQL 8.0 Configuration Checklist</a> is now up. Take a look, give me feedback.<br />
]]>
</description>
      <dc:creator>Undefined</dc:creator>
      <dc:date>2005-01-11T11:29:29-08:00</dc:date>
    </item>
    <item>
      <title>Announcement: Welcome to Power PostgreSQL!</title>
      <link>http://powerpostgresql.com/article/2</link>
      <guid>http://powerpostgresql.com/article/2</guid>
      <description>
        <![CDATA[Hey, welcome to our little book-and-blog site.  Over the next 12 months, you'll see a variety of articles and snippets of the book published here.  Once the book is out, then we'll offer addenda, corrections, and maybe even scripts and programs.<br /><br />And, of course, us griping about how long the book is taking us.<br />
]]>
</description>
      <dc:creator>Undefined</dc:creator>
      <dc:date>2005-01-07T16:45:59-08:00</dc:date>
    </item>
  </channel>
</rss>