Add timing info for v6.5 on my linux box.

Generated from install.sgml and installation.sgml.

   in CommitTransaction().
2. Changes in GetSnapshotData().

vc_scanheap().

   transactions will not assume that MyProc transaction was committed
   before snapshot calculations. With old MyProc->xid assignment
   (in xact.c:StartTransaction()) there was ability to see the same
   row twice (I used gdb for this)!...
2. Assignments of InvalidTransactionId to MyProc->xid and MyProc->xmin
   are moved from xact.c:CommitTransaction() to
   xact.c:RecordTransactionCommit() - this invalidation must be done
   before releasing transaction locks or bad (too high) XmaxRecent value
   might be used by vacuum ("ERROR:  Child itemid marked as unused"
   reported by "Hiroshi Inoue" <Inoue@tpf.co.jp>; once again, gdb
   allowed me reproduce this error).

Clean out duplicate stuff in odbc.sgml resulting from a faulty patch.

because it ignored the LOs themselves but failed to ignore the indexes
on the LOs.  How long has this been broken??

all the expected keys (it was returning uninitialized memory).

libpq ...

Jan

198.68.123.0/27 the same when indexing them.

D'Arcy

Multiple intros cause trouble since they have some section elements
 (e.g. "y2k.sgml") in common leading to duplicate labels.
Include emacs formatting hints in the intro*.sgml sources.

{
    Oid             relId;
    Oid             dbId;
    union
    {
        BlockNumber     blkno;
        TransactionId   xid;
    }               objId;
>
> Added:
>    /*
>     * offnum should be part of objId.tupleId above, but would increase
>     * sizeof(LOCKTAG) and so moved here; currently used by userlocks only.
>     */
>    OffsetNumber    offnum;
    uint16          lockmethod;     /* needed by userlocks */
} LOCKTAG;

gmake clean required...
User locks are ready for 6.5 release...

Vince.

later.

Vince.

all fields that should be set).  Add a MoveToFront primitive to speed up
one of the hotspots in SearchSysCache.

memory context at transaction commit or abort.

in an index doesn't have a restriction selectivity estimator.

right circumstances it would leave old and new bucket headers pointing to
the same list of records.

(no sense to hold it) or we'll be out of lock entries.
Great thanks to Hiroshi Inoue.

(Curious that gcc doesn't complain about this code...).

is poor coding style.  I agree.

file headers, to conform to established Postgres coding style and avoid
warnings from gcc.

after checking for presence of C++ compiler.  Odd we hadn't seen any
reports of problems before...

when used with egcs --- now it does.

2. Get rid of locking when updating statistics in vacuum.
3. Use QuerySnapshot in COPY TO and call SetQuerySnashot
   in main tcop loop before FETCH and COPY TO.

few percent speedup in INSERT...

redundant) SearchSysCache searches per table column in an INSERT, which
accounted for a good percentage of the CPU time for INSERT ... VALUES().
Now it only does two searches in the typical case.

cache access routines.

through MAXBACKENDS array entries used to be fine when MAXBACKENDS = 64.
It's not so cool with MAXBACKENDS = 1024 (or more!), especially not in a
frequently-used routine like SIDelExpiredDataEntries.  Repair by making
procState array size be the soft MaxBackends limit rather than the hard
limit, and by converting SIGetProcStateLimit() to a macro.