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
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
Date: Wed, 27 Jan 2016 21:31:35 -0700
From: ml-node+s1045698n5884560...@n5.nabble.com
To: ri...@hotmail.com
Subject: Re: Postgres partitions-query scanning al
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,
in postgres 9.5.0 i have partitioned table, that collect data by months, i
tried to use new postgres feature foreign table inheritance & pushed one month
of data to another postgres server, so i got foreign table. when i am running
my query from my primary server, query takes 7x more time to exe
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, and then transactions_january,
transactions_february, etc. I h
