| From: | "Lukas" <lukas(at)fmf(dot)vgtu(dot)lt> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Stats |
| Date: | 2012-04-08 18:30:58 |
| Message-ID: | 2d4195f7f284079940e386844b37c31a.squirrel@fmf.vtu.lt |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2012-04-08 20:36:02 | Re: Stats |
| Previous Message | Josh Kupershmidt | 2012-04-07 18:31:16 | Re: get/set priority of PostgreSQL backends |