<lokendra.di...@rmsi.com> wrote: > PostgreSQL version: 8.4.11 > 1.When I am taking bacup and restore two three times when databse > size automatically incresed please descrive the solution. > > 2. I have created non cluster index on tables to increase query > performance at same time performance incresed but after one month > on same query on same database again query lost performance two > three time what is reson behind this. Everything you are describing sounds like the kind of bloat you get if you don't have autovacuum configured aggressively enough. To give people a little more to work with, please describe you hardware and show the results of running the query on this page: http://wiki.postgresql.org/wiki/Server_Configuration -Kevin
-- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
