Re: [BUGS] BUG #7519: incresed data base size and query performance lost

2012-09-05 Thread Kevin Grittner
"Lokendra Dixit" wrote: > RAM: 2 GB You do realize how small that is for a database server, I hope. Many people are walking around with cell phones in their pockets that have a lot more. This could contribute to severe slowdown with even minimal growth of the database, as cached access will

Re: [BUGS] BUG #7519: incresed data base size and query performance lost

2012-09-04 Thread Kevin Grittner
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 on

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

2012-09-04 Thread lokendra . dixit
The following bug has been logged on the website: Bug reference: 7519 Logged by: Lokendra Dixit Email address: lokendra.di...@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