Re: PostgreSQL on RAM Disk / tmpfs - Mailing list pgsql-general

From Merlin Moncure
Subject Re: PostgreSQL on RAM Disk / tmpfs
Date
Msg-id b42b73150608081110p51de6703iba58d9203941fe4b@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL on RAM Disk / tmpfs  ("Thomas F. O'Connell" <tfo@sitening.com>)
Responses Re: PostgreSQL on RAM Disk / tmpfs  ("Thomas F. O'Connell" <tfo@sitening.com>)
List pgsql-general
On 8/8/06, Thomas F. O'Connell <tfo@sitening.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

pgsql-general by date:

Previous
From: Joe Lester
Date:
Subject: Re: restoring a backup, incompatible with server
Next
From: "Merlin Moncure"
Date:
Subject: Re: running PostGres without installing it