| From: | Himanshu Baweja <himanshubaweja(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Moving pg_xlog |
| Date: | 2005-06-02 07:02:09 |
| Message-ID: | 20050602070209.96753.qmail@web51005.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
My database has two scsi disks....
my current configuration has pg_xlog on disk1 and data on disk2....
the machine is used for database only....
now did some logging and came to a conclusion that my disk2(data disk) is getting used around 3 times more than disk1(pg_xlog)....
so wht is recommended... move some of the data to disk1 so that both disks are equally used... by creating tablespaces or let my configuration be whts its currently... iowait is one of the bottlenecks in my application performance.....
thx
Himanshu
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mindaugas Riauba | 2005-06-02 07:28:03 | Re: How to avoid database bloat |
| Previous Message | Grega Bremec | 2005-06-02 06:32:00 | Re: 'Fastest' PC's are slowest in the house |