[GENERAL] Pgsql 7.3/7.4/8.0 on IA64 HP-UX 11i?

2004-08-16 Thread Ed L.
Has anyone successfully built 7.3.4, 7.4.3, or 8.0.0beta1 on IA64 with HP-UX 11i v2 (11.23)? I'm not having any success, running into 'make' failures. Googling old posts suggests this might be due to missing test-and-set code for ia64? I saw a disputed/repudiated ViSolve patch, but nothing

Re: [GENERAL] Thousands of parallel connections

2004-08-16 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom Lane wrote: | Gaetano Mendola <[EMAIL PROTECTED]> writes: | |>I did last week an Ariadne+Postgresql valutation for the company where I work |>and I learned that |>with 250 MB you can open up to 80 concurrent query |>with 500 MB you can open up to 1

Re: [GENERAL] Thousands of parallel connections

2004-08-16 Thread Tom Lane
Gaetano Mendola <[EMAIL PROTECTED]> writes: > I did last week an Ariadne+Postgresql valutation for the company where I work > and I learned that > with 250 MB you can open up to 80 concurrent query > with 500 MB you can open up to 120 concurrent query > from now on for each 250MB you can have ~40

Re: [GENERAL] postgres in freebsd jail

2004-08-16 Thread Vikram
> > creating template1 database in /home//db/base/1 ... FATAL: > > could > > not create shared memory segment: Function not implemented > > DETAIL: Failed system call was shmget(key=1, size=1187840, 03600). > > child process exited with exit code 1 > > initdb: failed > > Have you enabled jail.

Re: [GENERAL] PostgreSQL 8.0 Feature List?

2004-08-16 Thread Manuel Sugawara
Richard Welty <[EMAIL PROTECTED]> writes: >String query > = "SELECT foo " > + "FROM bar " > + "WHERE baz = 'bletch';" This particular expression is rewritten by the compiler to use StringBuffer, so is equivalent to: >StringBuffer query = new StringBuffer(); > >query.a

Re: [GENERAL] Does a 'stable' deferred trigger execution order exist?

2004-08-16 Thread Gaetano Mendola
Frank van Vugt wrote: If during a transaction a number of deferred triggers are fired, what will be their execution order upon the commit? Should be alphabetical within each triggering event, IIRC. Mmm, yes, but are all the deferred triggers on the same event 'grouped'? What I'm thinking about is

Re: [GENERAL] Thousands of parallel connections

2004-08-16 Thread Gaetano Mendola
Tom Lane wrote: Michal Taborsky <[EMAIL PROTECTED]> writes: Peter Eisentraut wrote: Is there any practical limit on the number of parallel connections that a PostgreSQL server can service? We're in the process of setting up a system that will require up to 1 connections open in parallel. Th

Re: [GENERAL] Does a 'stable' deferred trigger execution order exist?

2004-08-16 Thread Frank van Vugt
> > If during a transaction a number of deferred triggers are fired, what > > will be their execution order upon the commit? > Should be alphabetical within each triggering event, IIRC. Mmm, yes, but are all the deferred triggers on the same event 'grouped'? What I'm thinking about is something

Re: [GENERAL] where can i download pgs 7.3.x ?

2004-08-16 Thread Mike Mascari
Geoffrey KRETZ wrote: I've looked on the PGS website but don't look well enough. (I just thought that the mirror were only there to download the last version of postgre). What the hell is postgre? Mike Mascari ---(end of broadcast)--- TIP 8: explai

Re: [GENERAL] where can i download pgs 7.3.x ?

2004-08-16 Thread Bruno Wolff III
On Mon, Aug 16, 2004 at 18:31:05 +0200, Geoffrey KRETZ <[EMAIL PROTECTED]> wrote: > > So, if I want to post a new message I should not use "reply" but wrtie > an all new mail, is that right ? Correct. ---(end of broadcast)--- TIP 8: explain anal

Re: [GENERAL] where can i download pgs 7.3.x ?

