Re: bad performance on Solaris 10

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: bad performance on Solaris 10
Дата
Msg-id 200604121549.14328.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: bad performance on Solaris 10  ("Luke Lonergan" <llonergan@greenplum.com>)
Ответы Re: bad performance on Solaris 10  ("Merlin Moncure" <mmoncure@gmail.com>)
Список pgsql-performance
People,

> Lately I find people are not so receptive to VxFS, and Sun is promoting
> ZFS, and we don't have a reasonable near term option for Raw IO in
> Postgres, so we need to work to find a reasonable path for Solaris users
> IMO.  The long delays in ZFS production haven't helped us there, as the
> problems with UFS are severe.

FWIW, I'm testing on ZFS now.  But it's not stable yet.  People are welcome
to join the Solaris 11 beta program.

In the near term, there are fixes to be made both in PostgreSQL
configuration and in Solaris configuration.  Also, some of the work being
done for 8.2 ... the external sort work done by Simon and sponsored by
GreenPlum, and the internal sort work which Jonah and others are doing ...
will improve things on Solaris as our sort issues hit Solaris harder than
other OSes.

Expect lots more info on performance config for Solaris from me & Robert in
the next few weeks.

--
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco

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

Предыдущее
От: "Luke Lonergan"
Дата:
Сообщение: Re: Better index stategy for many fields with few
Следующее
От: "Jim Nasby"
Дата:
Сообщение: Re: Better index stategy for many fields with few values