Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_restore new parameter request - Mailing list pgsql-admin

From David G. Johnston
Subject Re: pg_restore new parameter request
Date
Msg-id CAKFQuwb4PxoWpdWv3BTTN0Q+P8wELuE3OGGZm9F0ZvAyDp_A8Q@mail.gmail.com
Whole thread Raw
In response to pg_restore new parameter request  ("Campbell, Lance" <lance@illinois.edu>)
Responses Re: pg_restore new parameter request
List pgsql-admin
Tree view
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_restore new parameter request
Next
From: Jerry Sievers
Date:
Subject: Re: pg_restore new parameter request