Re: Postgres insert performance and storage requirement compared to Oracle

Поиск
Список
Период
Сортировка
От Divakar Singh
Тема Re: Postgres insert performance and storage requirement compared to Oracle
Дата
Msg-id 415787.11817.qm@web65404.mail.ac4.yahoo.com
обсуждение исходный текст
Ответ на Re: Postgres insert performance and storage requirement compared to Oracle  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-performance
Hi Joshua,
I have been only using libpq.
Is libpqXX better than the other?
Is there any notable facility in libpqxx which could aid in fast inserts or better performance in general?
 
Best Regards,
Divakar



From: Joshua D. Drake <jd@commandprompt.com>
To: Divakar Singh <dpsmails@yahoo.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>; pgsql-performance@postgresql.org
Sent: Tue, October 26, 2010 12:08:52 AM
Subject: Re: [PERFORM] Postgres insert performance and storage requirement compared to Oracle

On Mon, 2010-10-25 at 11:36 -0700, Divakar Singh wrote:

> 68 Rows inserted: 100,000
> Above results show good INSERT performance of PG when using SQL
> procedures. But
> performance when I use C++ lib is very bad. I did that test some time
> back so I
> do not have data for that right now.

This is interesting, are you using libpq or libpqXX?

Joshua D. Drake


>
>
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt


--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

В списке pgsql-performance по дате отправления:

Предыдущее
От: Steve Singer
Дата:
Сообщение: Re: Postgres insert performance and storage requirement compared to Oracle
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: AIX slow buffer reads