ivan.hou wrote: > how do u know this theory ? 1 + (2 * number of columns in the SELECT) > just try & test? I did this at first, yes. I changed log_statement to all, reload the configuration, and voila. I've seen that pgAdmin's query tool executes this number of queries to display the result. > or have any document? After I did a few tests, I get a look at the source. There's no other documents, as far as I know, about this. Regards. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings