> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Tuesday, June 01, 1999 2:14 AM
> To: Hiroshi Inoue; t-ishii@sra.co.jp
> Cc: PostgreSQL-development
> Subject: Re: [HACKERS] Open 6.5 items
>
>
> I wrote:
> >>> I suspect that huge INIT_TABLE_SIZE prevented dynamic expanding the
> >>> hash tables and seems there's something wrong in the routines
> >>> responsible for that.
>
> > OK, as the last guy to touch dynahash.c I suppose this is my
> > bailiwick... I will look into it today.
>
> It's amazing how much easier it is to see a bug when you know it must be
> there ;-).
>
[snip]
>
> I have committed a fix in dynahash.c. Hiroshi and Tatsuo, would you
> please grab latest sources and see whether the problems you are
> observing are fixed?
>
It works fine.
The number of xidHash entry exceeded 600 but spinlock error didn't
occur.
However,when I did vacuum while testing I got the following error
message.ERROR: Child itemid marked as unused
TransactionId-s of tuples in update chain may be out of order.
Thanks.
Hiroshi Inoue
Inoue@tpf.co.jp