On 8/14/07, Lim Berger <straightfwd007@xxxxxxxxx> wrote: > INSERTing into MySQL takes 0.0001 seconds per insert query. > INSERTing into PgSQL takes 0.871 seconds per (much smaller) insert query. > > What can I do to improve this performance? What could be going wrong > to elicit such poor insertion performance from Postgresql? MySQL might not be writing the data straight out to disk ... just a guess. > Thanks. Cheers, Andrej ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly