Re: Australian timezone configure option

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Chris Dunlop <chris(at)onthe(dot)net(dot)au>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Australian timezone configure option
Date: 2001-06-12 20:31:26
Message-ID: 200106122031.f5CKVQw13795@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

> > I checked and it caches a pointer to the struct, not the values
> > themselves, and we don't change the structure, just the secondary values
> > and not the key used by the bsearch.
>
> Now I'm going to object LOUDLY. You cannot convince me that the above
> is a good implementation --- it's a complete crock, and will break the
> instant someone looks at it sidewise.
>
> My inclination would actually be to rip out the cache entirely. bsearch
> in a table this size is not so expensive that we need to bypass it, nor
> is it apparent that we are going to see lots of successive lookups for
> the same keyword anyway. How long has that cache been in there, and
> what was the motivation for adding it to begin with?

OK, what do we do with this patch now? We have several Australians who
want it and most like it as GUC rather than a configure option. I don't
want to add lots more code because I think the GUC capability is simple
enough. I can remove the CACHE stuff but only if Thomas agrees.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Swan 2001-06-12 22:19:46 Re: BLOBs
Previous Message Limin Liu 2001-06-12 20:31:04 Re: Big5 contains '\'

Browse pgsql-patches by date

  From Date Subject
Next Message Marko Kreen 2001-06-12 20:47:28 Re: reset all update
Previous Message Tom Lane 2001-06-12 20:26:17 Re: Patch to include PAM support...