Re: Inserts or Updates

From: Frank Lanitz <frank(at)frank(dot)uvena(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Inserts or Updates
Date: 2012-02-09 13:28:35
Message-ID: 4F33CA03.3080106@frank.uvena.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2012-02-09 15:32:19 Re: random_page_cost = 2.0 on Heroku Postgres
Previous Message Vik Reykja 2012-02-09 10:09:25 Re: Inserts or Updates