Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id 1A1611A5B07D
	for <pgsql-performance@postgresql.org>;
	Thu,  9 Feb 2012 09:27:55 -0400 (AST)
Received: from [2001:4d88:1ffc:463::1] (helo=uvena.de)
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <frank@frank.uvena.de>) id 1RvU2U-0003uH-KN
	for pgsql-performance@postgresql.org; Thu, 09 Feb 2012 13:27:55 +0000
Received: from [141.35.39.175] (c319808.zuv.uni-jena.de [141.35.39.175])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by uvena.de (Postfix) with ESMTPSA id DF04F254011
	for <pgsql-performance@postgresql.org>;
	Thu,  9 Feb 2012 13:27:39 +0000 (UTC)
Message-ID: <4F33CA03.3080106@frank.uvena.de>
Date: Thu, 09 Feb 2012 14:28:35 +0100
From: Frank Lanitz <frank@frank.uvena.de>
User-Agent: Mozilla/5.0 (Windows NT 6.1;
	rv:10.0) Gecko/20120129 Thunderbird/10.0
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: Inserts or Updates
References: 
 <217DDBC2BB1E394CA9E7446337CBDEF20102C056BD4F@il-ex01.ad.checkpoint.com>
	<4F31397A.5090304@squeakycode.net>
	<217DDBC2BB1E394CA9E7446337CBDEF20102C056BE6F@il-ex01.ad.checkpoint.com>
In-Reply-To: 
 <217DDBC2BB1E394CA9E7446337CBDEF20102C056BE6F@il-ex01.ad.checkpoint.com>
X-Enigmail-Version: 1.3.5
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Host-Lookup-Failed: Reverse DNS lookup failed for 2001:4d88:1ffc:463::1
	(failed)
X-Pg-Spam-Score: 0.8 (/)
X-Archive-Number: 201202/74
X-Sequence-Number: 46246

Am 07.02.2012 18:40, schrieb Ofer Israeli:
> Table 1:
> 46 columns
> 23 indexes on fields of the following types:
> INTEGER - 7
> TIMESTAMP - 2
> VARCHAR - 12
> UUID - 2
> 
> 23 columns
> 12 indexes on fields of the following types:
> INTEGER - 3
> TIMESTAMP - 1
> VARCHAR - 6
> UUID - 2

Are you regularly updating all columns? If not, maybe a good idea to
split the tables so highly updated columns don't effect complete line.

cheers,
Frank