Re: PostgreSQL Arrays and Performance

From: Marc Philipp <mail(at)marcphilipp(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL Arrays and Performance
Date: 2006-01-08 09:22:22
Message-ID: 1136712142.9076.22.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> This sounds like it has more to do with inadequate freespace map
> settings than use of arrays. Every update creates a dead tuple, and
> if
> it is large (because the array is large) and leaked (because you have
> no
> room in your freespace map), that would explain a rapidly increasing
> database size.

Can you tell me more about free-space map settings? What exactly is the
free-space map? The information in the documentation is not very
helpful. How can dead tuples leak?

Regards, Marc Philipp

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc Philipp 2006-01-08 09:26:32 Re: PostgreSQL Arrays and Performance
Previous Message Marc Philipp 2006-01-08 09:03:52 Re: Arrays and Performance