pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: alvarezp@alvarezp.ods.org
Cc: pgsql-performance@postgresql.org
Subject: Re: Slow delete times??
Date: Fri, 23 Jan 2004 20:44:34 -0500
Message-ID: <8854.1074908674@sss.pgh.pa.us> (raw)
In-Reply-To: <3110.63.84.67.25.1074904710.squirrel@alvarezp.ods.org>
References: <3110.63.84.67.25.1074904710.squirrel@alvarezp.ods.org>

"Octavio Alvarez" <alvarezp@alvarezp.ods.org> writes:
> Please tell me if this timing makes sense to you for a Celeron 433 w/
> RAM=256MB dedicated testing server. I expected some slowness, but not this
> high.

I'll bet you have foreign keys referencing this table, and the
referencing columns do not have indexes.  PG will let you do that
... but it makes updates and deletes horribly slow.  You generally
want to add those indexes.

If they *are* indexed, check for datatype mismatches.  That's
another thing that kills performance ...

			regards, tom lane



view thread (4+ messages)  latest in thread

Message-ID: <8854.1074908674@sss.pgh.pa.us>
Permalink:  ../8854.1074908674@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/8854.1074908674@sss.pgh.pa.us

 · 

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: tgl@sss.pgh.pa.us, alvarezp@alvarezp.ods.org
  Subject: Re: Slow delete times??
  In-Reply-To: <8854.1074908674@sss.pgh.pa.us>

* 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