[ADMIN] Problems building Postgresql with multibyte enabled

2002-11-21 Thread Genty Jean-Paul
Hi I use Mandrake 7.2 and try to compile PostgresSQL 7.2.3 with multibyte enabled. I ran : ./configure --enable-multibyte && make The build fails on : make -C mb SUBSYS.o make: Entering an unknown directory make: *** mb: No such file or directory. Stop. make: Leaving an unknown directo

[ADMIN] Error while compiling

2002-11-21 Thread Henrique Spencer
Hi,   I'm subscribed to the list recently. My name is Henrique and I'm brasilian. My problem seems to be quite simple to resolve. I'm trying to compile Postgre 7.2.1 with J2RE and J2SDK 1.3.1 both. I tried with 1.4, but another error ocurred. Have some way to compile with 1.4? The error with

[ADMIN] sh: `-c' requires an argument

2002-11-21 Thread Girish Patangay
  I ran into this problem when running almost any command using psql, createdb or even trying to goto the shell using \!   The problem is that /bin/sh points to /bin/bash and my bash version is: $ bash -version GNU bash, version 1.14.7(1)   Here are the other errors: $ createdb foo

Re: [ADMIN] Query performanc issue - too many table?

2002-11-21 Thread Tom Lane
> The attached output is from 3 consecutive EXPLAIN ANALYSEs of the exact > same query. Each has a merge join floating somewhere within the query. > This has to be the culprit in terms of performance as this should be a > straightforward (albeit lengthy) step ladder keyed join query. It's not the

Re: [ADMIN] Query performanc issue - too many table?

2002-11-21 Thread Robert Treat
This is really just a standard "can you post explain analyze output" response, though I am wondering if might help you to use explicit joins on some of these tables. Robert Treat On Thu, 2002-11-21 at 11:59, Marc Mitchell wrote: > I am having a problem with the below SQL taking an extreme amount

Re: [ADMIN] Problems building Postgresql with multibyte enabled

2002-11-21 Thread Genty Jean-Paul
Sorry for the post I just found out that now the mb, c++ and java stuff are now in opt tar file !! Sorry again. Jean-Paul At 13:10 21/11/2002 +0100, Genty Jean-Paul wrote: Hi I use Mandrake 7.2 and try to compile PostgresSQL 7.2.3 with multibyte enabled. I ran : ./config

Re: [ADMIN] Problems building Postgresql with multibyte enabled

2002-11-21 Thread Tom Lane
Genty Jean-Paul <[EMAIL PROTECTED]> writes: > It seems directory src/backend/utils/mb does not exist. It should be there. Perhaps you got an incomplete download? regards, tom lane ---(end of broadcast)--- TIP 6: Have you se

[ADMIN] Cluster Database

2002-11-21 Thread Al-Karim Bhamani (LCL)
Hi Can Postgresql run in an clustered environment as Oracle runs as parallel server or RAC in 9i. Thanks. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[ADMIN] H/W RAID 5 on slower disks versus no raid on faster HDDs

2002-11-21 Thread Rajesh Kumar Mallah.
Hi folks, I have two options: 3*18 GB 10,000 RPM Ultra160 Dual Channel SCSI controller + H/W Raid 5 and 2*36 GB 15,000 RPM Ultra320 Dual Channel SCSI and no RAID Does anyone opinions *performance wise* the pros and cons of above two options. please take in consideration in latter case its h

[ADMIN] Query performanc issue - too many table?

2002-11-21 Thread Marc Mitchell
I am having a problem with the below SQL taking an extreme amount of time to run. The problem is that the explain looks great with all index scans. But the query itself takes minutes to run. The query contains 11 tables. We've found that by dropping any one table, performance reverts to being nea

[ADMIN] pg_hba.conf file review

2002-11-21 Thread Dan MacNeil
It would be great if somebody could review our pg_hha.conf file below to see if it does what we want it to, no more and no less. The goals for our pg_hba.conf file are: 1) In an emergency allow somebody with operatating system root privs access to all the databases with full privs. 2) Allow

Re: [ADMIN] Query performanc issue - too many table?

2002-11-21 Thread Tom Lane
"Marc Mitchell" <[EMAIL PROTECTED]> writes: > I am having a problem with the below SQL taking an extreme amount of time > to run. The problem is that the explain looks great with all index scans. > But the query itself takes minutes to run. The query contains 11 tables. > We've found that by drop

Re: [ADMIN] pg_hba.conf file review

2002-11-21 Thread Bruno Wolff III
On Thu, Nov 21, 2002 at 13:16:50 -0500, Dan MacNeil <[EMAIL PROTECTED]> wrote: > > Right now we give a user full privledges to the database, named after > the user by > > 1) creating the user with CREATEDB > 2) Give the user the right to connect to the database dummy > 3) creating a database as

Re: [ADMIN] Query performanc issue - too many table?

2002-11-21 Thread Marc Mitchell
Please excuse the attachment but these EXPLAIN ANALYSE were getting so wide, email was making it hard to fight word-wrap. The attached output is from 3 consecutive EXPLAIN ANALYSEs of the exact same query. Each has a merge join floating somewhere within the query. This has to be the culprit in te