Re: [PERFORM] Question about SQL performance

2007-06-05 Thread Richard Huxton
Jason Lustig wrote: I have some questions about the performance of certain types of SQL statements. What sort of speed increase is there usually with binding parameters (and thus preparing statements) v. straight sql with interpolated variables? Will Postgresql realize that the following quer

Re: [PERFORM] Question about SQL performance

2007-06-05 Thread mark
On Mon, Jun 04, 2007 at 11:18:30PM -0400, Jason Lustig wrote: > I have some questions about the performance of certain types of SQL > statements. > > What sort of speed increase is there usually with binding parameters > (and thus preparing statements) v. straight sql with interpolated > var

Re: [PERFORM] Question about SQL performance

2007-06-05 Thread PFC
What sort of speed increase is there usually with binding parameters (and thus preparing statements) v. straight sql with interpolated variables? Will Postgresql realize that the following queries are effectively the same (and thus re-use the query plan) or will it think they are differen

[PERFORM] Question about SQL performance

2007-06-04 Thread Jason Lustig
I have some questions about the performance of certain types of SQL statements. What sort of speed increase is there usually with binding parameters (and thus preparing statements) v. straight sql with interpolated variables? Will Postgresql realize that the following queries are effectiv