| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Samplonius | 2001-01-15 16:37:23 | Re: improve performance |
| Previous Message | Tom Lane | 2001-01-15 15:27:59 | Re: [SQL] improve performance |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marcelo Bartsch | 2001-01-15 15:56:38 | How to display a unixtimestamp from a timestamp record? |
| Previous Message | Richard Huxton | 2001-01-15 15:29:58 | Re: Querying date interval |