2004-08-16 Thread Geoffrey KRETZ
Bruno Wolff III wrote: On Mon, Aug 16, 2004 at 18:08:44 +0200, Geoffrey KRETZ <[EMAIL PROTECTED]> wrote: Hello, For the purpose of QA testing, I need a 7.3.X version of postgreSQL for unix (linux i686) but I can't find it on the postgre website. Is it still possible to find such an old versi

Re: [GENERAL] where can i download pgs 7.3.x ?

2004-08-16 Thread Geoffrey KRETZ
P.S. The original request was posted as a reply to another thread. This is not a nice thing to do. It messes up the archives and can hide the fact that your request is new, causing some people who could have helped you to ignore it. I'm sorry for that, I don't mind to bother anyone (I've just r

Re: [GENERAL] where can i download pgs 7.3.x ?

2004-08-16 Thread Bruno Wolff III
On Mon, Aug 16, 2004 at 19:05:58 +0300, Devrim GUNDUZ <[EMAIL PROTECTED]> wrote: > > Hi, > > On Mon, 16 Aug 2004, Geoffrey KRETZ wrote: > > > For the purpose of QA testing, I need a 7.3.X version of postgreSQL for > > unix (linux i686) but I can't find it on the postgre website. > > ftp.pos

Re: [GENERAL] where can i download pgs 7.3.x ?

2004-08-16 Thread Bruno Wolff III
On Mon, Aug 16, 2004 at 18:08:44 +0200, Geoffrey KRETZ <[EMAIL PROTECTED]> wrote: > Hello, > > For the purpose of QA testing, I need a 7.3.X version of postgreSQL for > unix (linux i686) but I can't find it on the postgre website. > > Is it still possible to find such an old version of pgs av

Re: [GENERAL] where can i download pgs 7.3.x ?

2004-08-16 Thread Geoffrey KRETZ
Devrim GUNDUZ wrote: Hi, On Mon, 16 Aug 2004, Devrim GUNDUZ wrote: For the purpose of QA testing, I need a 7.3.X version of postgreSQL for unix (linux i686) but I can't find it on the postgre website. ftp.postgresql.org/postgresql/source/ Sorry for the typo. It should be: ftp.postg

Re: [GENERAL] where can i download pgs 7.3.x ?

2004-08-16 Thread Devrim GUNDUZ
Hi, On Mon, 16 Aug 2004, Devrim GUNDUZ wrote: > > For the purpose of QA testing, I need a 7.3.X version of postgreSQL for > > unix (linux i686) but I can't find it on the postgre website. > > ftp.postgresql.org/postgresql/source/ Sorry for the typo. It should be: ftp.postgresql.org/pub/pos

Re: [GENERAL] Thousands of parallel connections

2004-08-16 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Peter Eisentraut) would write: > Is there any practical limit on the number of parallel connections that a > PostgreSQL server can service? We're in the process of setting up a system > that will require up to 1 connections open in

Re: [GENERAL] where can i download pgs 7.3.x ?

2004-08-16 Thread Devrim GUNDUZ
Hi, On Mon, 16 Aug 2004, Geoffrey KRETZ wrote: > For the purpose of QA testing, I need a 7.3.X version of postgreSQL for > unix (linux i686) but I can't find it on the postgre website. ftp.postgresql.org/postgresql/source/ 7.3.6 is the latest one on 7.3 branch. Regards, -- Devrim GUNDUZ

[GENERAL] where can i download pgs 7.3.x ?

2004-08-16 Thread Geoffrey KRETZ
Hello, For the purpose of QA testing, I need a 7.3.X version of postgreSQL for unix (linux i686) but I can't find it on the postgre website. Is it still possible to find such an old version of pgs available for download ? Thx in advance Geoffrey Kretz - Four J's Development Tools -

Re: [GENERAL] PostgreSQL 8.0 Feature List?

2004-08-16 Thread Kris Jurka
On Sat, 14 Aug 2004, Richard Welty wrote: > the authors of 98%-99% of all introductory java textbooks have > a lot to answer for. my favorite example of the lot is that > they all teach programmers to use String in the following manner: > >String query > = "SELECT foo " > + "FROM

