Re: PostgreSQL on RAM Disk / tmpfs

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Thomas F(dot) O'Connell" <tfo(at)sitening(dot)com>
Cc: PgSQL-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL on RAM Disk / tmpfs
Date: 2006-08-08 18:10:15
Message-ID: b42b73150608081110p51de6703iba58d9203941fe4b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/8/06, Thomas F. O'Connell <tfo(at)sitening(dot)com> wrote:
> On Aug 3, 2006, at 1:26 PM, Merlin Moncure wrote:
> > if have super high write volumes, consider writing your insert call in
> > C. prepare your statement, and use the parameterized
> > version....ExecPrepared(...).
>
> Can you point to a good example of this anywhere in the docs? I don't
> see ExecPrepared anywhere in the core documentation.

well, it's actually PQexecPrepared()
http://www.postgresql.org/docs/8.1/interactive/libpq-exec.html

do some tests and you should see a nice improvement over PQexec().

regards,
merlin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2006-08-08 18:11:58 Re: running PostGres without installing it
Previous Message Joe Lester 2006-08-08 18:06:46 Re: restoring a backup, incompatible with server