Re: Deletes and large tables

Hi,

You have any foreign keys pointing this table ? That's the problem I
got when I wanted to delete all rows from a table with 5 FK. You may
search my name in the list archive and found the thread on this matter.

Ciao
/David
Edmund Dengler wrote:

>Greetings!
>
>We have a table with more than 250 million rows. I am trying to delete the
>first 100,000 rows (based on a bigint primary key), and I had to cancel
>after 4 hours of the system not actually finishing the delete. I wrote a
>script to delete individual rows 10,000 at a time using transactions, and
>am finding each individual delete takes on the order of 0.1 seconds to 2-3
>seconds. There are 4 indexes on the table, one of which is very "hashlike"
>(ie, distribution is throught the index for sequential rows).
>
>Is this considered "normal" for delete speed? Currently using 8.0.1.
>Drives are capable of 40MB/sec sustained transfers, but only acheiving
>about 2-10kB/sec, and mostly CPU bound.
>
>Regards!
>Ed
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
>