Re: Decreasing BLKSZ

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Decreasing BLKSZ
Date: 2006-09-26 22:39:09
Message-ID: 4519AC0D.8060604@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Junaili Lie 2006-09-26 23:27:41 Re: slow i/o
Previous Message Bucky Jordan 2006-09-26 22:14:07 Re: Decreasing BLKSZ