Re: BUG #13307: Increasing space

Поиск
Список
Период
Сортировка
От Julian Schauder
Тема Re: BUG #13307: Increasing space
Дата
Msg-id 555B0073.5000000@credativ.de
обсуждение исходный текст
Ответ на BUG #13307: Increasing space  (s.rama194@gmail.com)
Список pgsql-bugs
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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: IPN Bala GSS TVL
Дата:
Сообщение: Error with Database name
Следующее
От: Christopher Browne
Дата:
Сообщение: Re: Error with Database name