| From: | bricklen <bricklen(at)gmail(dot)com> |
|---|---|
| To: | Dave Johansen <davejohansen(at)gmail(dot)com> |
| Cc: | pgsql-performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Recommendations for partitioning? |
| Date: | 2013-12-20 16:07:22 |
| Message-ID: | CAGrpgQ9vYFgFz_X1z0wqu6vertu0t3__DDmJTLo4a8Hn0tjDMw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Fri, Dec 20, 2013 at 7:52 AM, Dave Johansen <davejohansen(at)gmail(dot)com>wrote:
> It would be nice if there was just a "move command", but that seems like
> the type of model that we want and we'll probably move to that.
I haven't been following this thread, but this comment caught my eye. Are
you after the "NO INHERIT" command?
http://www.postgresql.org/docs/current/static/sql-altertable.html Search
for the "NO INHERIT" clause -- it will allow you to detach a child table
from an inherited parent which can then archive or copy into another table.
Inserting into the rolled-up partition was already mentioned upthread I see.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shaun Thomas | 2013-12-20 16:11:39 | Re: slow query - will CLUSTER help? |
| Previous Message | Alvaro Herrera | 2013-12-20 15:59:54 | Re: Recommendations for partitioning? |