subtable <-> bigtable

From: Peter Pilsl <pilsl(at)goldfisch(dot)at>
To: pgsql-general(at)postgresql(dot)org
Subject: subtable <-> bigtable
Date: 2001-12-16 01:54:43
Message-ID: 20011216025443.D6080@i3.atat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've a very big table that is read very frequently and I want to split
this table in more subtables with different permissions for
insert/update/delete. I need to keep the big table too, cause the
reading application can only deal with one table.

So I am thinking about generating a set of update,insert,delete-rules
for each of the 'subtables' that will update,insert,delete the
'maintable'.
I'm not worried about the needed time, cause write access is very
seldom, but I'm needed about the effort to implement this solution.
First I've to add a new oid-column to establish the relation between
the subtables and the maintable, then I've to create three long rules
for each subtable with long insert,update,delete-commands and in fact
I dont only have 1 table to split but a load.

Is there any construct I can use to form a 'virtual table' that
contains all the subtables or any other method to make my work easier.

I guess my problem is not so uncommon ..

thnx,
peter

ps: and I'd like to win the price for the worth subject in day, but I
really didnt know how to deal with it ...

--
mag. peter pilsl

phone: +43 676 3574035
fax : +43 676 3546512
email: pilsl(at)goldfisch(dot)at
sms : pilsl(at)max(dot)mail(dot)at

pgp-key available

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2001-12-16 02:38:00 Re: subtable <-> bigtable
Previous Message Frank Finner 2001-12-15 22:40:27 Re: Perl DBI, PostgreSQL performance question