I still have this problem...
my table currently only has 60k records. it has two foreign keys . one
to a table with
15 records the other to a table with 250 records both with a primary key
as suggested.
the table itself is referenced by another table.
although I have about 10mio records in other tables , this one is rather
small... still i manage to delete 2-3 records / second.
I tried vacuum, the db and tables and did not gain any performance.
I experience this problem on different machines and yet, when i reload
the date it did speed up things considerably.
Any suggestions what could be wrong? Maybe a configuration issue ?
Thanks
Alex
Tom Lane wrote:
>Alex <alex@meerkatsoft.com> writes:
>
>>hi have a table with 2.5 million records which i try do delete. i have
>>several constraints on it too.
>>i tried to delete the records using delete but it does not seem to work.
>>the delete runs forever. hrs...
>>i cannot truncate it as it complains about foreign keys.
>>
>
>It's a good bet that you need to create indexes on the columns that
>reference this table via foreign keys. Without such indexes, updates
>and deletes on the referenced table will be really slow.
>
> regards, tom lane
>
>
>