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

From: lokendra(dot)dixit(at)rmsi(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7519: incresed data base size and query performance lost
Date: 2012-09-04 12:19:22
Message-ID: E1T8s6E-0006ZB-2K@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7519
Logged by: Lokendra Dixit
Email address: lokendra(dot)dixit(at)rmsi(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2012-09-04 14:31:41 Re: BUG #7514: postgres -k no longer works with spaces in the path
Previous Message TAKATSUKA Haruka 2012-09-04 09:13:24 Re: BUG #7518: "FORMAT" in the "COPY" command