Re: Rapidly decaying performance repopulating a large table - Mailing list pgsql-general

From Tom Lane
Subject Re: Rapidly decaying performance repopulating a large table
Date
Msg-id 3109.1208932182@sss.pgh.pa.us
Whole thread Raw
In response to Re: Rapidly decaying performance repopulating a large table  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-general
Greg Smith <gsmith@gregsmith.com> writes:
> ...This is a bit out of my area, but after reading the rest of this thread I
> wonder whether raising the default_statistics_target parameter a bit might
> reduce the instances of bad plans showing up.

On the evidence so far, it doesn't seem that David's problem has
anything to do with bad plans --- I suspected that at first, but the
theory's been shot down.  I'm now thinking it's an I/O bottleneck in
some form ...

            regards, tom lane

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: Rapidly decaying performance repopulating a large table
Next
From: Michael Fuhr
Date:
Subject: Re: Postgres Encoding conversion problem