On 10/12/07, Jimmy Choi <[EMAIL PROTECTED]> wrote:
> I'm looking for general guideline on the use of temporary tables.
>
> I would like to use temporary table as a caching mechanism to speed up
> queries within the same session. Specifically, a temporary table is
> created to store a subset of data
ostgresql.org
> Subject: Re: [GENERAL] Guideline on use of temporary tables
>
> Jimmy Choi wrote:
> > I would like to use temporary table as a caching mechanism to speed up
> > queries within the same session.
>
> > Is this what temporary table is designed for?
]
[mailto:[EMAIL PROTECTED] On Behalf Of Richard Huxton
Sent: Monday, October 15, 2007 5:32 AM
To: Jimmy Choi
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Guideline on use of temporary tables
Jimmy Choi wrote:
> I would like to use temporary table as a caching mechanism to speed up
> q
Jimmy Choi wrote:
I would like to use temporary table as a caching mechanism to speed up
queries within the same session.
Is this what temporary table is designed for? Are there caveats that I
should be aware of? Can you think of other better alternatives?
It's a very common usage of tempora
