[GENERAL] A few [Python] tools for postgres

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 PgT

[GENERAL] Tools for partitioning and query optimization

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 PgT

Re: [GENERAL] enabling join_collapse_limit for a single query only

Hi, and thanks for the reply. We're issuing queries from within our application where transactions span a whole unit of work, so wrapping a single query in a transaction just to set the param isn't really feasible except on a separate connection, which i am loathe to do. I was really hopi