"Craig A. James" <cjames@xxxxxxxxxxxxxxxx> writes: > If you haven't explored the COPY command yet, check it out. It is stunningly fast compared to normal INSERT commands. Note also that his "benchmark" is testing multiple INSERTs issued within a loop in a plpgsql function, which has got nearly nothing to do with the performance that will be obtained from INSERTs issued by a client (especially if said INSERTs aren't prepared and/or aren't batched into transactions). regards, tom lane
