Need Advice In Improving Database Disc Usage

From: Yan Cheng Cheok <yccheok(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Need Advice In Improving Database Disc Usage
Date: 2010-02-03 04:00:30
Message-ID: 992893.10813.qm@web65706.mail.ac4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

We are now planning to move over, from plan text file storage to database storage. However, we do see our disc usage increased by factor of 50.

http://sites.google.com/site/yanchengcheok/Home/du.PNG

(1) Is there any need for me to create idx_fk_measurement_type_id and idx_fk_measurement_unit_id

The above 2 are the index for measurement's foreign key. However, these 2 foreign key are only used in JOIN statement, but never used in WHERE statement. So, if I remove the 2 index, will I still achieve the same query performance?

(2) How can I increase the compression ratio for my database?

Thanks and Regards
Yan Cheng CHEOK

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Frankel 2010-02-03 05:14:13 add column specify position
Previous Message Adrian Klaver 2010-02-03 03:58:35 Re: What is the graceful way to stop (kill) postmaster?