weisse Streifen, grĂ¼ner Rand
On Thursday 08 January 2009 08:30:07 Mayuresh Nirhali wrote:
Hello,
I am working with 8.1.4 pgsql as my database backend. I have a function
written in plpgsql language, that queries a particular table as below,
select host from table_host where ip_address = ip_array[i
Hello,
I am working with 8.1.4 pgsql as my database backend. I have a function
written in plpgsql language, that queries a particular table as below,
select host from table_host where ip_address = ip_array[i] and port =
port_array[i];
The query is running in a for loop. I see ip_array and p
Craig Ringer wrote:
David Siebert wrote:
I am interesting in finding a good Postgres benchmark. I an not
interested in seeing how fast Postgres is compared to MySql, Firebird,
or any other SQL database.
What I am interested in is how file systems, memory, and X-64 vs X-32
effects the performance
Bob,
First, Which exact version of S10 are you using ?
In general, I have seen having logs and data on different pools helps.
Also, let us know your wal tunning parameters like commit_delay, fsync.
If you are using S10u4, setting commit_delay to a non zero number should
help get better perform
Josh Harrison wrote:
Thanks .
We have around 3TB of data now running in Oracle. I have done
replication in postgresql but not much in Oracle. Is there a way you
can replicate between Oracle and Postgresql. For writing the custom
codes do you suggest any preferred language ...like java, perl
Josh Harrison wrote:
My question is abt the data migration. Im not sure how to try this
with an online oracle database. We are required to run both postgres
and oracle database simultaneously for a couple of months (atleast
till we decide whether we are going to shut down oracle for good !!!)
[EMAIL PROTECTED] wrote:
I initialized a database directory and it started fine. But when I
tried to create user I got this error.
Can you tell what is wrong?
thanks
I did a quick check on my Solaris box and it seems to be working fine
for me.
Can you provide more information on what exactly y
Hello,
http://foss.in/2007 , the most happening Open Source event in India is
taking place in Bangalore between Dec4th and Dec8th.
Is anybody from the postgres community planning to attend ?
I thought it would be a good opportunity to get together and talk about
Postgres and if we have some go
Hello,
I could not build pg8.2.4 on Solaris x86 because the variable PROFILE
was set in my path to desktop profile script.
Pg makfiles (Makfile.global) appends value of PROFILE if set to CFLAGS.
I was wondering if there is any particular reason for having PROFILE
appended to CFLAGS.
If this s