hello ...
yeah, this is fairly complicated.
greg:
can you send me how far you got?
i would be curious to see how you have attacked this issue.
i am still in the process of checking the codes.
we somehow have to find a solution for that. otherwise we are in slight trouble
here.
it seems we have
On Fri, Jul 23, 2010 at 10:04:00PM +0200, Hans-Jürgen Schönig wrote:
create table foo ( x date );
create table foo_2010 () INHERITS (foo)
create table foo_2009 () INHERITS (foo)
create table foo_2008 () INHERITS (foo)
now we add constraints to make sure that data is
On Jul 25, 2010, at 11:56 AM, Martijn van Oosterhout wrote:
On Fri, Jul 23, 2010 at 10:04:00PM +0200, Hans-Jürgen Schönig wrote:
create table foo ( x date );
create table foo_2010 () INHERITS (foo)
create table foo_2009 () INHERITS (foo)
create table foo_2008 () INHERITS
2010/7/25 PostgreSQL - Hans-Jürgen Schönig postg...@cybertec.at:
On Jul 25, 2010, at 11:56 AM, Martijn van Oosterhout wrote:
On Fri, Jul 23, 2010 at 10:04:00PM +0200, Hans-Jürgen Schönig wrote:
create table foo ( x date );
create table foo_2010 () INHERITS (foo)
create table
2010/7/25 Robert Haas robertmh...@gmail.com:
2010/7/25 PostgreSQL - Hans-Jürgen Schönig postg...@cybertec.at:
On Jul 25, 2010, at 11:56 AM, Martijn van Oosterhout wrote:
I think the right way to approach this is to teach the planner about
merge sorts.
For what it's worth I think this is a
On Sun, Jul 25, 2010 at 6:40 PM, Greg Stark gsst...@mit.edu wrote:
2010/7/25 Robert Haas robertmh...@gmail.com:
2010/7/25 PostgreSQL - Hans-Jürgen Schönig postg...@cybertec.at:
On Jul 25, 2010, at 11:56 AM, Martijn van Oosterhout wrote:
I think the right way to approach this is to teach the
hello everybody,
i have just come across some issue which has been bugging me for a while.
consider:
SELECT * FROM foo ORDER BY bar;
if we have an index on bar, we can nicely optimize away the sort step by
consulting the index - a btree will return sorted output.
under normal
On 7/23/2010 11:04 PM, Hans-Jürgen Schönig wrote:
does anybody see a solution to this problem?
what are the main showstoppers to make something like this work?
I think we should absolutely make this work when we have a good
partitioning implementation.
That said, I don't think it's wise to