Skip site navigation (1) Skip section navigation (2)

Re: Automating Partitions in PostgreSQL - Query on syntax

From: "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net>
To: Kedar Potdar <kedar(dot)potdar(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Automating Partitions in PostgreSQL - Query on syntax
Date: 2009-04-21 13:46:41
Message-ID: 1240321601.7167.9.camel@analise3.cresoltec.com.br (view raw or flat)
Thread:
Lists: pgsql-hackers
Em Ter, 2009-04-21 às 17:20 +0530, Kedar Potdar escreveu:
> Hi , 
> 
> We are working on a patch to automate partitioning in PostgreSQL. 

Nice. ":)

> For Range partitions, we have proposed the syntax which is as
> follows  
> 
> (...)
> PARTITION BY RANGE (emp_id)
> (
> emp_500 (START 1 END 500),
> emp_1500 (START 500 END 1500),
> emp_4000 (START 1520 END 4000)
> );

What if I need more columns to set the partitions?


[]s
-- 
Dickson S. Guedes 
mail/xmpp: guedes(at)guedesoft(dot)net - skype: guediz
http://guedesoft.net - http://planeta.postgresql.org.br

In response to

Responses

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2009-04-21 13:58:11
Subject: Re: 8.4 semi-join slows down query performance (EXISTS)
Previous:From: Kedar PotdarDate: 2009-04-21 13:38:18
Subject: Re: Automating Partitions in PostgreSQL - Query on syntax

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group