On Aug 11, 5:54 pm, Detlef Rudolph <ru(dot)(dot)(dot)(at)gmx(dot)de> wrote:
> Hello Group,
>
> I've tried the VACUUM ANALYSE, that doesn't help
> much, but VACUUM FULL improves Performance down
> from about 40 secs to 8. I think in future I would
> use the reltuples value from pg_class for the table.
>
> Thanks a lot for your answers and a good Sunday,
> Det
just do not forget, that reltuples is count and updated in pg_class
only during the vacuuming or analyzing of a table... so the value is
only an APPROXIMATE....
-- Valentine