[GENERAL] Fwd: Regarding pg_stat_statements

2015-03-13 Thread Sreerama Manoj
Hi, As we know that "pg_stat_statements" will monitor the queries after normalizing the queries(Removes the values present in query). I want to know is there a way to store those normalized values because I want to check the type of data(values) ,range of data that is being hit to the databas

[GENERAL] reload shared_preload_libraries

2015-03-25 Thread Sreerama Manoj
Is there a way to reload shared_preload_libraries with out restarting the server?? I tried alter system command in postgres 9.4 but I could not change it..

[GENERAL] Create Virtual Indexes on Postgres

2015-02-25 Thread Sreerama Manoj
Hi, I use Postgres 9.4 database.Now,I am optimizing the queries by using the results of "explain" and "explain analyze",Sometimes I am creating Indexes to optimize them. But, I was not successful sometimes as even I create Index to optimize them, the planner is not using them . So my question