X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 19D2BD1B498 for ; Wed, 10 Dec 2003 20:35:55 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 16293-07 for ; Wed, 10 Dec 2003 16:35:25 -0400 (AST) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 5D136D1B468 for ; Wed, 10 Dec 2003 16:35:23 -0400 (AST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 03E9835305; Wed, 10 Dec 2003 12:35:06 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id F3F07352A2; Wed, 10 Dec 2003 12:35:05 -0800 (PST) Date: Wed, 10 Dec 2003 12:35:05 -0800 (PST) From: Stephan Szabo To: nbarraza@uolsinectis.com.ar Cc: pgsql-performance@postgresql.org, nbarraza@boldt.com.ar Subject: Re: In-Reply-To: <20031210192958.BF23C6C8A6@honorio.sinectis.com.ar> Message-ID: <20031210123323.S707@megazone.bigpanda.com> References: <20031210192958.BF23C6C8A6@honorio.sinectis.com.ar> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=X-UNKNOWN Content-Transfer-Encoding: QUOTED-PRINTABLE X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/172 X-Sequence-Number: 5032 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=B4s > something wrong on my configuration. I=B4ve 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.