Re: Moving pg_xlog

Поиск
Список
Период
Сортировка
От Himanshu Baweja
Тема Re: Moving pg_xlog
Дата
Msg-id 20050602070209.96753.qmail@web51005.mail.yahoo.com
обсуждение исходный текст
Ответ на Moving pg_xlog  ("Keith Worthington" <keithw@narrowpathinc.com>)
Ответы Re: Moving pg_xlog  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Grega Bremec
Дата:
Сообщение: Re: 'Fastest' PC's are slowest in the house
Следующее
От: "Mindaugas Riauba"
Дата:
Сообщение: Re: How to avoid database bloat