| From: | "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: table size |
| Date: | 2003-09-23 10:24:05 |
| Message-ID: | 1379.192.168.7.161.1064312645.squirrel@mail4.pspl.co.in |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
> I have a table in my database which can grow very quickly. Is
> there some way to partition the table so that when it reaches a certain
> size the
> information in it is copied to a temporary table and the
> original table is free again.
You can create a view and update the view definition periodically to
add/remove tables from view definition. Your data insertion should be
pointed to a new table after specific period.
That way you can achieve table partitioning. Since DDLs in postgresql are
transactable, it should be absolutely transparent to the application and
other users.
HTH
Shridhar
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nikola Milutinovic | 2003-09-23 10:37:36 | IGNORE: test |
| Previous Message | Jason Godden | 2003-09-23 10:08:50 | Re: table size |