| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Adam Ruth <aruth(at)intercation(dot)com> |
| Cc: | "Brett Maton" <brett(dot)maton(at)itaccounting(dot)co(dot)uk>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Column Sizes |
| Date: | 2003-11-13 17:24:15 |
| Message-ID: | 27881.1068744255@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Adam Ruth <aruth(at)intercation(dot)com> writes:
> ... It does seem that the large
> object functions do split the data into 2k chunks, but it would
> probably be a simple thing to check the source to determine if this is
> always true. But it could always change in a future version.
My recollection is that the large object chunk size is defined as BLCKSZ/4,
so you'd get 2K with the default 8K block size, but it could also be
4K or 8K with the other likely choices for block size.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Uwe C. Schroeder | 2003-11-13 17:42:35 | Re: Curious about exclusive table locks |
| Previous Message | Adam Ruth | 2003-11-13 17:00:41 | Re: Column Sizes |