Re: Decreasing BLKSZ - Mailing list pgsql-performance

From Markus Schaber
Subject Re: Decreasing BLKSZ
Date
Msg-id 4519AC0D.8060604@logix-tt.com
Whole thread Raw
In response to Re: Decreasing BLKSZ  ("Marc Morin" <marc@sandvine.com>)
List pgsql-performance
Hi, Marc,

Marc Morin wrote:

>> I wonder whether there is a way to use table partitioning to
>> make the insert pattern more localized?  We'd need to know a
>> lot more about your insertion patterns to guess how, though.
>
> We're doing partitioning as well.....

And is constraint exclusion set up properly, and have you verified that
it works?

HTH,
Markus

pgsql-performance by date:

Previous
From: "Bucky Jordan"
Date:
Subject: Re: Decreasing BLKSZ
Next
From: "Junaili Lie"
Date:
Subject: Re: slow i/o