Hello, lets say I have such theoretical situation: big database with a lot of tables and fields, and a lot of users with are using different queries. And the worse - I am that data base admin ;] which has to add or remove indexes on table columns. As I dont know what queries are coming (users are writing it by them self) I dont know which columns should have indexes. My question - is here any statistics Postgres can collect to help answer my question. Basically I need most often "where" statements of queries (also JOINs etc). Is here something what can help in such situation? -- Lukas www.nsoft.lt -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
