Re: Arrays and Performance

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: s_philip(at)ira(dot)uka(dot)de
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Arrays and Performance
Date: 2006-01-06 16:17:49
Message-ID: 20060106161749.GI3902@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jan 06, 2006 at 09:43:53AM +0100, s_philip(at)ira(dot)uka(dot)de wrote:
> What we have been observing in the last few weeks is, that the
> overall database size is increasing rapidly due to this table and
> vacuum processes seem to deadlock with other processes querying data
> from this table.

Are you seeing deadlock errors? How often are you vacuuming?
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Meyer 2006-01-06 16:37:58 Re: constraint on type object in oracle
Previous Message Jaime Casanova 2006-01-06 16:13:18 Re: Adding another primary key to a populated table