Re: [HACKERS] Automating Partitions in PostgreSQL - Query on syntax

2009-04-21 Thread steven king
Original-Nachricht > Datum: Tue, 21 Apr 2009 14:53:54 -0400 > Von: Robert Haas > An: steven king > CC: lis...@guedesoft.net, pgsql-hackers@postgresql.org, st...@enterprisedb.com > Betreff: Re: [HACKERS] Automating Partitions in PostgreSQL - Query on syntax >

Re: [HACKERS] Automating Partitions in PostgreSQL - Query on syntax

2009-04-21 Thread steven king
Original-Nachricht > Datum: Tue, 21 Apr 2009 13:36:19 -0400 > Von: Robert Haas > An: steven king > CC: Greg Stark , pgsql-hackers@postgresql.org, > lis...@guedesoft.net > Betreff: Re: [HACKERS] Automating Partitions in PostgreSQL - Query on syntax > >

Re: [HACKERS] Automating Partitions in PostgreSQL - Query on syntax

2009-04-21 Thread steven king
Original-Nachricht > Datum: Tue, 21 Apr 2009 16:37:15 +0100 > Von: Greg Stark > An: vac...@quantentunnel.de > CC: "Dickson S. Guedes" , pgsql-hackers@postgresql.org > Betreff: Re: [HACKERS] Automating Partitions in PostgreSQL - Query on syntax > On Tue, Apr 21, 2009 at 4:13 PM,

Re: [HACKERS] Automating Partitions in PostgreSQL - Query on syntax

2009-04-21 Thread steven king
the idea is, that this statement does not create a new kind of db-object. this "CREATE PARTITIONS" statement should be a meta-statement -> "meta" like the serial type. with create paritions you can create all defined tables (maybe by inheritin from ) at once. but you're right - why this state

Re: [HACKERS] 8.4 semi-join slows down query performance (EXISTS)

2009-04-21 Thread steven king
I hope this will treat as a "planner-bug". I think the problem is tricky but not hard to solve. Original-Nachricht > Datum: Tue, 21 Apr 2009 13:53:01 +0200 > Von: Guillaume Smet > An: vac...@quantentunnel.de > CC: pgsql-hackers@postgresql.org > Betreff: Re: [HACKERS] 8.4 semi-j