Re: partition question for new server setup

Список
Период
Сортировка
От Kenneth Marshall
Тема Re: partition question for new server setup
Дата
Msg-id 20090428180621.GI26100@it.is.rice.edu
обсуждение исходный текст
Ответ на Re: partition question for new server setup  (Scott Marlowe)
Ответы Re: partition question for new server setup  (Craig James)
Re: partition question for new server setup  (Scott Marlowe)
Список pgsql-performance
Дерево обсуждения
partition question for new server setup  (Whit Armstrong, )
 Re: partition question for new server setup  (Scott Marlowe, )
  Re: partition question for new server setup  (Whit Armstrong, )
   Re: partition question for new server setup  (Scott Marlowe, )
    Re: partition question for new server setup  (Kenneth Marshall, )
     Re: partition question for new server setup  (Craig James, )
      Re: partition question for new server setup  ("Kevin Grittner", )
       Re: partition question for new server setup  (Kenneth Marshall, )
        Re: partition question for new server setup  (Scott Marlowe, )
      Re: partition question for new server setup  (Whit Armstrong, )
       Re: partition question for new server setup  ("Kevin Grittner", )
        Re: partition question for new server setup  (Whit Armstrong, )
       Re: partition question for new server setup  (Scott Marlowe, )
      Re: partition question for new server setup  (Scott Carey, )
       Re: partition question for new server setup  (Whit Armstrong, )
        Re: partition question for new server setup  (Scott Carey, )
     Re: partition question for new server setup  (Scott Marlowe, )
   Re: partition question for new server setup  (Alan Hodgson, )
 Re: partition question for new server setup  (Craig James, )
  Re: partition question for new server setup  (Scott Carey, )
   Re: partition question for new server setup  (Whit Armstrong, )
    Re: partition question for new server setup  (Scott Carey, )
     Re: partition question for new server setup  (Whit Armstrong, )
   Re: partition question for new server setup  (Scott Marlowe, )
 Re: partition question for new server setup  (Scott Carey, )
  Re: partition question for new server setup  (Whit Armstrong, )
On Tue, Apr 28, 2009 at 11:56:25AM -0600, Scott Marlowe wrote:
> On Tue, Apr 28, 2009 at 11:48 AM, Whit Armstrong
> <> wrote:
> > Thanks, Scott.
> >
> > Just to clarify you said:
> >
> >> postgres. ?So, my pg_xlog and all OS and logging stuff goes on the
> >> RAID-10 and the main store for the db goes on the RAID-10.
> >
> > Is that meant to be that the pg_xlog and all OS and logging stuff go
> > on the RAID-1 and the real database (the
> > /var/lib/postgresql/8.3/main/base directory) goes on the RAID-10
> > partition?
>
> Yeah, and extra 0 jumped in there.  Faulty keyboard I guess. :)  OS
> and everything but base is on the RAID-1.
>
> > This is very helpful. ?Thanks for your feedback.
> >
> > Additionally are there any clear choices w/ regard to filesystem
> > types? ?Our choices would be xfs, ext3, or ext4.
>
> Well, there's a lot of people who use xfs and ext3.  XFS is generally
> rated higher than ext3 both for performance and reliability.  However,
> we run Centos 5 in production, and XFS isn't one of the blessed file
> systems it comes with, so we're running ext3.  It's worked quite well
> for us.
>

The other optimizations are using data=writeback when mounting the
ext3 filesystem for PostgreSQL and using the elevator=deadline for
the disk driver. I do not know how you specify that for Ubuntu.

Cheers,
Ken

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: partition question for new server setup
Следующее
От: Craig James
Дата:
Сообщение: Re: partition question for new server setup