pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: nbarraza@uolsinectis.com.ar
Cc: pgsql-performance@postgresql.org
Cc: nbarraza@boldt.com.ar
Subject: Re:
Date: Wed, 10 Dec 2003 12:35:05 -0800 (PST)
Message-ID: <20031210123323.S707@megazone.bigpanda.com> (raw)
In-Reply-To: <20031210192958.BF23C6C8A6@honorio.sinectis.com.ar>
References: <20031210192958.BF23C6C8A6@honorio.sinectis.com.ar>


On Wed, 10 Dec 2003 nbarraza@uolsinectis.com.ar wrote:

> I have some problems on performance using postgresql v. 7.3.2 running on
> Linux RedHat 9. An update involving several rows (about 500000) on a
> table having 2800000 tuples takes in the order of 6 minutes. It is more
> than it takes on other plataforms (SqlServer, FOX). I think that there´s
> something wrong on my configuration. I´ve already adjusted some
> parameters as I could understand memory and disk usage. Next, I send a
> description of parameters changed in postgresql.conf, a scheme of the
> table, and an EXPLAIN ANALYZE of the command. The hardware configuration
> is a Pentium III 1 Ghz, 512 MB of memory, and an SCSI drive of 20 GB.
> Following goes the description:

> -- Values changed in postgresql.conf

> CREATE TABLE jugadas (
>     fecha_ju character(8),
>     hora_ju character(4),
>     juego character(2),
>     juego_vta character(2),
>     sorteo_p character(5),
>     sorteo_v character(5),
>     nro_servidor character(1),
>     ticket character(9),
>     terminal character(4),
>     sistema character(1),
>     agente character(5),
>     subagente character(3),
>     operador character(2),
>     importe character(7),
>     anulada character(1),
>     icode character(15),
>     codseg character(15),
>     tipo_moneda character(1),
>     apuesta character(100),
>     extraido character(1)
> );

Are there any tables that reference this one or other triggers? If so,
what do the tables/contraints/triggers involve look like?

I'm guessing there might be given the difference in the actual time
numbers to the total runtime on the explain analyze.




view thread (2+ messages)

Message-ID: <20031210123323.S707@megazone.bigpanda.com>
Permalink:  ../20031210123323.S707@megazone.bigpanda.com/
Also on:    postgresql.org/message-id/20031210123323.S707@megazone.bigpanda.com

 · 

reply

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: sszabo@megazone.bigpanda.com, nbarraza@uolsinectis.com.ar, nbarraza@boldt.com.ar
  Subject: Re:
  In-Reply-To: <20031210123323.S707@megazone.bigpanda.com>

* 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