Re: Re: [SQL] improve performance - Mailing list pgsql-interfaces

From Hannu Krosing
Subject Re: Re: [SQL] improve performance
Date
Msg-id 3A631A7C.922EAEAC@tm.ee
Whole thread Raw
In response to improve performance  (Alexaki Sofia <alexaki@ics.forth.gr>)
Responses Re: Re: [SQL] improve performance  (Jan Wieck <janwieck@Yahoo.com>)
List pgsql-interfaces
Tom Lane wrote:
> 
> 
> I've heard lots of people want to increase BLCKSZ, but you're the first
> one who ever wanted to reduce it.  You sure you want to do this?  It's
> going to make the maximum row length uncomfortably short.

And it may even not work, as some system tables (that are also affected
by this) 
may need the full 8k. AFAIK it has never been tested with BLCKSZ < 8k

----------
Hannu


pgsql-interfaces by date:

Previous
From: Patrick Welche
Date:
Subject: Re: outer join in PostgreSql
Next
From: "Jim Di Crescenzo"
Date:
Subject: PQexec