Re: temporary tables - Mailing list pgsql-general

From Bruce Momjian
Subject Re: temporary tables
Date
Msg-id 200301180118.h0I1IxN07511@candle.pha.pa.us
Whole thread Raw
In response to Re: temporary tables  (Mike Mascari <mascarm@mascari.com>)
List pgsql-general
Oops, I was wrong.  I thought we had some auto-destroy of table on
commit.  I now remember we have _only_ in 7.4:

    CREATE TABLE
    ...
    [ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]

We tried to get this into 7.3, but it arrive too late.

---------------------------------------------------------------------------

Mike Mascari wrote:
> Bruce Momjian wrote:
> > If you create a LOCAL TEMPORARY table, it will be automatically deleted
> > at the end of the transaction.  Also, in 7.3, temporary table data will
> > _not_ be synced/forced to disk like ordinary tables, though disk will
> > still be used as backing store for the table.  You can drop them
> > manually too.
> >
> > Greg Stark wrote:
> >
> >>I've always avoided using temporary tables for OLTP applications because I was
> >>afraid the rapid creating and deleting of temporary data would limit
> >>scalability.
>
> Forgive me if I'm wrong Bruce, but I thought the LOCAL option
> was WRT session visbility, not lifetime. IOW, all TEMP tables
> exist until dropped or until the end of session, not
> transaction. And LOCAL vs. GLOBAL determines visibility in other
>   sessions. Wasn't the point of Gavin's patch for ON COMMIT DROP
> that got bumped to 7.4 to have the DBMS drop TEMP tables at TX
> commit?
>
> Mike Mascari
> mascarm@mascari.com
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: Re: temporary tables
Next
From: "kanchana"
Date:
Subject: Re: Fw: configure error with krb5