Gregory S. Williamson wrote:
> On Informix however it is blindingly fast, and can also be instantly
> conjured with the dbaccess tool (Info/Table/Status). They might be
> stashing this count somewhere, but it is not available when the table
> is locked, as during a load. However they do it, performance does not
> seem to suffer, and having this rapidly available is certainly nice.
> Especially when people are used to it.
>
Informix locks rows during modification so they don't have the MVCC
visibility problem we have (some rows are visible to only some
backends).
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073