On 1/31/12 3:50 AM, Marc Mamin wrote: > 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) You can, but it won't do any good; autovaccum will replace them. It would be better to fix the actual query plan issue. If you can, post the query plans with and without statistics (EXPLAIN ANALYZE, please) here. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
