Why is restored database faster?

Поиск
Список
Период
Сортировка
От David Shadovitz
Тема Why is restored database faster?
Дата
Msg-id 01C3C415.93ADBCE0.david@shadovitz.com
обсуждение исходный текст
Ответы Re: Why is restored database faster?
Re: Why is restored database faster?
Список pgsql-performance
I backed up my database using pg_dump, and then restored it onto a different
server using psql.  I see that the query "SELECT COUNT(*) FROM myTable"
executes immediately on the new server but takes several seconds on the old
one.  (The servers are identical.)

What could account for this difference?  Clustering?  How can I get the
original server to perform as well as the new one?

Thanks.
-David

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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Nested loop performance
Следующее
От: David Shadovitz
Дата:
Сообщение: Re: Why is VACUUM ANALYZE so slow?