Adding on to this use case:
what do we do when we reach end of year?
Probably auto-archive as per weekly, monthly , quarterly or yearly tables?
On Thu, Jan 7, 2010 at 1:14 AM, Josh Berkus j...@agliodbs.com wrote:
On 1/6/10 9:13 AM, Robert Haas wrote:
On Wed, Jan 6, 2010 at 12:06 PM, David
On Thu, Jan 07, 2010 at 08:01:16PM +0530, Chetan Suttraway wrote:
Adding on to this use case:
what do we do when we reach end of year?
Probably auto-archive as per weekly, monthly , quarterly or yearly tables?
Because such requirements are so specific to each place, it's easier
to do this in
On Tue, Jan 05, 2010 at 08:50:25PM -0700, u235sentinel wrote:
Robert Haas wrote:
Getting full?
...Robert
Ok. Bad analogy. We have the tables setup to write data according
to the month it was loaded. We have a December table, a January
table and so on. Basically following the
On Wed, Jan 6, 2010 at 12:06 PM, David Fetter da...@fetter.org wrote:
On Tue, Jan 05, 2010 at 08:50:25PM -0700, u235sentinel wrote:
Robert Haas wrote:
Getting full?
...Robert
Ok. Bad analogy. We have the tables setup to write data according
to the month it was loaded. We have a
On 1/6/10 9:13 AM, Robert Haas wrote:
On Wed, Jan 6, 2010 at 12:06 PM, David Fetter da...@fetter.org wrote:
On Tue, Jan 05, 2010 at 08:50:25PM -0700, u235sentinel wrote:
Robert Haas wrote:
Getting full?
...Robert
Ok. Bad analogy. We have the tables setup to write data according
to the
http://www.postgresql.org/docs/8.4/static/ddl-partitioning.html
Is there a way to automatically extend table partitions? I'm curious if
/ when a table is getting full if there is a way for postgres to create
additional tables. Or is it all manual?
Thanks :D
--
Sent via pgsql-hackers
On Tue, Jan 5, 2010 at 8:00 PM, u235sentinel u235senti...@gmail.com wrote:
http://www.postgresql.org/docs/8.4/static/ddl-partitioning.html
Is there a way to automatically extend table partitions? I'm curious if /
when a table is getting full if there is a way for postgres to create
Robert Haas wrote:
Getting full?
...Robert
Ok. Bad analogy. We have the tables setup to write data according to
the month it was loaded. We have a December table, a January table and
so on. Basically following the examples given on the 8.4 web site.
I'm thinking it would be nice if