Partitioning

From: Arnau <arnaulist(at)andromeiberica(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Partitioning
Date: 2007-01-05 11:02:21
Message-ID: 459E303D.8080908@andromeiberica.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi all,

I'm not sure if this question fits in the topic of this list.

I'm interested in partitioning and it's the first time I'd use it.
There is an issue I don't know how you handle it. Lets say I'm
interested in store monthly based statistical data like the example of
http://www.postgresql.org/docs/8.2/static/ddl-partitioning.html. What I
don't like of this approach is that the monthly tables, rules... must be
created "manually" or at least I haven't found any other option.

My question is how do you manage this? do you have a cron task that
creates automatically these monthly elements (tables, rules, ... ) or
there is another approach that doesn't require external things like cron
only PostgreSQL.
--
Arnau

Browse pgsql-performance by date

  From Date Subject
Next Message Mikael Carneholm 2007-01-05 11:47:08 Re: Partitioning
Previous Message Grega Bremec 2007-01-05 03:10:20 Re: PostgreSQL to host e-mail?