RE: [HACKERS] Open 6.5 items

> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Tuesday, June 01, 1999 2:14 AM
> To: Hiroshi Inoue; t-ishii(at)sra(dot)co(dot)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(at)tpf(dot)co(dot)jp