Re: PostgreSQL on RAM Disk / tmpfs

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: PostgreSQL on RAM Disk / tmpfs
Дата
Msg-id b42b73150608081110p51de6703iba58d9203941fe4b@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL on RAM Disk / tmpfs  ("Thomas F. O'Connell" <tfo@sitening.com>)
Ответы Re: PostgreSQL on RAM Disk / tmpfs
Список 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 по дате отправления:

Предыдущее
От: Joe Lester
Дата:
Сообщение: Re: restoring a backup, incompatible with server
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: running PostGres without installing it