Re: Temp table's effect on performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert James <srobertjames(at)gmail(dot)com>
Cc: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Temp table's effect on performance
Date: 2013-01-18 19:57:39
Message-ID: 24316.1358539059@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Robert James <srobertjames(at)gmail(dot)com> writes:
> On 1/18/13, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Whether that's the explanation is of course impossible to know from
>> the given (lack of) information.

> What information would be helpful to post?

Both forms of the query, EXPLAIN ANALYZE output for both, along with the
underlying table definitions.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2013-01-18 20:00:30 Re: Understanding TIMESTAMP WITH TIME ZONE
Previous Message Robert James 2013-01-18 19:51:00 Re: Temp table's effect on performance