Reinoud van Leeuwen writes:
> > radius=# select count (radiuspk) from radius ;
> > count
> > --------
> > 398543
> > (1 row)
>
> This query takes about 3 seconds. But the query plan *already* knows the
> number of rows ("rows=398543").
This is only an estimate which is only updated by VACUUM. Presumably you
didn't add or remove any rows since your last VACUUM.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter