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

From: "Chun Yit(Chronos)" <ivanbeh(at)chronos(dot)com(dot)my>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: it is always delete temp table will slow down the postmaster?
Date: 2005-08-11 03:37:57
Message-ID: 002001c59e26$11bc5bf0$a279640a@Beh
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>
>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. my question is, would it slow down the postmaster speed if i continue to
>run this searching function more than 300 time per day?, cause the speed for execute searching function will graduatelly increase
>after i test it for few day? anyway to test it is causing by the drop temp table and create temp table command?
>
>regards
>ivan

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Gavin Sherry 2005-08-11 03:52:04 Re: Speedier count(*)
Previous Message Tom Lane 2005-08-11 03:14:40 Re: partial index regarded more expensive