Re: Inserts or Updates - Mailing list pgsql-performance

From Frank Lanitz
Subject Re: Inserts or Updates
Date
Msg-id 4F33CA03.3080106@frank.uvena.de
Whole thread Raw
In response to Re: Inserts or Updates  (Ofer Israeli <oferi@checkpoint.com>)
Responses Re: Inserts or Updates
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Vik Reykja
Date:
Subject: Re: Inserts or Updates
Next
From: Jeff Janes
Date:
Subject: Re: random_page_cost = 2.0 on Heroku Postgres