Mark Rostron writes:
> Can anyone please tell me how to interpret the (S_nn/C_nn) information in the
> log line.
> LOG: duration: 19817.211 ms execute S_73/C_74: (statement text) .
It's prepared statement name slash portal name. You'd have to look at
your client-side code to find out
Hey
Turned on log_min_duration_statement today and started getting timings on sql
statements (version 8.3.10).
Can anyone please tell me how to interpret the (S_nn/C_nn) information in the
log line.
LOG: duration: 19817.211 ms execute S_73/C_74: (statement text) .
Thanks for your tim
On Mon, Oct 25, 2010 at 4:28 PM, Merlin Moncure wrote:
> I ran the following tests w/libpqtypes. While you probably wont end
> up using libpqtypes, it's illustrative to mention it because it's
> generally the easiest way to get data into postgres and by far the
> fastest (excluding 'COPY'). sour
On Mon, Oct 25, 2010 at 2:12 PM, Divakar Singh wrote:
> Hello Experts,
> My application uses Oracle DB, and makes use of OCI interface.
> I have been able to develop similar interface using postgreSQL library.
> However, I have done some tests but results for PostgreSQL have not been
> encouraging
On October 25, 2010 11:36:24 am Divakar Singh wrote:
> 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.
Wrap it in a transaction.
--
Sent via pg
On Mon, Oct 25, 2010 at 12:36 PM, Divakar Singh wrote:
>
> Storage test was simple, but the data (seconds taken) for INSERT test for PG
> vs Oracle for 1, 2, 3,4 and 5 indexes was:
> PG:
> 25
> 30
> 37
> 42
> 45
>
> Oracle:
>
> 33
> 43
> 50
> 65
> 68
> Rows inserted: 100,000
> Above results show
| On Mon, Oct 25, 2010 at 2:21 PM, André Volpato
| wrote:
| > Hi all,
| >
| > We are tuning a PostgreSQL box with AIX 5.3 and got stucked in a
| > very odd situation.
| > When a query got ran for the second time, the system seems to
| > deliver the results to slow.
| >
| > Here´s some background
On Mon, Oct 25, 2010 at 11:39:30AM -0700, Divakar Singh wrote:
> Thanks Ray,
> Already seen that, but it does not tell about storage requirement compared to
> Oracle. I find it takes 2 times space than oracle.
>
>
> Best Regards,
> Divakar
>
> From: Ray Stell
Profiling could tell you where is the time lost and where is your
program spending time. Having experience with both Oracle and Postgres,
I don't feel that there is much of a difference in the insert speed. I
am not using C++, I am using scripting languages like Perl and PHP and,
as far as inse
Answers:
How are you using libpq?
-Are you opening and closing the database connection between each insert?
[Need to check, will come back on this]
-Are you doing all of your inserts as one big transaction or are you doing a
transaction per insert
[Answer: for C++ program, one insert per
On Mon, Oct 25, 2010 at 2:21 PM, André Volpato
wrote:
> Hi all,
>
> We are tuning a PostgreSQL box with AIX 5.3 and got stucked in a very odd
> situation.
> When a query got ran for the second time, the system seems to deliver the
> results to slow.
>
> Here´s some background info:
>
> AIX Box:
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
To: Divakar Singh
Cc: Scott Mar
On 10-10-25 02:31 PM, Divakar Singh wrote:
> My questions/scenarios are:
>
> 1. How does PostgreSQL perform when inserting data into an indexed
> (type: btree)
> table? Is it true that as you add the indexes on a table, the
> performance
> deteriorates significantly whereas Oracle does no
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.
Storage test was simple, but the data (seconds taken) for INSERT test for PG vs
Oracle for 1, 2, 3,4 and 5 indexes was:
PG:
25
30
37
42
45
Oracle:
33
43
50
65
68 Rows inserted: 100,000
Above results show good INSERT performance of PG when using SQL procedures. But
performance when I
On Mon, Oct 25, 2010 at 2:12 PM, Divakar Singh wrote:
> 1. How does PostgreSQL perform when inserting data into an indexed (type:
> btree) table? Is it true that as you add the indexes on a table, the
> performance deteriorates significantly whereas Oracle does not show that
> much performance dec
> My questions/scenarios are:
>
> 1. How does PostgreSQL perform when inserting data into an indexed
> (type: btree)
> table? Is it true that as you add the indexes on a table, the
> performance
> deteriorates significantly whereas Oracle does not show that much
> performance
> decrease. I hav
Hi all,
We are tuning a PostgreSQL box with AIX 5.3 and got stucked in a very odd
situation.
When a query got ran for the second time, the system seems to deliver the
results to slow.
Here´s some background info:
AIX Box:
PostgreSQL 8.4.4, AIX 5.3-9 64bits, SAN IBM DS3400, 8x450GB SAS 15K Ra
On Mon, Oct 25, 2010 at 12:12 PM, Divakar Singh wrote:
> Hello Experts,
> My application uses Oracle DB, and makes use of OCI interface.
> I have been able to develop similar interface using postgreSQL library.
> However, I have done some tests but results for PostgreSQL have not been
> encouragin
On Mon, 2010-10-25 at 11:12 -0700, Divakar Singh wrote:
> My questions/scenarios are:
>
> 1. How does PostgreSQL perform when inserting data into an indexed
> (type: btree)
> table? Is it true that as you add the indexes on a table, the
> performance
> deteriorates significantly whereas Oracle
Hello Experts,
My application uses Oracle DB, and makes use of OCI interface.
I have been able to develop similar interface using postgreSQL library.
However, I have done some tests but results for PostgreSQL have not been
encouraging for a few of them.
My questions/scenarios are:
1. How does Po
On 09/23/2010 05:05 AM, gnuo...@rcn.com wrote:
> Spoken like a dyed in the wool COBOL coder. The RM has no need for order;
> it's set based. I've dabbled in PG for some time, and my sense is
> increasingly that PG developers are truly code oriented, not database (set)
> oriented.
That's a b
22 matches
Mail list logo
