Re: Database restore speed

Поиск
Список
Период
Сортировка
Искать
От
Luke Lonergan
Тема
Re: Database restore speed
Дата
Msg-id
BFB61273.14EE0%llonergan@greenplum.com
Ответ на
Список
Дерево обсуждения
Database restore speed "Steve Oualline" <soualline@stbernard.com>
Micahel,

On 12/2/05 1:46 PM, "Michael Stone"  wrote:

> Not necessarily; you may be betting that it's more *efficient* to do the
> parsing on a bunch of lightly loaded clients than your server. Even if
> you're using the same code this may be a big win.

If it were possible in light of the issues on client parse / convert, then
we should analyze whether it's a performance win.

In the restore case, where we've got a dedicated server with a dedicated
client machine, I don't see why there would be a speed benefit from running
the same parse / convert code on the client versus running it on the server.
Imagine a pipeline where there is a bottleneck, moving the bottleneck to a
different machine doesn't make it less of a bottleneck.

- Luke


В списке pgsql-performance по дате отправления
От: Michael Riess
Дата:
Сообщение: 15,000 tables - next step
От: Francisco Reyes
Дата:
Сообщение: Small table or partial index?
FAQ