try truncate. just be aware that truncate is being upgraded in 8.2
for better handling of foreign key isues.
merlin
On 9 Jul 2006 20:35:39 -0700, nuno <[EMAIL PROTECTED]> wrote:
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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
