Hello,
I have a weird table, upon with the queries are much faster when no statics were collected.
Is there a way to delete statistics information for a table ?
I've tried ALTER.. set STATISTICS 0 and then run ANALYZE, but it seems that old statistics are kept this way.
Can I delete entries directly in pg_statistic ?
(Postgresql 9.1)
short backgroud Info:
One of the table index is a GIN on a tsvector returning function, which is very costy.
once analyzed, the query planner often ignore this index in favour of other one, hence triggering this function too often.
I'll fix that model, but am first looking for a quick way to restore performance on our production servers.
best regards,
Marc Mamin