Hello all,
I am trying to do comparative study of PostgreSQL and Oracle.
Has anybody tried to use same binary for connecting to oracle as well as
PostgreSQL at the same time?
I mean the program should be able to create 1 connection to oracle and 1
connection to postgreSQL at the same time.
The pr
from xyz where a = 1
and
2. delete from xyz where a = 2
Then you will have to run query 2 times.
Best Regards,
Divakar
From: Werner Scholtes
To: Divakar Singh ; "pgsql-performance@postgresql.org"
Sent: Thu, December 16, 2010 3:11:36 PM
Subject: Re
If you have all records before issuing Insert, you can do it like: insert into
xxx values (a,b,c), (d,e,f), ..;
an example: http://kaiv.wordpress.com/2007/07/19/faster-insert-for-multiple-rows
Best Regards,
Divakar
From: Werner Scholtes
To: Divakar
Can you trying writing libpq program using COPY functions?
I hope it will be better than prepared statements.
Best Regards,
Divakar
From: Werner Scholtes
To: "pgsql-performance@postgresql.org"
Sent: Wed, December 15, 2010 8:21:55 PM
Subject: [PERFORM] perfor
.
Best Regards,
Divakar
From: Alex Goncharov
To: Divakar Singh
Cc: alex-goncha...@comcast.net; pgsql-performance@postgresql.org
Sent: Thu, December 9, 2010 11:21:26 AM
Subject: Re: [PERFORM] libpq vs ODBC
,--- You/Divakar (Wed, 8 Dec 2010 21:17:22 -0800 (PST
handling.
Am I right?
Best Regards,
Divakar
From: Alex Goncharov
To: Divakar Singh
Cc: pgsql-performance@postgresql.org
Sent: Thu, December 9, 2010 10:31:17 AM
Subject: Re: [PERFORM] libpq vs ODBC
,--- You/Divakar (Wed, 8 Dec 2010 20:31:30 -0800 (PST
Is there any performance penalty when I use ODBC library vs using libpq?
Best Regards,
Divakar
sql.org; t...@fuzzy.cz; Divakar Singh
Sent: Thu, November 25, 2010 5:55:33 PM
Subject: Re: [PERFORM] Which gives good performance? separate database vs
separate schema
> On Thursday 25 November 2010 13:02:08 t...@fuzzy.cz wrote:
>> I don't think you'll get performance improvement f
Hello Friends,
I have many instances of my software running on a server (Solaris SPARC). Each
software instance requires some DB tables (same DDL for all instances' tables)
to store data.
It essentially means that some processes from each instance of the software
connect to these tables.
Now, sh
May be a query that is filtering based on these 2 columns?
Best Regards,
Divakar
From: Cédric Villemain
To: dep...@depesz.com
Cc: Divakar Singh ; pgsql-performance@postgresql.org
Sent: Tue, November 2, 2010 4:34:42 PM
Subject: Re: [PERFORM] Insert
Singh
Cc: pgsql-performance@postgresql.org
Sent: Mon, November 1, 2010 7:50:59 PM
Subject: Re: [PERFORM] Insert performance with composite index
On Monday 01 November 2010 15:16:49 Divakar Singh wrote:
> I am using 9.0.1
Either thats not true or you cargo culted loads of your config fro
I am using 9.0.1
Best Regards,
Divakar
From: Andres Freund
To: Divakar Singh
Cc: pgsql-performance@postgresql.org
Sent: Mon, November 1, 2010 7:44:31 PM
Subject: Re: [PERFORM] Insert performance with composite index
On Monday 01 November 2010 15:08:10
Hi Marti,
Thanks for your tips. i will try those.
I am on Solaris Sparc 5.10
Best Regards,
Divakar
From: Marti Raudsepp
To: Divakar Singh
Cc: pgsql-performance@postgresql.org
Sent: Mon, November 1, 2010 6:23:17 PM
Subject: Re: [PERFORM] Insert performance
Hi,
I am trying to tune my libpq program for insert performance.
When I tried inserting 1M rows into a table with a Primary Key, it took almost
62 seconds.
After adding a composite index of 2 columns, the performance degrades to 125
seconds.
I am using COPY to insert all data in 1 transaction.
t
Dear All,
Thanks for your inputs on the insert performance part.
Any suggestion on storage requirement?
VACUUM is certainly not an option, because this is something related to
maintenance AFTER insertion.
I am talking about the plain storage requirement w.r. to Oracle, which I
observed is twice
tement? or something else?
Best Regards,
Divakar
From: Alex Hunsaker
To: Divakar Singh
Cc: Steve Singer ; j...@commandprompt.com;
pgsql-performance@postgresql.org
Sent: Thu, October 28, 2010 1:15:06 AM
Subject: Re: [PERFORM] Postgres insert performance a
t have any performance penalty?
Best Regards,
Divakar
From: Merlin Moncure
To: Divakar Singh
Cc: Robert Haas ; Mladen Gogala
; pgsql-performance@postgresql.org
Sent: Wed, October 27, 2010 11:36:00 PM
Subject: Re: [PERFORM] Postgres insert performance and storage r
ot;VACUUM VERBOSE tablename" on the table, what does it say?
[Need to check, will come back on this]
You also don't mention which version of postgresql your using.
[Latest, 9.x]
Best Regards,
Divakar
________
From: Steve Singer
To: Divakar Singh
Cc: j...
Hi Merlin,
Thanks for your quick input.
Well 1 difference worth mentioning:
I am inserting each row in a separate transaction, due to design of my program.
-Divakar
From: Merlin Moncure
To: Divakar Singh
Cc: pgsql-performance@postgresql.org
Sent: Tue
hich version of postgresql your using.
[Latest, 9.x]
Best Regards,
Divakar
From: Steve Singer
To: Divakar Singh
Cc: j...@commandprompt.com; pgsql-performance@postgresql.org
Sent: Tue, October 26, 2010 12:16:46 AM
Subject: Re: [PERFORM] Postgres insert
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
I use C++ lib is very bad. I did that test some time back so I
do not have data for that right now.
From: Scott Marlowe
To: Divakar Singh
Cc: pgsql-performance@postgresql.org
Sent: Mon, October 25, 2010 11:56:27 PM
Subject: Re: [PERFORM] Postgres insert
> 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
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
24 matches
Mail list logo