Re: PostgreSQL Gotchas --- count()

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