Re: pg_restore new parameter request

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "Campbell, Lance" <lance(at)illinois(dot)edu>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_restore new parameter request
Date: 2015-11-23 14:55:06
Message-ID: CAKFQuwb4PxoWpdWv3BTTN0Q+P8wELuE3OGGZm9F0ZvAyDp_A8Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Nov 23, 2015 at 7:37 AM, Campbell, Lance <lance(at)illinois(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jerry Sievers 2015-11-23 17:37:45 Re: pg_restore new parameter request
Previous Message Tom Lane 2015-11-23 14:50:13 Re: pg_restore new parameter request