Re: [PERFORM] Postgres partitions-query scanning all child tables

2016-01-27 Thread Corey Huinker
On Thu, Jan 28, 2016 at 1:10 AM, rverghese wrote: > Ok, thanks. Thats a bummer though. That means I need a table for every > month/year combination. I was hoping to limit it to 12 tables. > > Riya > > If you wanted to have a column called month_num or something like that, and if *all* of your que

Re: [PERFORM] Postgres partitions-query scanning all child tables

2016-01-27 Thread Corey Huinker
On Wed, Jan 27, 2016 at 5:09 PM, rverghese wrote: > Hi I have a master table and the inherited tables broken up by month. > > /e.g. CONSTRAINT transactions_january_log_date_check CHECK > (date_part('month'::text, log_date) = 1::double precision);/ > > So transactions_master is the master table,

Re: [PERFORM] Another parallel postgres project...

2015-09-29 Thread Corey Huinker
l, but I recently found another PG > parallelism project which can do a few extra things that par_psql can’t: > > https://github.com/moat/pmpp > pmpp: Poor Man's Parallel Processing. > > Corey Huinker had the idea of using dblink async as a foundation for > distributing queri