Re: Arrays and Performance - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: Arrays and Performance
Date
Msg-id 20060106161749.GI3902@pervasive.com
Whole thread Raw
In response to Arrays and Performance  (s_philip@ira.uka.de)
Responses Re: Arrays and Performance  (Marc Philipp <mail@marcphilipp.de>)
List pgsql-general
On Fri, Jan 06, 2006 at 09:43:53AM +0100, s_philip@ira.uka.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@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-general by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: Adding another primary key to a populated table
Next
From: MARCELO_LIMA/Blnet@BLNET.COM
Date:
Subject: Autocommit in Fedora 3