Re: [HACKERS] mdnblocks is an amazing time sink in huge relations - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] mdnblocks is an amazing time sink in huge relations
Date
Msg-id 199910121357.JAA02356@candle.pha.pa.us
Whole thread Raw
In response to mdnblocks is an amazing time sink in huge relations  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> It seems to me that mdnblocks should assume that all segments
> previously verified to be of length RELSEG_SIZE are still of that
> length, and only do an _mdnblocks() call on the last element of the
> segment chain.  That way the number of kernel interactions needed
> is a constant independent of the number of segments in the table.
> (This doesn't make truncation of the relation by a different backend
> any more or less dangerous; we're still hosed if we don't get a
> notification before we try to do something with the relation.
> I think that is fixed, and if it's not this doesn't make it worse.)
> 
> Any objections?

Sounds great.  Now that the segments work properly, it is time for some
optimization.  Vadim has complained about the lseek() from day-1. 
Someday he wants a shared catalog cache to prevent that from being
needed.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Features for next release
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Re: [INTERFACES] Next release is 7.0(?)