On Thu, Jan 25, 2001 at 05:14:50PM +0100, Gilles DAROLD wrote:
> Hi,
>
> With Apache/mod_perl it is very simple to enable DB connection
> persistance.
>
> in your perl script :
>
> use vars qw($dbh);
>
> $dbh ||= DBI::connect($datasrc, $dbuser, $dbpwd);
>
> That create a persistance connectio
To answer the question "why?".. I'm wanting to run multiple independent
database sessions of Postgresql on the same machine. I thought I'd just
copy pgsql.sh startup scripts and add the -D option to specifiy different
database locations and -p option to specify different tcp port
numbers. Howeve
Hi!
I've been taking a look in the Feature Lists / TODO Files of PostgreSQL 7.1,
and thought "hey, why is there PL/pgSQL, Perl and TCL interpreters available
for PostgreSQL and no Python one? That'd be a great thing for, ie, Zope!"
Any thougts? What would it take to do it? Just some PgSQL Langua
On Thu, Jan 25, 2001 at 01:12:48PM -0500, Brett W. McCoy wrote:
> Apache::DBI is supposed to be supporting connection pooling in the near
> future.
I believe this is scheduled (and only technically possible) with mod_perl
2.0, which will work with Apache 2.0 -- and they're both still in alpha.
So
Hello all, I have a problem.
When a try to use EXPLAIN
The optimize don't user the index of primary key.
Why ?
Thanks
Eriko
What performance penalty can I expect when going over TCP/IP sockets
instead of Unix sockets? I might have to do that because of some odd
configuration on the server that my app will run on. The application
(Apache/PHP) is on the same physical host as the Postgresql server.
Ta, Frank
> My /etc/rc.d/init.d/postgresql script has this line:
> su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster -o
> '-B 4096 -i' start >/dev/null 2>&1"
Isn't that BLCKSZx4096 ? I'm almost sure it is..
Some people (me) have BLCKSZ set to 32k so Just an FYI.
-Mitch
You need to specify the memory usage when you start the postmaster.
My /etc/rc.d/init.d/postgresql script has this line:
su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster -o
'-B 4096 -i' start >/dev/null 2>&1"
The -B option tells postgres to use 8KBx4096= 32MB pr. postmaster.
On Thu, 25 Jan 2001, Gilles DAROLD wrote:
> Don't forget to use Apache::DBI on top of DBI.pm. See mod_perl
> documentation
> for a complete setting.
Apache::DBI is supposed to be supporting connection pooling in the near
future.
-- Brett
http://www.chapelper
> > If you have enough RAM, the database will already be in memory, in a
> > manner of speaking - your kernel will have all of the files held in disk
> > cache.
>
> Ok, but if so, why 10 simultaneous same queries on a well-indexed table
> with only 500 000 records take a so long time ? :-/
Whic
Gilles DAROLD writes:
> With Apache/mod_perl it is very simple to enable DB connection
> persistance.
>
> in your perl script :
>
> use vars qw($dbh);
>
> $dbh ||= DBI::connect($datasrc, $dbuser, $dbpwd);
Even better, Apache::DBI will pool across Perl programs, and you don't
have to change any
Quoting Mirko Zeibig <[EMAIL PROTECTED]>:
Redirecting to the jdbc only list as that's where all jdbc emails should now go.
> Hello,
> my system:
> RedHat 7.0
> postgresql 7.1 (CVS)
> IBMJava2-SDK-1.3-1.1
>
> After having set JAVA_HOME "ant" is working like a charm, now it will
> build
> postgre
Hi,
To increase the performance of my database, I tried to tune options.
So I disabled fsync(), increased the shared memory on my Linux AND on
PostGreSQL.
But I'd like to know if it is possible to load the database into memory
or maybe is there other options that can change the memory use ?
Wh
Quoting Guillaume Lémery <[EMAIL PROTECTED]>:
> Hi,
>
> my database has to handle quickly several number of queries per second
> from numerous clients.
> Because of the waste of time for connection/disconnection, Im' looking
> for a connection pooling tool.
>
> Where can I find a such tool or
Hi,
With Apache/mod_perl it is very simple to enable DB connection
persistance.
in your perl script :
use vars qw($dbh);
$dbh ||= DBI::connect($datasrc, $dbuser, $dbpwd);
That create a persistance connection to your DB and you do not have to
care
about a pool of connection. Double pipe do all
Hi
I migrated from version 6.5 to
7.03
My function (see below) doesn't
work in 7.03, but it works in 6.5 .
CREATE FUNCTION "projects_update_function"
( ) RETURNS opaque AS ' begin if TG_OP=''UPDATE''
then NEW."Last
Modify":=''now''; return NEW; end
if; end;' LANGUAGE 'plpgsql
and anyone post some of their experiences with using the new replication
stuff in production?
--
[ Jim Mercer [EMAIL PROTECTED] ]
[ Reptilian Research -- Longer Life through Colder Blood ]
[ aka[EMAIL PROTECTED] +1 416 410-5633 ]
On Thu, Jan 25, 2001 at 10:01:21AM +0200,
Esa Pikkarainen <[EMAIL PROTECTED]> wrote:
> Thank you very much. Fine! Just two little questiton s more:
>
> 1) Can COALESCE take more than two alternatives?
>
> 2) Does it treat a zero length string as NULL or NOT NULL?
Wouldn't it have been faster
On Wed, Jan 24, 2001 at 05:24:20PM -0800,
David Wall <[EMAIL PROTECTED]> wrote:
> Is there any thought about the general availability date? Is there likely
> to be a migration issue if I use 7.1 beta now?
I had a problem reloading from a pg_dump file. The way views are done
seems to have chang
Hello PG's,
I am trying to compile postgresql 7.0.3 on AIX 4.3.2.
Configure worked fine with ./configure --with-CC=/usr/local/bin/gcc
--without-CXX
but after that make break up very early with the following output:
Making postgres.imp
./backend/port/aix/mkldexport.sh postgres /usr/local/pgsql/
The coalesce function can help with nulls. It takes a list of attributes or
literals and returns the first non-null value.
I use it like this:
select coalesce(numeric_attrib, 0) from some_table;
--rob
- Original Message -
From: "Bruno Wolff III" <[EMAIL PROTECTED]>
To: "postgresql" <[
El Mié 24 Ene 2001 15:07, David Wall escribió:
> Is there a place where I can see what the new features for 7.1 are expected
> to be? I'm hopeful for native BLOB support
check the todo list.
--
System Administration: It's a dirty job,
but someone told I had to do it.
22 matches
Mail list logo
