Re: Automating Partitions in PostgreSQL - Query on syntax

From: Greg Stark <stark(at)enterprisedb(dot)com>
To: Kedar Potdar <kedar(dot)potdar(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, Amit Gupta <amit(dot)pc(dot)gupta(at)gmail(dot)com>
Subject: Re: Automating Partitions in PostgreSQL - Query on syntax
Date: 2009-04-21 11:59:18
Message-ID: 4136ffa0904210459j28edf414j3b12bdb325f764df@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Apr 21, 2009 at 12:50 PM, Kedar Potdar <kedar(dot)potdar(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message steven king 2009-04-21 12:10:01 Re: 8.4 semi-join slows down query performance (EXISTS)
Previous Message Guillaume Smet 2009-04-21 11:53:01 Re: 8.4 semi-join slows down query performance (EXISTS)