Re: [HACKERS] interesting observatation regarding views and V7.0

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.