the first thing you should probably do is run an 'analyze' on one of these
tables and then run again the delete statement. if there are no stats for
these tables, it's normal not to have very good plans.
On Tue, Oct 16, 2012 at 11:24 AM, Sylvain CAILLET wrote:
> Hi Craig,
>
> Here are the outpu
can you post all the configuration parameters related to the I/O activity?
plus, could you post some stats from 'iostat' when this is happening?
thx
On Thu, Mar 29, 2012 at 9:02 PM, Campbell, Lance wrote:
> I forgot to mention that the slowdown in particular for other
> applications is when the
you might also consider increasing the wal_buffers value if it's still the
default (64KB)
BR
yup there is. the parameter checkpoint_segments does not require a restart
of the server, just a reload :)
On Fri, Feb 24, 2012 at 12:54 AM, Alessandro Gagliardi
wrote:
> On Thu, Feb 23, 2012 at 1:11 PM, Peter van Hardenberg wrote:
>
>> My hunch is still that your issue is lock contention.
>>
>>
