Skip site navigation (1) Skip section navigation (2)

Re: Table UPDATE is too slow

From: "Marinos J(dot) Yannikos" <mjy(at)geizhals(dot)at>
To: Ron St-Pierre <rstpierre(at)syscor(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Table UPDATE is too slow
Date: 2004-09-05 23:28:04
Message-ID: 413BA104.1040508@geizhals.at (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
Ron St-Pierre wrote:

> We have a web based application with data that is updated daily. The 
> biggest bottleneck occurs when we try to update
> one of the tables. This table contains 58,000 rows and 62 columns, and 
> EVERY column is indexed.

Have you thought of / tried using 2 separate databases or tables and 
switching between them? Since you seem to be updating all the values, it 
might be a lot faster to re-create the table from scratch without 
indexes and add those later (maybe followed by a VACUUM ANALYZE) ...

That said, I'm not entirely sure how well postgres' client libraries can 
deal with tables being renamed while in use, perhaps someone can shed 
some light on this.

Regards,
  Marinos
-- 
Dipl.-Ing. Marinos Yannikos, CEO
Preisvergleich Internet Services AG
Obere Donaustraße 63/2, A-1020 Wien
Tel./Fax: (+431) 5811609-52/-55

In response to

Responses

pgsql-performance by date

Next:From: Martin FosterDate: 2004-09-06 01:15:24
Subject: Tanking a server with shared memory
Previous:From: Pierre-Frédéric CaillaudDate: 2004-09-05 18:03:04
Subject: Re: fsync vs open_sync

pgsql-general by date

Next:From: Rory Campbell-LangeDate: 2004-09-05 23:35:05
Subject: Schema and Group permissions question
Previous:From: Carlos CorreiaDate: 2004-09-05 23:02:24
Subject: Confused with db client encoding

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group