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

'Range partitioning in PGSQL'

From: "Saseendra Babu" <saseendra(at)cdactvm(dot)in>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: 'Range partitioning in PGSQL'
Date: 2011-04-11 08:04:37
Message-ID: 2FD8EC4D62BF40BE96DC586406F80612@ksbabu1 (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
?'Range partitioning in PGSQL' 

Is there as in oracle?
My problem is as follows.
I have telephone_ subscriber   table with tel no as Pkey
As the table has to contain millions of rows, I have to partition the table in to multiple partitions  based on range of tel no. 
( At present we did it with inheritance.  but the problem found is: we have to insert  rows in to each child table by referring the table name exclusively , 
based on range of tel nos, keeping the parent table empty.)
What we require is as follows.
  1.. In the insert statement we shall specify only the table name ( not the partition name) 
  2.. The rows are be populated in to the corresponding partions. 
  3..  In select also we should only the table name ( not the partition name). rows are to be retrieved  from  corresponding partitions. 
  4.. While using partition  by inheritance,  we have to specify the partition,  ie  child  table name.
Waiting for your valued suggestions 
Saseendra Babu K

Description: text/x-vcard (307 bytes)


pgsql-novice by date

Next:From: Francisco LeoveyDate: 2011-04-11 11:55:00
Subject: Need SQL of create TABLE including INDEX and SEQUENCE
Previous:From: Josh KupershmidtDate: 2011-04-08 21:39:17
Subject: Re: Valid role name (PostgreSQL 9.0.4)

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