Postgres Pro
Downloads
Home   >   mailing lists

Re: Automating Partitions in PostgreSQL - Query on syntax - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Automating Partitions in PostgreSQL - Query on syntax
Date
Msg-id 4136ffa0904210459j28edf414j3b12bdb325f764df@mail.gmail.com
Whole thread Raw
In response to Automating Partitions in PostgreSQL - Query on syntax  (Kedar Potdar <kedar.potdar@gmail.com>)
Responses Re: Automating Partitions in PostgreSQL - Query on syntax  (Kedar Potdar <kedar.potdar@gmail.com>)
List pgsql-hackers
Tree view 
On Tue, Apr 21, 2009 at 12:50 PM, Kedar Potdar <kedar.potdar@gmail.com> wrote:
> I want to seek general opinion from the community on preferences between
> user-friendly ‘Oracle’ syntax, and a more generic syntax that allows ‘gaps’
> in partition ranges?


What happens to records in the overflow table when you add a new
partition whose range covers their values?

--
greg

pgsql-hackers by date:

Previous
From: Guillaume Smet
Date:
Subject: Re: 8.4 semi-join slows down query performance (EXISTS)
Next
From: "steven king"
Date:
Subject: Re: 8.4 semi-join slows down query performance (EXISTS)