On Fri, Feb 1, 2013 at 2:40 PM, Pavan Deolasee wrote:
>
>
> On Fri, Feb 1, 2013 at 5:19 PM, Vlad Bailescu wrote:
>
>>
>>
>> Pavan, it seems there's a small issue with copy-paste and column
>> text-align. Table sizes are:
>>
>> 4136 kB 2448
On Fri, Feb 1, 2013 at 1:08 PM, Pavan Deolasee wrote:
>
>
> On Fri, Feb 1, 2013 at 3:24 PM, Vlad Bailescu wrote:
>
>>
>>
>> Stats show only 3 tables get frequently autovacuumed
>>
>> Table Name Tuples inserted Tuples updated Tuples deleted Tuples H
On Fri, Feb 1, 2013 at 11:01 AM, Pavan Deolasee wrote:
>
> Do you know for sure that its the master table that generating all the
> vacuum traffic ? What about the partition tables ? Do they get any
> updates/deletes ? It might be useful if you could turn autovacuum
> logging ON and see which tabl
Hi everyone,
We are experiencing a strange situation after upgrading our Postgres from
8.4 to 9.1 and our OS from Debian 6 to Ubuntu 12.04 LTS.
We have an application where we are collecting timestamp-based data. Since
a month of data goes over 30M rows (and growing each month), we decided to
par
