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

Re: Table UPDATE is too slow

From: Frank Wiles <frank(at)wiles(dot)org>
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-08-31 18:46:19
Message-ID: 20040831134619.4ead03b0.frank@wiles.org (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
On Tue, 31 Aug 2004 11:11:02 -0700
Ron St-Pierre <rstpierre(at)syscor(dot)com> wrote:


>    Postgres 7.4.3
>    debian stable
>    2 GB RAM
>    80 DB IDE drive (we can't change it)
>  
>    shared_buffers = 2048
>    sort_mem = 1024  
>    max_fsm_pages = 40000
>    checkpoint_segments = 5
>    random_page_cost = 3

  I agree with all of the follow ups that having indexes on every 
  column is a bad idea.  I would remove the indexes from the
  least searched upon 10-20 columns, as I'm sure this will help
  your performance.

  You mention that not having indexes on some of the columns because it
  "may slow down user queries".  I think you should investigate this and
  make sure they are necessary.  I've seen many an application, with far
  more rows than you're dealing with, only need 1 or 2 indexes, even
  when all (or most) columns could be searched. 

  Also, you should consider increasing your shared_buffers and probably
  your sort memory a touch as well. This will help your overall
  performance. 

 ---------------------------------
   Frank Wiles <frank(at)wiles(dot)org>
   http://www.wiles.org
 ---------------------------------


In response to

pgsql-performance by date

Next:From: Steinar H. GundersonDate: 2004-08-31 18:48:45
Subject: Re: Table UPDATE is too slow
Previous:From: Ron St-PierreDate: 2004-08-31 18:35:38
Subject: Re: Table UPDATE is too slow

pgsql-general by date

Next:From: Ron St-PierreDate: 2004-08-31 18:47:59
Subject: Re: cannot reach http:/archives.postgresql.org
Previous:From: Ron St-PierreDate: 2004-08-31 18:35:38
Subject: Re: Table UPDATE is too slow

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