| From: | Enrico Weigelt <weigelt(at)metux(dot)de> |
|---|---|
| To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | cost of empty fields |
| Date: | 2005-04-15 14:22:07 |
| Message-ID: | 20050415142206.GA347@nibiru.borg.metux.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi folks,
we've got an quite large table with 17 columns and now >15k rows.
The table works also as an journal will continously grow day by day.
Man of the columns (mostly text) aren't needed anymore if the tuple
has reached a certain age.
So I thought about clearing the unnecessary fields of old tuples
to save resources. Does it bring any performance improvement ?
Of I could splitt off this table an working- an archive- table
and map them together in some views - someday I probably *will*
do it - but our applications are not yet ready for this.
thx
--
---------------------------------------------------------------------
Enrico Weigelt == metux IT service
phone: +49 36207 519931 www: http://www.metux.de/
fax: +49 36207 519932 email: contact(at)metux(dot)de
cellphone: +49 174 7066481
---------------------------------------------------------------------
-- DSL ab 0 Euro. -- statische IP -- UUCP -- Hosting -- Webshops --
---------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sanjay tumula | 2005-04-15 14:24:52 | performance problem |
| Previous Message | Tom Lane | 2005-04-15 13:59:01 | Re: Out of memory problem. |