Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 08B9615095D0 for ; Sun, 12 Feb 2012 14:29:30 -0400 (AST) Received: from [2001:4d88:1ffc:463::1] (helo=uvena.de) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RweB0-00023C-6N for pgsql-performance@postgresql.org; Sun, 12 Feb 2012 18:29:30 +0000 Received: from [192.168.0.103] (178-24-54-50-dynip.superkabel.de [178.24.54.50]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by uvena.de (Postfix) with ESMTPSA id 565C7254011; Sun, 12 Feb 2012 18:29:14 +0000 (UTC) Message-ID: <4F3804F9.4080607@frank.uvena.de> Date: Sun, 12 Feb 2012 19:29:13 +0100 From: Frank Lanitz User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:9.0) Gecko/20111229 Thunderbird/9.0 MIME-Version: 1.0 To: Ofer Israeli CC: "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> <4F33CA03.3080106@frank.uvena.de> <217DDBC2BB1E394CA9E7446337CBDEF20102C056C1C3@il-ex01.ad.checkpoint.com> In-Reply-To: <217DDBC2BB1E394CA9E7446337CBDEF20102C056C1C3@il-ex01.ad.checkpoint.com> X-Enigmail-Version: 1.3.5 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigA505CFD87D4C0B2C518053FA" X-Host-Lookup-Failed: Reverse DNS lookup failed for 2001:4d88:1ffc:463::1 (failed) X-Pg-Spam-Score: -1.1 (-) X-Archive-Number: 201202/106 X-Sequence-Number: 46278 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigA505CFD87D4C0B2C518053FA Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Am 12.02.2012 11:48, schrieb Ofer Israeli: > Frank Lanitz wrote: >>> 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 >>>>>=20 >>>>> 23 columns 12 indexes on fields of the following types:=20 >>>>> INTEGER - 3 TIMESTAMP - 1 VARCHAR - 6 UUID - 2 >>>=20 >>> 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. > We're not always updating all of the columns, but the reason for > consolidating all the columns into one table is for UI purposes - in > the past, they had done benchmarks and found the JOINs to be > extremely slow and so all data was consolidated into one table. Ah... I see. Maybe you can check whether all of the data are really needed to fetch with one select but this might end up in tooo much guessing and based on your feedback you already did this step. Cheers, Frank --------------enigA505CFD87D4C0B2C518053FA Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQIcBAEBAgAGBQJPOAT5AAoJEMTGKa65g3T9BFsQAJiDZ3r1KnD9W4YtZigVgTfe mcEDpQUS5DSBh8TsdoSR/NDUKMnogAXfs4atfcs1+ci3cz1DQdQxxhtKhYecjZCk Gc8SiDwc0fcAaIxc6ZNHqusGLZ0tCP6HYRi4DgFUynpimSk3GDuFSLVdcjJHmnYb O04u2ejpAnDHhetjtizxy6+AuyYY2DGK6Fgpz0KeCd6hAaqLKDa8RnXH2cX1FORT KmgY0PsI6Emi6Jg7GsdN3TotJ7pka8mbh2t71jqaBrCONcPH4aEVTXJXqNH1qkv3 o2EZ/F5vOMySvqOFsfGj+1G+W5vS3ktff2We9pHKS0qo51X4kMv//Xgj/2q0HMgb EpFZF8w1yY3HRlZcmH8z/20WOwfXrt+XyvC4vWasKJunoyJXrVTM4SFUj9x3f0Sy 0tXaobvO8wSXed4fhGMq29FlL0EqLVrOUYW7gpILwG+2X5qN0pJumWdyNe2iYmJC p6YMExC+uAlRLk3JnqTGMopG+J1vYfy0mRPiaIFpL708WDr+qrr/Y5Mh/btAE8LC AJdqDnlvnMGwFMn/2Npy5gnRhlgflB8ROP7bD+AdF6XrwHgBVmBXtWW2NzAIVSCh WBUsJWvHrslWCGamguCGy4EXI0OTp69YnPBvNdPVdYlr7EYCpzRWPFqHkzjvq0XL FC6c05tlsS1U6PDKBzCU =kypJ -----END PGP SIGNATURE----- --------------enigA505CFD87D4C0B2C518053FA--