Postgres Pro
Downloads
Home   >   mailing lists

Re: Insertion to temp table deteriorating over time - Mailing list pgsql-performance

From Tom Lane
Subject Re: Insertion to temp table deteriorating over time
Date
Msg-id 19298.1166464855@sss.pgh.pa.us
Whole thread Raw
In response to Re: Insertion to temp table deteriorating over time  ("Steven Flatt" <steven.flatt@gmail.com>)
Responses Re: Insertion to temp table deteriorating over time
List pgsql-performance
Tree view 
"Steven Flatt" <steven.flatt@gmail.com> writes:
> I can fix this problem by using CREATE TEMP TABLE ... LIKE instead of CREATE
> TEMP TABLE ... AS.

That seems ... um ... bizarre.  Now are you able to put together a
self-contained test case?  Seems like we could have two independent bugs
here: first, why (and how) is the temp table different, and second how
does that result in the observed performance problem.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Steven Flatt"
Date:
Subject: Re: Insertion to temp table deteriorating over time
Next
From: Bill Moran
Date:
Subject: Re: Advice on selecting good values for work_mem?