Re: Why is restored database faster?

Поиск
Список
Период
Сортировка
От Shridhar Daithankar
Тема Re: Why is restored database faster?
Дата
Msg-id 3FDFF82A.2070201@persistent.co.in
обсуждение исходный текст
Ответ на Re: Why is restored database faster?  (Neil Conway <neilc@samurai.com>)
Список pgsql-performance
Neil Conway wrote:

>>How can I get the original server to perform as well as the new one?

Well, you have the answer. Dump the database, stop postmaster and restore it.
That should be faster than original one.

>
> (BTW, "SELECT count(*) FROM table" isn't a particularly good DBMS
> performance indication...)

Particularly in case of postgresql..:-)

  Shridhar

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

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: Why is restored database faster?
Следующее
От: Dennis Bjorklund
Дата:
Сообщение: Re: Why is restored database faster?