Search Postgresql Archives

Tools for partitioning and query optimization

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hey Folks-

I've got 2 projects out that I'm finding useful, so I thought I'd share with the wider postgres community.

The first is PgPartition [0].  This (python) tool eliminates the monotony of dealing with partitions.  It generates SQL to create/index/remove/alter partitions.

The second is PgTweak [1].  This is a somewhat nascent (also python) project, but I hope for it to be more useful.  The main idea is to try out different setting combinations and to see what effect they have on query performance.  It does this right now.  I'd like for it to analyze the EXPLAIN ANALYZE output and make somewhat intelligent suggestions.

Any feedback is appreciated.  Hopefully these tools are useful to others.

cheers,

matt

0 - http://github.com/mattharrison/PgPartition
1 - http://github.com/mattharrison/PgTweak

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux