Skip site navigation (1) Skip section navigation (2)

Re: Re: [SQL] improve performance

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Alexaki Sofia <alexaki(at)ics(dot)forth(dot)gr>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-sql(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Re: [SQL] improve performance
Date: 2001-01-15 15:42:52
Message-ID: 3A631A7C.922EAEAC@tm.ee (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-sql
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

In response to

Responses

pgsql-interfaces by date

Next:From: Tom SamploniusDate: 2001-01-15 16:37:23
Subject: Re: improve performance
Previous:From: Tom LaneDate: 2001-01-15 15:27:59
Subject: Re: [SQL] improve performance

pgsql-sql by date

Next:From: Marcelo BartschDate: 2001-01-15 15:56:38
Subject: How to display a unixtimestamp from a timestamp record?
Previous:From: Richard HuxtonDate: 2001-01-15 15:29:58
Subject: Re: Querying date interval

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group