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 [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
