pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Matteo Beccati <php@beccati.com>
To: Yann Michel <yann-postgresql@spline.de>
Cc: Matt Casters <Matt.Casters@advalvas.be>
Cc: pgsql-performance@postgresql.org
Subject: Re:
Date: Fri, 21 Jan 2005 15:37:20 +0100
Message-ID: <41F113A0.1020908@beccati.com> (raw)
In-Reply-To: <20050121123008.GA13904@zoom.spline.inf.fu-berlin.de>
References: <16153.193.190.212.113.1106213675.squirrel@193.190.212.113>
	<20050120142603.GM10437@ns.snowman.net>
	<33c6269f050120083177fa0e83@mail.gmail.com>
	<20050121001427.GA10806@wolff.to>
	<12670.193.190.212.113.1106297446.squirrel@193.190.212.113>
	<20050121123008.GA13904@zoom.spline.inf.fu-berlin.de>

Hi,

>>>>  CREATE TABLE super_foo ( partition NUMERIC, bar NUMERIC );
>>>>  ANALYZE super_foo ;
>>>>
>>>>  CREATE TABLE sub_foo1 () INHERITS ( super_foo );
>>>>  CREATE TABLE sub_foo2 () INHERITS ( super_foo );
> 
> Yes, this could be used instead of a view. But there is one thing
> missing. You can't just insert into super_foo and aquire the "correct
> partition". You will still have to insert into the correct underlying
> table. "Real" partitioning will take care of correct partition
> selection.

I've recently used this method for partitioning data. In my setup 
inserts are done inside a pl/pgsql function called at regular intervals, 
so this isn't a problem for me. I didn't test it, but I think some rules 
(or a trigger) could do the trick.


Best regards
--
Matteo Beccati
http://phpadsnew.com
http://phppgads.com




view thread (15+ messages)  latest in thread

Message-ID: <41F113A0.1020908@beccati.com>
Permalink:  ../41F113A0.1020908@beccati.com/
Also on:    postgresql.org/message-id/41F113A0.1020908@beccati.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: php@beccati.com, yann-postgresql@spline.de, Matt.Casters@advalvas.be
  Subject: Re:
  In-Reply-To: <41F113A0.1020908@beccati.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox