Re: [HACKERS] postgresql-v6.5beta2.tar.gz ...

Hiroshi Inoue wrote:
>
> >
> > Hiroshi, please run your test. You'll get NOTICEs instead of ERRORs.
>
> I have run my test and got the following NOTICEs.
>
> NOTICE: Child itemid in update-chain marked as unused - can't
> continue vc_rpfheap

I'm still getting troubles when running your test due to

1. bug in cache invalidation code: when we invalidate relcache
we forget to free MdfdVec in md.c!

Vacuum invalidates a relation tuple in pg_class and concurrent
xactions invalidate corresponding relcache entry, but don't
free MdfdVec and so allocate new one for the same relation
more and more. Each MdfdVed requires own fd.c:Vfd entry -> below

2. fd.c:pg_nofile()->sysconf(_SC_OPEN_MAX) returns in FreeBSD
near total number of files that can be opened in system
(by _all_ users/procs). With total number of opened files
~ 2000 I can run your test with 10-20 simultaneous
xactions for very short time, -:)

Should we limit fd.c:no_files to ~ 256?
This is port-specific, of course...

Vadim
P.S. Hiroshi test I run:

10-20 psql < file with 10000 xactions:

BEGIN;
UPDATE single row in table;
END;

A script run "vacuum table" each rand(10) + 1 sec.