On Aug 11, 5:54 pm, Detlef Rudolph <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