Re: [GENERAL] Index Issues & ReIndex

2004-08-16 Thread Andrew Sukow
Tom, We have tested our ram, and our previous build has the exact same hardware which is stable but this does not rule out hardware. I lean towards software to the fact that we are only finding the instability in the indexes. The four million rows we write per day are perfectly fine, but just

Re: [GENERAL] Problem when installing dbsize of PG 8.0-beta1

2004-08-16 Thread Bruce Momjian
It will be fixed in beta2 and is fixed current CVS. --- Renê Salomão wrote: > I installed PG 8.0 Beta 1 in my machine. Everything seemed ok... The > problem occurred when I tried to install the programs in contrib > directo

Re: [GENERAL] major database breakdown

2004-08-16 Thread Tom Lane
Ulrich Wisser <[EMAIL PROTECTED]> writes: > backend> REINDEX DATABASE "CLIX1" > NOTICE: relation 16416 was reindexed > NOTICE: relation 1255 was reindexed > ... > NOTICE: relation 16384 was reindexed > NOTICE: relation 16386 was reindexed > ERROR: Cannot create unique index. Table contains non

[GENERAL] Problem when installing dbsize of PG 8.0-beta1

2004-08-16 Thread Renê Salomão
I installed PG 8.0 Beta 1 in my machine. Everything seemed ok... The problem occurred when I tried to install the programs in contrib directory... I commented out dbsize from the Makefile... And everything installed successfully... Following is compiling output of dbsize... Am I doing anything wr

Re: [GENERAL] Thousands of parallel connections

2004-08-16 Thread Csaba Nagy
[snip] > requests, it only saves connection start effort. (You could make the > connection pool server queue the requests, but that is not the point of this > exercise.) I didn't quite consider the RAM question, but the machine is [snip] Well, I would disagree here. If the connections are not

Re: [GENERAL] Thousands of parallel connections

2004-08-16 Thread Ben
Really, this seems like it would be a pretty strong case for a replicated database. assuming not all 1 clients will need to be doing modifications. Or if they do, that they could open up a seperate, temporary connection with the master db. On Aug 16, 2004, at 7:37 AM, Peter Eisentraut w

Re: [GENERAL] Thousands of parallel connections

2004-08-16 Thread Tom Lane
Michal Taborsky <[EMAIL PROTECTED]> writes: > Peter Eisentraut wrote: >> Is there any practical limit on the number of parallel connections that a >> PostgreSQL server can service? We're in the process of setting up a system >> that will require up to 1 connections open in parallel. The que

Re: [GENERAL] could not find block containing chunk 0x8483530

2004-08-16 Thread Tom Lane
Vinay Jain <[EMAIL PROTECTED]> writes: > select *, lower(name) from student; > gives error: could not find block containing chunk 0x8483530 That's some sort of memory manipulation bug --- pfree'ing a wrong pointer, likely. > template1=# \d student > Table "public.student" > Column | Type

Re: [GENERAL] Thousands of parallel connections

2004-08-16 Thread Peter Eisentraut
Am Montag, 16. August 2004 16:20 schrieb Csaba Nagy: > Peter is definitely not a newby on this list, so i'm sure he already > thought about some kind of pooling if applicable... but then I'm > dead-curious what kind of application could possibly rule out connection > pooling even if it means so man

Re: [GENERAL] Does a 'stable' deferred trigger execution order exist? Is housekeeping for deferred trigger fire events done in one of the system catalogues?

2004-08-16 Thread Tom Lane
Frank van Vugt <[EMAIL PROTECTED]> writes: > If during a transaction a number of deferred triggers are fired, what will be > their execution order upon the commit? Should be alphabetical within each triggering event, IIRC. > Also, are the fire-events of deferred triggers kept in a system catalogu

Re: [GENERAL] Thousands of parallel connections

2004-08-16 Thread Csaba Nagy
Hi guys, Peter is definitely not a newby on this list, so i'm sure he already thought about some kind of pooling if applicable... but then I'm dead-curious what kind of application could possibly rule out connection pooling even if it means so many open connections ? Please give us some light Pete