Re: 8.3 / 8.2.6 restore comparison

Поиск
Список
Период
Сортировка
От Mark Wong
Тема Re: 8.3 / 8.2.6 restore comparison
Дата
Msg-id 20080207174148.3e08b9cf.markwkm@gmail.com
обсуждение исходный текст
Ответ на Re: 8.3 / 8.2.6 restore comparison  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Thu, 07 Feb 2008 13:47:22 -0500
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> "Joshua D. Drake" <jd@commandprompt.com> writes:
> > I know Luke has mentioned some issues in the past as well around CPU
> > boundness with an upper limit of 300M/s (IIRC) but even that doesn't
> > equate to what is going on here as we are not getting anywhere near
> > that.
> 
> Some vmstat and oprofile investigation seems called for.  Right now
> we're just guessing about what the bottleneck is.

I also recommend looking into partition alignment on the disks.  At
least to quantify how much the storage subsystem suffers from
mis-aligned partitions.  It could be that it doesn't.

Regards,
Mark


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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: 8.3 / 8.2.6 restore comparison
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 8.3 / 8.2.6 restore comparison