having indexes when clearing tables - Mailing list pgsql-general

From nuno
Subject having indexes when clearing tables
Date
Msg-id 1152502539.577578.87680@m73g2000cwd.googlegroups.com
Whole thread Raw
Responses Re: having indexes when clearing tables  (Csaba Nagy <nagy@ecircle-ag.com>)
Re: having indexes when clearing tables  ("Merlin Moncure" <mmoncure@gmail.com>)
Re: having indexes when clearing tables  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
hi there.

i'm trying to clear data in a table but somehow it takes way too much
time than i once expected (i'm using the formal 'delete from xxx' type
of query.).

this table's got several foreign keys and i suspect that is why it
takes longer than expected.

my question is that
would having indexes increase query performance when clearing tables?
or could anyone suggest me any ways to increase performance of the
query in such cases?

thanks very much.

regards, nuno


pgsql-general by date:

Previous
From: "Leif B. Kristensen"
Date:
Subject: Re: Problem with COPY
Next
From: "lynnsettle@yahoo.com"
Date:
Subject: customizing pg_dump together with copy.c's DoCopy function