Re: BUG #13307: Increasing space

From: Julian Schauder <julian(dot)schauder(at)credativ(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13307: Increasing space
Date: 2015-05-19 09:20:51
Message-ID: 555B0073.5000000@credativ.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 18.05.2015 07:23, s(dot)rama194(at)gmail(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 13307
> Logged by: Rama Shankar
> Email address: s(dot)rama194(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message IPN Bala GSS TVL 2015-05-19 14:57:31 Error with Database name
Previous Message David G. Johnston 2015-05-18 16:19:46 Re: BUG #13310: Please update docs of regexp_replace()