[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    iterate over partitions
From:       Glenn Schultz <glenn () bondlab ! io>
Date:       2019-06-28 19:11:47
Message-ID: CAE-4=KHcn8cL+o7HVzF2pYiamynodQPB=OG2LGnt7JUqVgzXFQ () mail ! gmail ! com
[Download RAW message or body]

Hi All,

I have a large table partioned by month.  I would like to run a query -
which adds derived data to the current data and inserts the data into a new
table.  The new table is the target for users.

How can I iterate over the partition tables to insert data and build the
new table?
This is done monthly, am I better off creating a materalized view each
month?

Best,
Glenn

[Attachment #3 (text/html)]

<div dir="ltr">Hi All,<div><br></div><div>I have a large table partioned by month.   \
I would like to run a query - which adds derived data to the current data and inserts \
the data into a new table.   The new table is the target for \
users.</div><div><br></div><div>How can I iterate over the partition tables to insert \
data and build the new table?</div><div>This is done monthly, am I better off \
creating a materalized view each month?  \
</div><div><br></div><div>Best,</div><div>Glenn</div></div>



[prev in list] [next in list] [prev in thread] [next in thread]