On Tue, Mar 22, 2005 at 01:25:30PM +0200, Shaun Clements wrote: > Which is more efficient, in reading in a row of data, and assigning > individual column values to variables, and then inserting a new row into the > new table. > > pg_fetch_row > pg_fetch_assoc > pg_fetch_object > pg_fetch_result > pg_fetch_array > > Are there performance differences, which are noticeable?
The best way to determine this would be to benchmark each method in your own environment and observe whether there are significant differences. Have you considered using a server-side function to avoid passing the data back and forth between the client and the server? Are you familiar with constructs like CREATE TABLE AS and INSERT...SELECT? -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
