At 11:04 AM 2/23/00 -0600, Ed Loehr wrote:
>Don Baccus wrote:
>>
>> The creation of column aliases for tables referenced by views causes
>> the rule created on the underlying virtual table to be in some cases
>> considerably longer than the corresponding rule in V6.5.
>>
>> ...In my case, I recompiled PG with a blocksize of 16KB...
>>
>> ...This "fixed" my problem with views, too.
>
>Thanks for this info, Don. Would you mind posting your patch, simple
>as it may be?
That was it, I just recompiled PG with a blocksize of 16KB, i.e.
edited src/include/config.h.in's BLCKSZ definition, ran configure,
and did a gmake all/gmake install.
As I mentioned, I had other reasons for wanting to run with a 16KB
blocksize while waiting for TOASTed large text (and other) types,
so it's no biggie for me.
Others might find this change a lot more annoying.
- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.