[GENERAL] Using libpq, floats and binary data

2010-09-15 Thread Michael Hull
Hi Guys, I have jsut started to use the libpq interface to postgre, and was wondering if someone with some experience could explain the 'best practices' :) I am preparing a query, then submitting it with binary data. 6 values are ints, and one is a float. For the ints, I understand that since I n

Re: [GENERAL] Search then Delete Performance

2010-09-15 Thread Michael Hull
On Wed, Sep 15, 2010 at 5:15 AM, Dann Corbit wrote: >> -Original Message- >> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- >> ow...@postgresql.org] On Behalf Of John R Pierce >> Sent: Tuesday, September 14, 2010 8:41 PM >> To: Mic

[GENERAL] Search then Delete Performance

2010-09-14 Thread Michael Hull
Hi Everyone, I am fairly new to practical databases, but I am trying out the c interface to postgres and am wondering how to improve performance. I am a researcher, and I am trying to perform a large parameter sweep. Since this will involve a couple of thousand simulations, I have a process that ma