BUG #7519: incresed data base size and query performance lost

Поиск
Список
Период
Сортировка
От lokendra.dixit@rmsi.com
Тема BUG #7519: incresed data base size and query performance lost
Дата
Msg-id E1T8s6E-0006ZB-2K@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #7519: incresed data base size and query performance lost  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged on the website:

Bug reference:      7519
Logged by:          Lokendra Dixit
Email address:      lokendra.dixit@rmsi.com
PostgreSQL version: 8.4.11
Operating system:   Windows 7
Description:        =


Hi,
    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.
any suggestion ?

With regards
Lokendra

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #6704: ALTER EXTENSION postgis SET SCHEMA leaves dangling relations
Следующее
От: Murray Cumming
Дата:
Сообщение: Re: BUG #7514: postgres -k no longer works with spaces in the path