Re: pg_restore new parameter request

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: pg_restore new parameter request
Дата
Msg-id CAKFQuwb4PxoWpdWv3BTTN0Q+P8wELuE3OGGZm9F0ZvAyDp_A8Q@mail.gmail.com
обсуждение исходный текст
Ответ на pg_restore new parameter request  ("Campbell, Lance" <lance@illinois.edu>)
Ответы Re: pg_restore new parameter request
Список pgsql-admin
On Mon, Nov 23, 2015 at 7:37 AM, Campbell, Lance <lance@illinois.edu> wrote:

Without the indexes the production system would run slower until they were applied but at least I would be up and running.



​At least until excessive sequential scanning overloads the I/O subsystem and you max out your processes, connections and/or timeouts...

I'd be curious to know if you've ever tried dropping all of your indexes and running your systems under somewhat realistic load levels.

David J.
 

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_restore new parameter request
Следующее
От: Jerry Sievers
Дата:
Сообщение: Re: pg_restore new parameter request