On Fri, 29 Jul 2011 22:44:14 +0200, Patrick Ben Koetter wrote: > * Walter Hurry <walterhu...@lavabit.com>: >> On Fri, 29 Jul 2011 21:56:03 +0200, Patrick Ben Koetter wrote: >> >> > Using an asynchronous approach using different databases is >> > interesting, but as I understand the solution discussed addresses >> > read performace. I am interested in write performance. How far could >> > you take it before PSQL topped out? Any special hardware in use? >> >> If it were me, I wouldn't be using psql, but libpq. > > I take it its faster. (I'm not a programmer). Why would you use it?
It's a C interface to PostgreSQL. If performance is the criterion, it is not a good idea to launch an executable (psql) just to insert a single row.