| From: | Moshe Jacobson <moshe(at)neadwerx(dot)com> |
|---|---|
| To: | Ivan Voras <ivoras(at)freebsd(dot)org> |
| Cc: | Merlin Moncure <mmoncure(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Re: What's faster? BEGIN ... EXCEPTION or CREATE TEMP TABLE IF NOT EXISTS? |
| Date: | 2012-10-05 15:40:27 |
| Message-ID: | CAJ4CxLnjsK2e=A_bRoJS8ARSEuoP+PebsJONEfmkwUyfi9BpsA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Oct 5, 2012 at 11:13 AM, Ivan Voras <ivoras(at)freebsd(dot)org> wrote:
> > On the other hand, if the temp table can be completely ditched for a
> > session variable or two, then yeah, that would be much better since
> > you'd avoid the overhead of creating the table completely.
>
> Yes, this is what I was aiming at, based on the OP mentioning he only
> has a limited amount of data to manage in this way.
>
Yup, I'm going to see how this goes using session variables. I think it is
exactly what I need. Thanks!
--
Moshe Jacobson
Nead Werx, Inc. | Senior Systems Engineer
2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe(at)neadwerx(dot)com | www.neadwerx.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wolf Schwurack | 2012-10-05 16:01:36 | Re: [Pgbouncer-general] Again, problem with pgbouncer |
| Previous Message | Edson Richter | 2012-10-05 15:37:42 | Re: Counting all results before LIMIT |