Insertion to temp table deteriorating over time
This is a discussion on Insertion to temp table deteriorating over time within the Pgsql Performance forums, part of the PostgreSQL category; --> "Steven Flatt" <steven.flatt@gmail.com> writes: > I can't reproduce the problem that way either (or when using a server-side > ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 09:58 AM
| ||||
| ||||
 Re: Insertion to temp table deteriorating over time "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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster      |
Linear Mode
