# [EMAIL PROTECTED] / 2005-09-05 09:39:47 +0200:
> I working now for a wile with postgres (7.4), and I have the impression
> that is one of the slowest dbms with which I've aver worked. Can please
> somebody explain to me, why this is the case?
Because the default configuration (is | seems to
Hi List
Does anyone have any comments, HOWTOs and experience running multiple
Postgres servers with a shared disk (SAN) in a Hot standby configuration?
Can someone please point me in the direction of any docs on this subject?
Thanks in Advance
--
Peter Nixon
http://www.peternixon.net/
PGP Key
Reading up on ECPG, I figured it would be nice to be able to use that in
stored procedures. I couldn't find anything about such in the
documentation though.
So, a few questions:
Is it possible?
If so, is it feasable? Is the performance comparable to using libpq
calls directly, for example. Wha
>>[Peter Nixon wrote] :
>>Hi List
>> Does anyone have any comments, HOWTOs and experience running multiple
>> Postgres servers with a shared disk (SAN) in a Hot standby configuration?
>> Can someone please point me in the direction of any docs on this subject?
>> Thanks in Advance
For serve
Am Montag, 5. September 2005 11:42 schrieb Alban Hertroys:
> Reading up on ECPG, I figured it would be nice to be able to use that in
> stored procedures.
The purpose of ECPG is to provide a smooth interface for hooking in SQL calls
into C programs. If you want to have that kind of smoothness fo
Peter Eisentraut wrote:
Am Montag, 5. September 2005 11:42 schrieb Alban Hertroys:
Reading up on ECPG, I figured it would be nice to be able to use that in
stored procedures.
The purpose of ECPG is to provide a smooth interface for hooking in SQL calls
into C programs. If you want to have
Am Montag, 5. September 2005 13:37 schrieb Alban Hertroys:
> If it's not possible to use ECPG for this, too bad. Then we'll have to
> try with libpq (I doubt my boss would give us time to create a free
> implementation of a PL/ECPG or something along the lines). I'd just like
> to know...
If you a
Peter Eisentraut wrote:
If you are using libpq for writing stored procedures, you're doing something
wrong. libpq is for client-side access.
It seems the documentation doesn't tell what library to link, so I
guessed wrong. Searching the FAQs or my mailbox doesn't help much
either... Which li
Am Montag, 5. September 2005 14:39 schrieb Alban Hertroys:
> It seems the documentation doesn't tell what library to link, so I
> guessed wrong. Searching the FAQs or my mailbox doesn't help much
> either... Which lib are we supposed to use for SPI?
None. Your code will be compiled into a shared
Have you set your stats appropriately?
I've been wondering about how high to set these - is there any
performance downside to pumping up the statistics count on a table? I
presume ANALYZE will take longer, and the planner might take a tiny bit
longer, but otherwise, it can't hurt, correct?
Hello.
I will install a database on a remote server. There
is pg_hba.config file that should be adjusted to protect from unauthorized
access. It requires IP adresses.
Now, I would like to be able to connect to the
server from my personal computer, in order to do some maintenance job on the
[EMAIL PROTECTED] (Lukas Demetz) writes:
> Hi there, for a program I am building, which uses PostgreSQL as its
> backend, I want to embed the DB engine into the application's
> setup. Now I wonder if something like Firebird's "Embedded server"
> (a DLL ) is also available for PostgreSQL, or if ther
am 05.09.2005, um 15:49:23 +0200 mailte Zlatko Mati? folgendes:
> How can I connect to remote server from a remote personal computer
> without its own IP adress ?
You can connect to the remote server via ssh. Then you are a local user.
SSH is a highly secure protocol, i suggest, use ssh with Publ
On Mon, Sep 05, 2005 at 03:49:23PM +0200, Zlatko Mati? wrote:
> Hello.
>
> I will install a database on a remote server. There is pg_hba.config file
> that should be adjusted to protect from unauthorized access. It requires IP
> adresses.
> Now, I would like to be able to connect to the server f
Is it possible to pass a table name and/or schema name to a plpgsql
function?
How can I use them in the code? Which Types to use for each of the
parameters?
E.g.
create or replace function MyTest (mySchema WhichType?, myTable
WhichType?) returns integer as '
declare result integer;
Begin
[EMAIL PROTECTED] ("John D. Burger") writes:
>> Have you set your stats appropriately?
>
> I've been wondering about how high to set these - is there any
> performance downside to pumping up the statistics count on a table?
> I presume ANALYZE will take longer, and the planner might take a
> tiny b
am 05.09.2005, um 14:26:31 -0300 mailte Sidnei de Souza folgendes:
> Is it possible to pass a table name and/or schema name to a plpgsql
> function?
Yes.
> How can I use them in the code? Which Types to use for each of the
> parameters?
varchar.
>
> E.g.
>
> create or replace function MyTe
I'm trying to setup a database for 1 concurrent users for a test.
I have a system with 1GB of RAM where I will use 512MB for PostgreSQL.
It is running SuSE 9.3
I have changed SHMMAX & SHMALL
echo "536870912" >/proc/sys/kernel/shmmax
echo "536870912" >/proc/sys/kernel/shmall
and max_connectio
Calculated the values should be
SEMMNI = 1 / 16
SEMMNS = (1 / 16) * 17 "plus room for other applications" How much
should that be ?
And where can I change those values on a 2.6 kernel ?
I will try to answer myself with another question.
Can it be that it should be changed in
/usr/src/
Does PostgreSQL provide a way to step-debug into plpgSQL stored procedures?
If yes, how do you do debug the stored procedures? Can it be done via
any interface: jdbc, odbc, .net, etc.?
If no, is there any plans to provide debugging support of plpgSQL stored
procedures?
I do request, if you
Poul Møller Hansen wrote:
I'm trying to setup a database for 1 concurrent users for a test.
I have a system with 1GB of RAM where I will use 512MB for PostgreSQL.
It is running SuSE 9.3
I think you're being horribly optimistic if you actually want 1
concurrent connections, with users a
I think you're being horribly optimistic if you actually want 1
concurrent connections, with users all doing things. Even if you only
allow 1MB for each connection that's 10GB of RAM you'd want. Plus a big
chunk more to actually cache your database files and do work in. Then,
if you had 1
Daniel Morgan wrote:
Does PostgreSQL provide a way to step-debug into plpgSQL stored procedures?
Afraid not. One of the commercial versions of PG offered it as a feature
IIRC, but I could be wrong, and if so it was some time ago.
If yes, how do you do debug the stored procedures? Can it be d
Richard Huxton wrote:
Daniel Morgan wrote:
Does PostgreSQL provide a way to step-debug into plpgSQL stored
procedures?
It is a shame. PostgreSQL is really rocking these days. Especially
with 8.0 on Windows. I was really impressed how far it has come since
the 6.x days running on Cygwin.
FYI, it appears that you cannot start the postmaster when your current
working directory is not accessible by the postgres user:
shell-init: could not get current directory: getcwd: cannot access parent
directories: Permission denied
LOG: 0: could not identify current directory: Permission de
Hello everybody,
I've just wondered if there are any way to
implement an INSERT IGNORE in PostgreSQL, I know, I could catch an exception in
PL/pgSQL and just handle it in the right way, but I would need to write a SP for
the task. I've been lookin into the documentation and I found no simil
On Mon, 05 Sep 2005 21:59:33 +0100, Richard Huxton wrote:
> Daniel Morgan wrote:
> > Does PostgreSQL provide a way to step-debug into plpgSQL stored procedures?
>
> Afraid not. One of the commercial versions of PG offered it as a feature
> IIRC, but I could be wrong, and if so it was some time a
On Mon, 5 Sep 2005, [UTF-8] Poul Mц╦ller Hansen wrote:
> I'm trying to setup a database for 1 concurrent users for a test.
> I have a system with 1GB of RAM where I will use 512MB for PostgreSQL.
> It is running SuSE 9.3
>
> I have changed SHMMAX & SHMALL
> echo "536870912" >/proc/sys/kernel/
Keary Suska <[EMAIL PROTECTED]> writes:
> FYI, it appears that you cannot start the postmaster when your current
> working directory is not accessible by the postgres user:
Is there a good reason that this case should work? I don't think it's
very easy to fix given that we have to resolve the act
"Sergey E. Koposov" <[EMAIL PROTECTED]> writes:
> But I really doubt that it it possible/reasonable to have 1
> simultaneous connections.
You're going to need a heck of a beefy machine to do it, anyway.
I would expect that after fixing the semaphore configuration problem,
the next thing that
Hi,
I'm currently using PostgreSQL 8.0.3 and would like to have a load-
balancing and failover solution over LAN.
From reading the mailing list, it seems that pgpool and slony1
combination has been recommended for LAN replication. But seems that
pgcluster is still actively maintained? W
Poul Jensen wrote:
you want to create 1 million tables, all with one of
2 schemas?
I started out with a schema for each file, thinking I could utilize
the schema
structure in queries, but I don't see how. Schemas are useful for
grouping
tables according to users/owners. Other than t
I don't think any such behavior exists in PostgreSQL, and based on a reading of the behavior in MySQL, I can't imagine it ever existing considering the preference of PostgreSQL developers for correct (and sane) behavior. INSERT IGNORE seems like a foot-cannon... --Thomas F. O'ConnellCo-Founder, Inf
On Mon, Sep 05, 2005 at 10:35:49PM -0500, Thomas F. O'Connell wrote:
> I don't think any such behavior exists in PostgreSQL, and based on a
> reading of the behavior in MySQL, I can't imagine it ever existing
> considering the preference of PostgreSQL developers for correct (and
> sane) behav
On Sep 5, 2005, at 10:51 PM, Alvaro Herrera wrote:
On Mon, Sep 05, 2005 at 10:35:49PM -0500, Thomas F. O'Connell wrote:
I don't think any such behavior exists in PostgreSQL, and based on a
reading of the behavior in MySQL, I can't imagine it ever existing
considering the preference of Postgre
35 matches
Mail list logo
