Postgres Pro
Downloads
Home   >   mailing lists

Tools for partitioning and query optimization - Mailing list pgsql-general

From Matt Harrison
Subject Tools for partitioning and query optimization
Date
Msg-id AANLkTi=Fvx+f6RRhUUiZA4iikv7F3xxcCbr05wHbG4Pj@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: Problem with Crosstab - Allocating value to wrong column
Next
From: Chris Browne
Date:
Subject: Re: NoSQL -vs- SQL