On Tue, Jan 31, 2012 at 2:36 PM, Marc Mamin m.ma...@intershop.de wrote:
But this raises an interesting question on how/where does Postgres store
statistics on functional indexes.
in pg_statistics there are information on the column content, but I couldn't
find stats on the function result
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
] On Behalf Of Josh Berkus
Sent: Dienstag, 31. Januar 2012 19:44
To: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] How to remove a table statistics ?
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