Обсуждение: 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