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 29551.1166547555@sss.pgh.pa.us
Whole thread Raw
In response to Re: Insertion to temp table deteriorating over time  ("Steven Flatt" <steven.flatt@gmail.com>)
List pgsql-performance
Tree view 
"Steven Flatt" <steven.flatt@gmail.com> writes:
>  I can't reproduce the problem that way either (or when using a server-side
> PLpgSQL function to do similar).  It looks like you have to go through an
> ODBC connection, with the looping done on the client side.  Each individual
> insert to the temp table needs to be sent over the connection and this is
> what degrades over time.  I can reproduce on 7.4.6 and 8.1.4.  I have a
> small C program to do this which I can send you offline if you're
> interested.

Please.

            regards, tom lane

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Inner join vs where-clause subquery
Next
From: "Jeremy Haile"
Date:
Subject: Re: Inner join vs where-clause subquery