Thread: BUG #13307: Increasing space
The following bug has been logged on the website: Bug reference: 13307 Logged by: Rama Shankar Email address: s.rama194@gmail.com PostgreSQL version: Unsupported/Unknown Operating system: Ubantu Description: In my db one table is there having around 20k rows, It is occupying space very fast, per second 1 MB, Please tell me solution for that one.
On 18.05.2015 07:23, s.rama194@gmail.com wrote: > The following bug has been logged on the website: > > Bug reference: 13307 > Logged by: Rama Shankar > Email address: s.rama194@gmail.com > PostgreSQL version: Unsupported/Unknown > Operating system: Ubantu > Description: > > In my db one table is there having around 20k rows, It is occupying space > very fast, per second 1 MB, Please tell me solution for that one. > > Hello, We need more information on that one. Is it 20k rows at rest or is there traffic on the table? What version of PostgreSQL are you using? How do you determine the DB-Size? My first guess would be bloat, caused by high frequent updates and a rather lazy autovacuum. Regards, Julian
On Mon, May 18, 2015 at 3:23 PM, <s.rama194@gmail.com> wrote: > The following bug has been logged on the website: > > Bug reference: 13307 > Logged by: Rama Shankar > Email address: s.rama194@gmail.com > PostgreSQL version: Unsupported/Unknown > Operating system: Ubantu > Description: > > In my db one table is there having around 20k rows, It is occupying space > very fast, per second 1 MB, Please tell me solution for that one. > To start with, this is not a BUG. Without any details, I think, this is something to do with your application behaviour. Obviously, the data load or data changes would make the table grow in size. How fast or slow a table is growing depends on volume of transactions and the size of the data being changed/loaded. Regards, Venkata Balaji N Fujitsu Australia