From: | "Ertel, Steve" <Steve(dot)Ertel(at)infimatic(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: managing table partitions automatically |
Date: | 2008-11-13 14:42:28 |
Message-ID: | 863ECFDF04C8804ABDF3559D87F157C601472CAF@MAGPTCPEXC02.na.mag-ias.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Still haven't heard from anyone.
I could really use your help.
Do you have any suggestions?
Thanks,
Steve
________________________________
From: pgsql-novice-owner(at)postgresql(dot)org [mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Ertel, Steve
Sent: Wednesday, November 12, 2008 12:48 PM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] managing table partitions automatically
Hello All,
I am beginning to partition some database tables and need some help thinking things through. After evaluating my data, it appears that the best partition would be based on year and month. I was planning to create my tables in the format of tablename_yyyy_mm.
I planned to create a parent table and child tables (similar to the example at http://www.postgresql.org/docs/8.1/static/ddl-partitioning.html) <http://www.postgresql.org/docs/8.1/static/ddl-partitioning.html> . I would create the child tables for the range of my data and maybe even a few months in advance. I have all of the insert, update, and delete rules worked out to manage the data. The data will be routed to tables based on a date that is passed to the table (e.g. start_time). The date can be in the future or in the past.
The problem is that the databases are running on remote servers and I will not have access to them. I need to find a way to automatically create the child tables, indexes, and rules. Any suggestions would be helpful. I am stuck.
Thanks,
Steve
From | Date | Subject | |
---|---|---|---|
Next Message | Obe, Regina | 2008-11-13 16:10:11 | Re: managing table partitions automatically |
Previous Message | Obe, Regina | 2008-11-13 12:25:12 | Re: Upgrade, Install, RPM |