DELETE SQL too slow.
От | Diogo Biazus |
---|---|
Тема | DELETE SQL too slow. |
Дата | |
Msg-id | 3D74C626.9020405@ikono.com.br обсуждение исходный текст |
Ответы |
Re: DELETE SQL too slow.
Re: DELETE SQL too slow. Re: DELETE SQL too slow. |
Список | 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@ikono.com.br Ikono Sistemas e Automação http://www.ikono.com.br
В списке pgsql-general по дате отправления: