Search Postgresql Archives

Re: Table bloat in 8.3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Nov 13, 2008 at 1:09 PM, David Wilson <david.t.wilson@xxxxxxxxx> wrote:
> On Thu, Nov 13, 2008 at 2:03 PM,  <pgsql-general@xxxxxxx> wrote:
>> I have several tables that when I run VACUUM FULL on, they are under 200k,
>> but after a day of records getting added they grow to 10 to 20 megabytes.
>> They get new inserts and a small number of deletes and updates.
>>
>> seq_scan         | 32325
>> seq_tup_read     | 39428832
>> idx_scan         | 6590219
>> idx_tup_fetch    | 7299318
>> n_tup_ins        | 2879
>> n_tup_upd        | 6829984
>> n_tup_del        | 39
>> n_tup_hot_upd    | 420634
>> n_live_tup       | 2815
>> n_dead_tup       | 0
>
> Can you define "small number of deletes and updates"? The stats above
> would disagree with "small". Remember that every update creates a new,
> updated version of the row, which is where the increase is coming
> from.

And don't forget to look into failed inserts.  Those too create dead tuples.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux