From: Frank Lanitz <frank@frank.uvena.de>
To: Ofer Israeli <oferi@checkpoint.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Inserts or Updates
Date: Sun, 12 Feb 2012 19:29:13 +0100
Message-ID: <4F3804F9.4080607@frank.uvena.de> (raw)
In-Reply-To: <217DDBC2BB1E394CA9E7446337CBDEF20102C056C1C3@il-ex01.ad.checkpoint.com>
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>
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
>>>>>
>>>>> 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.
> 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
Attachments:
signature.asc (application/pgp-signature, 899B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: frank@frank.uvena.de, oferi@checkpoint.com
Subject: Re: Inserts or Updates
In-Reply-To: <4F3804F9.4080607@frank.uvena.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox