Re: Slow Vacuum was: vacuum output question

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Slow Vacuum was: vacuum output question
Дата
Msg-id dcc563d10901061305q419bb291uf7d4b84b642adf6b@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Slow Vacuum was: vacuum output question  ("Dan Armbrust" <daniel.armbrust.list@gmail.com>)
Ответы Re: Slow Vacuum was: vacuum output question
Список pgsql-general
On Tue, Jan 6, 2009 at 1:39 PM, Dan Armbrust
<daniel.armbrust.list@gmail.com> wrote:
> Here is an interesting new datapoint.
>
> Modern Ubuntu distro - PostgreSQL 8.1.  SATA drive.  No Raid.  Cannot
> reproduce slow vacuum performance - vacuums take less than a second
> for the whole database.
>
> Reinstall OS - Fedora Core 6 - PostgreSQL 8.1.  Push data through
> PostgreSQL for a couple hours (same as above) and now vacuum reports
> this:

Are you pushing the same amount of data through the ubuntu server?  if
not, then the comparison is invalid, if so, then yeah, there's some
kind of difference between the platforms.

Note that Fedora Core 6 is quite old compared to ubuntu 8.04 or 8.10.
Also it's more likely to be installed on older and / or slower
equipment.

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

Предыдущее
От: "Rob Richardson"
Дата:
Сообщение: Generic provider for .Net
Следующее
От: "Dan Armbrust"
Дата:
Сообщение: Re: Slow Vacuum was: vacuum output question