Re: it is always delete temp table will slow down the postmaster?

From: Qingqing Zhou
Subject: Re: it is always delete temp table will slow down the postmaster?
Date: ,
Msg-id: dderrg$f6a$1@news.hub.org
(view: Whole thread, Raw)
In response to: it is always delete temp table will slow down the postmaster?  ("Chun Yit(Chronos)")
List: pgsql-performance

""Chun Yit(Chronos)"" <> writes
>
>hi, i got one situation here, i create one pl/pgsql function that using
temp table to store temporary data.
>wherever i execute my function, i need to delete all the data inside the
temp table, but this will slow down the
>searching function if i conitnue to run the server because old tuples are
not really clear if just using delete command.
>so i use drop table command and recreate the table.

A better way to empty a table fast is "truncate table".

Regards,
Qingqing




pgsql-performance by date:

From: Tino Wildenhain
Date:
Subject: Re: Speedier count(*)
From: Richard Huxton
Date:
Subject: Re: PG8 Tuning