Re: questions about disk configurations

Поиск
Список
Период
Сортировка
Искать
От
eric soroos
Тема
Re: questions about disk configurations
Дата
Msg-id
88699896.1172681174@[4.42.179.151]
Ответ на
Список
Дерево обсуждения
questions about disk configurations Hubert depesz Lubaczewski <depesz@depesz.pl>
Re: questions about disk configurations Adrian 'Dagurashibanipal' von Bidder <avbidder@fortytwo.ch>
Re: questions about disk configurations Hubert depesz Lubaczewski <depesz@depesz.pl>
Re: questions about disk configurations "Keith Bottner" <kbottner@istation.com>
Re: questions about disk configurations Ron Johnson <ron.l.johnson@cox.net>
Re: questions about disk configurations Josh Berkus <josh@agliodbs.com>
Re: questions about disk configurations eric soroos <eric-psql@soroos.net>
Re: questions about disk configurations Josh Berkus <josh@agliodbs.com>
Re: questions about disk configurations Tom Lane <tgl@sss.pgh.pa.us>
Re: questions about disk configurations "scott.marlowe" <scott.marlowe@ihs.com>
Re: questions about disk configurations eric soroos <eric-psql@soroos.net>
Re: questions about disk configurations "scott.marlowe" <scott.marlowe@ihs.com>
Re: questions about disk configurations Josh Berkus <josh@agliodbs.com>
Re: questions about disk configurations "scott.marlowe" <scott.marlowe@ihs.com>
Re: questions about disk configurations Hubert depesz Lubaczewski <depesz@depesz.pl>
Re: questions about disk configurations Ron Johnson <ron.l.johnson@cox.net>
Which of the solution is better? Wei Weng <wweng@kencast.com>
Re: Which of the solution is better? Ron Johnson <ron.l.johnson@cox.net>
Re: Which of the solution is better? Wei Weng <wweng@kencast.com>
Re: Which of the solution is better? Andrew Sullivan <andrew@libertyrms.info>
> 
> Er, no, it's not.  In fact, for a 3-disk config, I reccommend:
> 
> Disk 1: OS, swap, system logs
> Disk 2: Data + Indexes
> Disk 3: Transaction Log

What is the accepted way of splitting the data from pg_xlog?

I've been testing some configurations for low budget performance, and I haven't been able to make this help vs. one disk. (under osx, ymmv)

I rsync'd the pg_xlog directory to another disk, then set up a symlink pointing from the data/pg_xlog to /other/disk/pg_xlog. 

I then got tps numbers that were 2/3 of the single ide drive speed. The only explanation I can come up with is that something is seeking to the symlink, then doing the actual write on the other drive. 

I'm going to try this under linux using mount points, but I need to shuffle hardware first. 


any ideas?

eric



В списке pgsql-performance по дате отправления
От: Tom Lane
Дата:
Сообщение: Re: Speeding up aggregates
От: Joe Conway
Дата:
Сообщение: Re: Speeding up aggregates
FAQ