DELETE SQL too slow.

From: Diogo Biazus <diogo(at)ikono(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: DELETE SQL too slow.
Date: 2002-09-03 14:24:38
Message-ID: 3D74C626.9020405@ikono.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm having problems with delete commands in postgres. They are too slow.
I'm trying to delete a set o 300 rows in table with 50000 rows with a
simple command like:

DELETE FROM table WHERE field1 = '4'

When I run the explain it tells me that index_scan is being used. But to
complete the delete it takes more than 30 minutes and the CPU use never
rise above 10%. The server that runs postgres is a RedHat Linux 7.3 over
a Pentium III 900 Mhz with 512 MB RAM

Here's a part of my postgresql.conf:

max_connections = 64
sort_mem = 32168
shared_buffers = 15200
fsync = false
enable_seqscan = false
wal_buffers = 10
wal_files = 10
checkpoint_segments = 20

--
Diogo de Oliveira Biazus
diogo(at)ikono(dot)com(dot)br
Ikono Sistemas e Automação
http://www.ikono.com.br

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Seidman 2002-09-03 14:30:01 Re: getting y/n or 1/0 from bool fields
Previous Message Martijn van Oosterhout 2002-09-03 14:24:36 Re: DELETE SQL too slow.