From owner-freebsd-database Sun Nov 22 23:00:05 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id XAA05593 for freebsd-database-outgoing; Sun, 22 Nov 1998 23:00:05 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from paert.tse-online.de (paert.tse-online.de [194.97.69.172]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id XAA05587 for ; Sun, 22 Nov 1998 23:00:02 -0800 (PST) (envelope-from ab@paert.tse-online.de) Received: (qmail 7975 invoked by uid 1000); 23 Nov 1998 06:58:41 -0000 Message-ID: <19981123075841.A1110@paert.tse-online.de> Date: Mon, 23 Nov 1998 07:58:41 +0100 From: Andreas Braukmann To: freebsd-database@FreeBSD.ORG Subject: Sybase vs. shared memory? - was: Re: Sybase/uname: mystery resolved Mail-Followup-To: freebsd-database@freebsd.org References: <199810080551.WAA01336@dingo.cdrom.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.93i In-Reply-To: ; from John Fieber on Thu, Oct 08, 1998 at 09:06:48AM -0500 Organization: TSE TeleService GmbH Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Hi, ... I really would like to test 'sybase' on one of my -current machines. But I have some difficulties ... On Thu, Oct 08, 1998 at 09:06:48AM -0500, John Fieber wrote: > On Wed, 7 Oct 1998, Mike Smith wrote: > > > Other than this, sybase is working fine. "OK, I thought, ... registered and started the download ... > The linux_lib-2.4 port won't cut it, you need a ld-linux.so.2 and > a newer libc (at least, I have not nailed down exactly what is > needed). no problem. My -current is just a few days old, a freshly installed kernel is up and running, and a fresh linux_lib-2.6 is installed, too. > Log in as sybase...it will automagically run the sybinit program > to setup a database. The installation went relatively smoothly, besides the sybinit-script crashed on me once (/bin/sh dumped core on a segfault?). But: My configured database-server wouldn't run. The /opt/sybase/install/errorlog states: 00:1998/11/23 07:57:25.78 kernel os_create_region: can't allocate 11964416 bytes 00:1998/11/23 07:57:25.78 kernel kbcreate: couldn't create kernel region. 00:1998/11/23 07:57:25.79 kernel kistartup: could not create shared memory Hmmm, any hints? Thanks in advance, Andreas -- /// TSE TeleService GmbH | Gsf: Arne Reuter | /// Hovestrasse 14 | Andreas Braukmann | We do it with /// D-48351 Everswinkel | HRB: 1430, AG WAF | FreeBSD/SMP /// ------------------------------------------------------------------- /// PGP-Key: http://www.tse-online.de/~ab/public-key /// Key fingerprint: 12 13 EF BC 22 DD F4 B6 3C 25 C9 06 DC D3 45 9B To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Mon Nov 23 06:14:55 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id GAA19245 for freebsd-database-outgoing; Mon, 23 Nov 1998 06:14:55 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from fallout.campusview.indiana.edu (fallout.campusview.indiana.edu [149.159.1.1]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id GAA19236 for ; Mon, 23 Nov 1998 06:14:53 -0800 (PST) (envelope-from jfieber@fallout.campusview.indiana.edu) Received: from localhost (jfieber@localhost) by fallout.campusview.indiana.edu (8.9.1/8.9.1) with ESMTP id JAA24534; Mon, 23 Nov 1998 09:13:57 -0500 (EST) Date: Mon, 23 Nov 1998 09:13:57 -0500 (EST) From: John Fieber To: Andreas Braukmann cc: freebsd-database@FreeBSD.ORG Subject: Re: Sybase vs. shared memory? - was: Re: Sybase/uname: mystery resolved In-Reply-To: <19981123075841.A1110@paert.tse-online.de> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Mon, 23 Nov 1998, Andreas Braukmann wrote: > > to setup a database. > The installation went relatively smoothly, besides the sybinit-script > crashed on me once (/bin/sh dumped core on a segfault?). > > But: My configured database-server wouldn't run. > The /opt/sybase/install/errorlog states: > 00:1998/11/23 07:57:25.78 kernel os_create_region: can't allocate 11964416 bytes > 00:1998/11/23 07:57:25.78 kernel kbcreate: couldn't create kernel region. > 00:1998/11/23 07:57:25.79 kernel kistartup: could not create shared memory > > Hmmm, any hints? You need something like this: options SHMMAXPGS=4096 # Gobs of SHM for Sybase in your kernel config. It has also been discovered that setting maxusers to 32 works. With 64, the dataserver falls flat with segfaults. So, set maxusers to 32 initially and try adjusting it from there if you get things working. -john To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Nov 24 03:16:21 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id DAA07544 for freebsd-database-outgoing; Tue, 24 Nov 1998 03:16:21 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from paert.tse-online.de (paert.tse-online.de [194.97.69.172]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id DAA07538 for ; Tue, 24 Nov 1998 03:16:17 -0800 (PST) (envelope-from ab@paert.tse-online.de) Received: (qmail 15471 invoked by uid 1000); 24 Nov 1998 11:16:28 -0000 Message-ID: <19981124121627.A15451@paert.tse-online.de> Date: Tue, 24 Nov 1998 12:16:27 +0100 From: Andreas Braukmann To: freebsd-database@FreeBSD.ORG Subject: Re: Sybase vs. shared memory? Mail-Followup-To: freebsd-database@FreeBSD.ORG References: <19981123075841.A1110@paert.tse-online.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.93i In-Reply-To: ; from John Fieber on Mon, Nov 23, 1998 at 09:13:57AM -0500 Organization: TSE TeleService GmbH Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Hi, > > 00:1998/11/23 07:57:25.78 kernel kbcreate: couldn't create kernel region. > > 00:1998/11/23 07:57:25.79 kernel kistartup: could not create shared memory > > Hmmm, any hints? > > You need something like this: > options SHMMAXPGS=4096 # Gobs of SHM for Sybase ok. done this. I have to admit, that I've thought about this being the problem, but I've just overseen the option in LINT. > in your kernel config. It has also been discovered that setting > maxusers to 32 works. With 64, the dataserver falls flat with > segfaults. So, set maxusers to 32 initially and try adjusting it > from there if you get things working. strange. ... But the server ist running with maxusers=128 anyways. But now I have another problem; during the configuration process with ./install/sybinit (accepting the obvious defaults) the 'dataserver' gets startet but it seems that 'sybinit' and 'dataserver' can't communicate. I got the message: : Running task: create the master device. : Building the master device : ...Done : Task succeeded: create the master device. : Running task: update the SQL Server runserver file. : Task succeeded: update the SQL Server runserver file. : Running task: boot the SQL Server. : waiting for server 'TSE-SYBASE' to boot... : : INTERNAL ERROR: Could not locate message number '514' for : product 'SQL Server' in message cache. I've attached ./install/errorlog to this message. I'm really concerned about buggering the list with these kind of problems; but I currently don't have a real linux-server as a reference. More thanks in advance, Andreas -- /// TSE TeleService GmbH | Gsf: Arne Reuter | /// Hovestrasse 14 | Andreas Braukmann | We do it with /// D-48351 Everswinkel | HRB: 1430, AG WAF | FreeBSD/SMP /// ------------------------------------------------------------------- /// PGP-Key: http://www.tse-online.de/~ab/public-key /// Key fingerprint: 12 13 EF BC 22 DD F4 B6 3C 25 C9 06 DC D3 45 9B To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Nov 24 06:27:51 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id GAA27935 for freebsd-database-outgoing; Tue, 24 Nov 1998 06:27:51 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from fallout.campusview.indiana.edu (fallout.campusview.indiana.edu [149.159.1.1]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id GAA27926 for ; Tue, 24 Nov 1998 06:27:50 -0800 (PST) (envelope-from jfieber@fallout.campusview.indiana.edu) Received: from localhost (jfieber@localhost) by fallout.campusview.indiana.edu (8.9.1/8.9.1) with ESMTP id JAA02789; Tue, 24 Nov 1998 09:27:42 -0500 (EST) Date: Tue, 24 Nov 1998 09:27:42 -0500 (EST) From: John Fieber To: Andreas Braukmann cc: freebsd-database@FreeBSD.ORG Subject: Re: Sybase vs. shared memory? In-Reply-To: <19981124121627.A15451@paert.tse-online.de> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Tue, 24 Nov 1998, Andreas Braukmann wrote: > strange. ... But the server ist running with maxusers=128 anyways. Curious. > But now I have another problem; during the configuration process > with ./install/sybinit (accepting the obvious defaults) the > 'dataserver' gets startet but it seems that 'sybinit' and 'dataserver' > can't communicate. What does hostname(1) on your machine return? If it is longer than 29 characters, you will see this behavior. I had to reconfigure my system to use just the machine name rather than the full qualified internet name because I was one character over. -john To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Nov 24 11:49:34 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id LAA28984 for freebsd-database-outgoing; Tue, 24 Nov 1998 11:49:34 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from paert.tse-online.de (paert.tse-online.de [194.97.69.172]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id LAA28976 for ; Tue, 24 Nov 1998 11:49:21 -0800 (PST) (envelope-from ab@paert.tse-online.de) Received: (qmail 16924 invoked by uid 1000); 24 Nov 1998 19:49:36 -0000 Message-ID: <19981124204936.B13234@paert.tse-online.de> Date: Tue, 24 Nov 1998 20:49:36 +0100 From: Andreas Braukmann To: John Fieber Cc: freebsd-database@FreeBSD.ORG Subject: Re: Sybase vs. shared memory? Mail-Followup-To: John Fieber , freebsd-database@freebsd.org References: <19981124172121.B15177@paert.tse-online.de> Mime-Version: 1.0 Content-Type: multipart/mixed; boundary=zhXaljGHf11kAtnf X-Mailer: Mutt 0.93i In-Reply-To: ; from John Fieber on Tue, Nov 24, 1998 at 11:31:59AM -0500 Organization: TSE TeleService GmbH Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk --zhXaljGHf11kAtnf Content-Type: text/plain; charset=us-ascii Hi John, ... it's me again :(( ... and on the list again ... > I think you are having the maxusers problem; try setting your > maxusers to 32. The person who discovered that little wrinkle ok. done. The kernel with maxusers=32 is up and running. But it didn't change anything; I've even done a complete fresh extract/installation cycle. Again: : Running task: boot the SQL Server. : waiting for server 'TSE-SYBASE' to boot... : : INTERNAL ERROR: Could not locate message number '514' for product : 'SQL Server' in message cache. > appears to start but it continuously segfaults (but it has a > handler that catches the signal) so it doesn't get anywhere. hmm. It doesn't segfault as far as I'm able to suppose ...; but nonetheless it steadily loops like this: ['truss'-output:] syscall nanosleep(0x85c5714,0x0) returns 0 (0x0) syscall nanosleep(0x85c5714,0x0) returns 0 (0x0) syscall nanosleep(0x85c5714,0x0) returns 0 (0x0) SIGNAL 14 SIGNAL 14 SIGNAL 14 syscall nanosleep(0x85c5714,0x0) errno -4 'Interrupted system call' syscall linux_sigreturn(0x85c56a8) errno -4 'Interrupted system call' syscall nanosleep(0x85c5714,0x0) returns 0 (0x0) syscall nanosleep(0x85c5714,0x0) returns 0 (0x0) syscall nanosleep(0x85c5714,0x0) returns 0 (0x0) syscall nanosleep(0x85c5714,0x0) returns 0 (0x0) SIGNAL 14 SIGNAL 14 SIGNAL 14 syscall nanosleep(0x85c5714,0x0) errno -4 'Interrupted system call' syscall linux_sigreturn(0x85c56a8) errno -4 'Interrupted system call' syscall nanosleep(0x85c5714,0x0) [ and so on, and so on, and so on ] After 'sybinit' spits out the error message it offers the option to try it again ("Press to continue."). The concrete 'retry' starts after printing out another message about "Check the log ... for more information" and press the return-key a second time. For the system-call trace (output from truss) have a look at the attachment. Bye, Andreas -- /// TSE TeleService GmbH | Gsf: Arne Reuter | /// Hovestrasse 14 | Andreas Braukmann | We do it with /// D-48351 Everswinkel | HRB: 1430, AG WAF | FreeBSD/SMP /// ------------------------------------------------------------------- /// PGP-Key: http://www.tse-online.de/~ab/public-key /// Key fingerprint: 12 13 EF BC 22 DD F4 B6 3C 25 C9 06 DC D3 45 9B --zhXaljGHf11kAtnf Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename=sybinit-truss syscall (null)() returns 1 (0x1) syscall write(1,0x80e5a77,1) returns 1 (0x1) syscall linux_time(0x0) returns 911935932 (0x365b09bc) syscall write(3,0xefbce578,144) returns 144 (0x90) syscall write(1,0x80e5a77,1) returns 1 (0x1) syscall write(1,0xefbcdbd0,148) returns 148 (0x94) syscall write(1,0x8130b60,28) returns 28 (0x1c) syscall read(0x0,0x810811f,0x1) returns 1 (0x1) syscall write(1,0x80e5a77,1) returns 1 (0x1) syscall linux_time(0x0) returns 911935934 (0x365b09be) syscall write(3,0xefbce588,217) returns 217 (0xd9) syscall linux_time(0x0) returns 911935934 (0x365b09be) syscall write(3,0xefbdaa50,66) returns 66 (0x42) syscall write(1,0xefbda088,44) returns 44 (0x2c) syscall nanosleep(0xefbf24d8,0xefbf24d8) returns 0 (0x0) syscall linux_wait4(0x222,0xefbf208c,0x1,0x0) returns 0 (0x0) syscall close(4) returns 0 (0x0) syscall munmap(0x281ba000,0x2000) returns 0 (0x0) syscall linux_open("/opt/sybase/interfaces",0,0666) returns 4 (0x4) syscall linux_newfstat(4,0xefbf1fbc) returns 0 (0x0) syscall linux_mmap(0xefbf200c) returns 672899072 (0x281ba000) syscall read(0x4,0x281ba000,0x2000) returns 304 (0x130) syscall read(0x4,0x281ba000,0x2000) returns 0 (0x0) syscall close(5) returns 0 (0x0) syscall linux_open("/etc/hosts",0,0666) returns 5 (0x5) syscall linux_fcntl(0x5,0x1,0x0) returns 0 (0x0) syscall linux_fcntl(0x5,0x2,0x1) returns 0 (0x0) syscall linux_newfstat(5,0xefbf1fdc) returns 0 (0x0) syscall linux_mmap(0xefbf202c) returns 672907264 (0x281bc000) syscall read(0x5,0x281bc000,0x2000) returns 593 (0x251) syscall close(5) returns 0 (0x0) syscall munmap(0x281bc000,0x2000) returns 0 (0x0) syscall linux_open("/opt/sybase/interfaces",0,0666) returns 5 (0x5) syscall linux_socketcall(0x1,0xefbf2288) returns 6 (0x6) syscall linux_socketcall(0xe,0xefbf2274) returns 0 (0x0) syscall linux_socketcall(0xe,0xefbf2280) returns 0 (0x0) syscall linux_socketcall(0xe,0xefbf2280) returns 0 (0x0) syscall linux_fcntl(0x6,0x3,0x0) returns 2 (0x2) syscall linux_fcntl(0x6,0x4,0x802) returns 0 (0x0) syscall linux_socketcall(0x3,0xefbf2288) returns 0 (0x0) syscall linux_fcntl(0x6,0x4,0x2) returns 0 (0x0) syscall linux_socketcall(0xe,0xefbf22d4) returns 0 (0x0) syscall linux_newuname(0xefbf1f38) returns 0 (0x0) syscall getpid() returns 540 (0x21c) syscall write(6,0x832f048,512) returns 512 (0x200) syscall write(6,0x832f048,93) returns 93 (0x5d) syscall linux_socketcall(0xe,0xefbf22d8) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall ogetrlimit(0x7,0xefbf20f8) returns 0 (0x0) syscall linux_newselect(0x200,0xefbf2138,0x0,0x0,0xefbf2130) returns 0 (0x0) syscall linux_sigaction(0x2,0xefbf2110,0xefbf2100) returns 0 (0x0) syscall linux_socketcall(0x9,0xefbf20dc) returns 1 (0x1) syscall linux_sigaction(0x2,0xefbf2118,0x0) returns 0 (0x0) syscall close(6) returns 0 (0x0) syscall write(1,0x80e5a77,1) returns 1 (0x1) syscall write(1,0xefbcdbc0,99) returns 99 (0x63) syscall write(1,0x8130b60,28) returns 28 (0x1c) --zhXaljGHf11kAtnf-- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Nov 26 09:55:33 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id JAA18557 for freebsd-database-outgoing; Thu, 26 Nov 1998 09:55:33 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from insomnia.local.net (tcs5-37.netwalk.net [206.175.76.37]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id JAA18549 for ; Thu, 26 Nov 1998 09:55:27 -0800 (PST) (envelope-from jmutter@netwalk.com) Received: from localhost (jmutter@localhost) by insomnia.local.net (8.8.8/8.8.8) with ESMTP id MAA06448 for ; Thu, 26 Nov 1998 12:55:25 -0500 (EST) (envelope-from jmutter@netwalk.com) X-Authentication-Warning: insomnia.local.net: jmutter owned process doing -bs Date: Thu, 26 Nov 1998 12:55:25 -0500 (EST) From: "James A. Mutter" Reply-To: jm7996@devrycols.edu To: freebsd-database@FreeBSD.ORG Subject: Mysql 321 - Mysql 322 - msql Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk I've found myself in a situation where I need a database. It doesn't need to be 'feature packed', but it does need to be fast - I'm looking for recommendations. This database will eventually be used to archive messages from several mailing lists and will be accessed from a W3 frontend. Suggestions? Additionally, if anyone has any suggestions/ideas on the best way to implement this I'm more than willing to listen. Thanks much! - - Failure isn't getting knocked down - Failure is not getting back up. - To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Nov 26 10:34:37 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id KAA22236 for freebsd-database-outgoing; Thu, 26 Nov 1998 10:34:37 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from thelab.hub.org (nat1001.mpoweredpc.net [142.177.191.239]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id KAA22230 for ; Thu, 26 Nov 1998 10:34:35 -0800 (PST) (envelope-from scrappy@hub.org) Received: from localhost (scrappy@localhost) by thelab.hub.org (8.9.1/8.9.1) with ESMTP id OAA16631; Thu, 26 Nov 1998 14:34:27 -0400 (AST) (envelope-from scrappy@hub.org) X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs Date: Thu, 26 Nov 1998 14:34:25 -0400 (AST) From: The Hermit Hacker To: jm7996@devrycols.edu cc: freebsd-database@FreeBSD.ORG Subject: Re: Mysql 321 - Mysql 322 - msql In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Why not just use mhonarc with an ht/Dig front end to it? On Thu, 26 Nov 1998, James A. Mutter wrote: > > I've found myself in a situation where I need a database. It doesn't need > to be 'feature packed', but it does need to be fast - I'm looking for > recommendations. > > This database will eventually be used to archive messages from several > mailing lists and will be accessed from a W3 frontend. Suggestions? > > Additionally, if anyone has any suggestions/ideas on the best way to > implement this I'm more than willing to listen. > > Thanks much! > > - > - Failure isn't getting knocked down - Failure is not getting back up. > - > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-database" in the body of the message > Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Nov 26 22:24:46 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id WAA15361 for freebsd-database-outgoing; Thu, 26 Nov 1998 22:24:46 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from NIH2WAAF (smtp6.site1.csi.com [149.174.183.75]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id WAA15356 for ; Thu, 26 Nov 1998 22:24:44 -0800 (PST) (envelope-from berend@pobox.com) Received: from mail pickup service by csi.com with Microsoft SMTPSVC; Fri, 27 Nov 1998 01:24:32 -0500 Received: from auke.deboer (lon-c45-002-vty174.as.wcom.net [195.232.2.174]) by hil-img-ims-1.compuserve.com (8.8.6/8.8.6/IMS-1.6) with ESMTP id BAA16864 for ; Fri, 27 Nov 1998 01:23:59 -0500 (EST) Received: from bmach (bmach.deboer [192.168.33.3]) by auke.deboer (8.8.8/8.8.7) with SMTP id HAA00914 for ; Fri, 27 Nov 1998 07:23:23 +0100 (CET) (envelope-from berend@pobox.com) Received: by localhost with Microsoft MAPI; Fri, 27 Nov 1998 07:23:21 +0100 Message-ID: <01BE19D6.CFB95D00.berend@pobox.com> From: Berend de Boer To: "freebsd-database@FreeBSD.ORG" Subject: RE: Mysql 321 - Mysql 322 - msql Date: Fri, 27 Nov 1998 07:23:20 +0100 Organization: NederWare X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Thursday, November 26, 1998 6:55 PM, James A. Mutter [SMTP:jmutter@netwalk.com] wrote: > > I've found myself in a situation where I need a database. It doesn't need > to be 'feature packed', but it does need to be fast - I'm looking for > recommendations. I've created a port for Interbase 4 (free version). You might want to look into that. Currently I'm investigating Solid: http://www.solidtech.com/. Looks promising and the technical documentation is excellent. They really tell you what the product does and how it does it. Groetjes, Berend. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Nov 27 01:19:35 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id BAA29938 for freebsd-database-outgoing; Fri, 27 Nov 1998 01:19:35 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from liberty.bulinfo.net (liberty.bulinfo.net [195.10.36.71]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id BAA29923 for ; Fri, 27 Nov 1998 01:19:26 -0800 (PST) (envelope-from ian@bulinfo.net) Received: (qmail 39877 invoked from network); 27 Nov 1998 09:19:10 -0000 Received: from gate.bulinfo.net (195.10.36.66) by liberty.bulinfo.net with SMTP; 27 Nov 1998 09:19:10 -0000 Received: (qmail 6122 invoked from network); 27 Nov 1998 09:19:06 -0000 Received: from ppp39.bulinfo.net (HELO cserv.oksys.bg) (195.10.36.84) by gate.bulinfo.net with SMTP; 27 Nov 1998 09:19:06 -0000 Received: from ian (ian.oksys.bg [192.72.180.23]) by cserv.oksys.bg (8.8.8/8.8.8) with SMTP id LAA11971 for ; Fri, 27 Nov 1998 11:18:56 +0200 (EET) (envelope-from ian@bulinfo.net) Message-ID: <004901be19e6$d66b95e0$17b448c0@ian.oksys.bg> From: "Iani Brankov" To: Subject: Re: Mysql 321 - Mysql 322 - msql Date: Fri, 27 Nov 1998 11:17:54 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3115.0 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk -----Original Message----- From: James A. Mutter To: freebsd-database@FreeBSD.ORG Date: Thursday, November 26, 1998 7:58 PM Subject: Mysql 321 - Mysql 322 - msql > >I've found myself in a situation where I need a database. It doesn't need >to be 'feature packed', but it does need to be fast - I'm looking for >recommendations. > >This database will eventually be used to archive messages from several >mailing lists and will be accessed from a W3 frontend. Suggestions? > >Additionally, if anyone has any suggestions/ideas on the best way to >implement this I'm more than willing to listen. > >Thanks much! > >- >- Failure isn't getting knocked down - Failure is not getting back up. >- PostgreSQL 6.3.2 may be the best free one. --ian To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Nov 27 01:31:05 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id BAA01368 for freebsd-database-outgoing; Fri, 27 Nov 1998 01:31:05 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from aniwa.sky (p22-max9.wlg.ihug.co.nz [202.49.241.150]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id BAA01360 for ; Fri, 27 Nov 1998 01:30:55 -0800 (PST) (envelope-from andrew@squiz.co.nz) Received: from localhost (andrew@localhost) by aniwa.sky (8.8.8/8.8.7) with ESMTP id WAA17797; Fri, 27 Nov 1998 22:29:44 +1300 (NZDT) (envelope-from andrew@squiz.co.nz) Date: Fri, 27 Nov 1998 22:29:42 +1300 (NZDT) From: Andrew McNaughton X-Sender: andrew@aniwa.sky Reply-To: andrew@squiz.co.nz To: Iani Brankov cc: database@FreeBSD.ORG Subject: Re: Mysql 321 - Mysql 322 - msql In-Reply-To: <004901be19e6$d66b95e0$17b448c0@ian.oksys.bg> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Fri, 27 Nov 1998, Iani Brankov wrote: > From: James A. Mutter > > > >I've found myself in a situation where I need a database. It doesn't need > >to be 'feature packed', but it does need to be fast - I'm looking for > >recommendations. > > > >This database will eventually be used to archive messages from several > >mailing lists and will be accessed from a W3 frontend. Suggestions? > > > >Additionally, if anyone has any suggestions/ideas on the best way to > >implement this I'm more than willing to listen. > > > >Thanks much! > > > >- > >- Failure isn't getting knocked down - Failure is not getting back up. > >- > PostgreSQL 6.3.2 > may be the best free one. > > --ian It's possibly stronger on features, but it's slower than mysql. It is speed he's emphasizing. there was some discussion earlier this year on this list about adding indexes suitable for fulltext searching to PostgreSQL. Did anything happen in the end? It's the one feature I'd really like to have. I suspect it would be an important one to James also. Andrew McNaughton To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Nov 27 04:44:32 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id EAA17218 for freebsd-database-outgoing; Fri, 27 Nov 1998 04:44:32 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from thelab.hub.org (nat1001.mpoweredpc.net [142.177.191.239]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id EAA17213 for ; Fri, 27 Nov 1998 04:44:31 -0800 (PST) (envelope-from scrappy@hub.org) Received: from localhost (scrappy@localhost) by thelab.hub.org (8.9.1/8.9.1) with ESMTP id IAA21201; Fri, 27 Nov 1998 08:43:54 -0400 (AST) (envelope-from scrappy@hub.org) X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs Date: Fri, 27 Nov 1998 08:43:49 -0400 (AST) From: The Hermit Hacker To: Iani Brankov cc: database@FreeBSD.ORG Subject: Re: Mysql 321 - Mysql 322 - msql In-Reply-To: <004901be19e6$d66b95e0$17b448c0@ian.oksys.bg> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Fri, 27 Nov 1998, Iani Brankov wrote: > PostgreSQL 6.3.2 > may be the best free one. v6.4 is out, and has a CHANGES file from v6.3.2 of several hundred lines long... Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Nov 27 04:55:40 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id EAA18331 for freebsd-database-outgoing; Fri, 27 Nov 1998 04:55:40 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from thelab.hub.org (nat1001.mpoweredpc.net [142.177.191.239]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id EAA18323 for ; Fri, 27 Nov 1998 04:55:37 -0800 (PST) (envelope-from scrappy@hub.org) Received: from localhost (scrappy@localhost) by thelab.hub.org (8.9.1/8.9.1) with ESMTP id IAA21321; Fri, 27 Nov 1998 08:54:57 -0400 (AST) (envelope-from scrappy@hub.org) X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs Date: Fri, 27 Nov 1998 08:54:57 -0400 (AST) From: The Hermit Hacker To: Andrew McNaughton cc: Iani Brankov , pgsql-hackers@postgresql.org, database@FreeBSD.ORG Subject: Re: Mysql 321 - Mysql 322 - msql In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Fri, 27 Nov 1998, Andrew McNaughton wrote: > It's possibly stronger on features, but it's slower than mysql. It is > speed he's emphasizing. I've never actually installed mysql, so can't really compare the two, but I've been using PostgreSQL for everything I need an RDBMS for since I first took on the project 3 years ago now (wow, time flies)...each release has gotten progressively faster, but we've pretty much hit a limit as far as optimizations are concerned, there probably isn't a *noticeable* difference between v6.3.2 and v6.4... We are hoping to have the PREPARE statement put into v6.5, which should give a performance improvement in "repeatative queries", as the planning for the query can be done beforehand, taking out a step... > there was some discussion earlier this year on this list about adding > indexes suitable for fulltext searching to PostgreSQL. Did anything > happen in the end? It's the one feature I'd really like to have. I > suspect it would be an important one to James also. What do you mean by "fulltext searching"? Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Nov 27 05:26:29 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id FAA20263 for freebsd-database-outgoing; Fri, 27 Nov 1998 05:26:29 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from hesiod.nhh.no (hesiod.nhh.no [158.37.96.15]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id FAA20258 for ; Fri, 27 Nov 1998 05:26:22 -0800 (PST) (envelope-from tih@athene.nhh.no) Received: from athene.nhh.no (athene.nhh.no [158.37.96.16]) by hesiod.nhh.no (8.8.8/8.8.8) with ESMTP id OAA02062; Fri, 27 Nov 1998 14:25:03 +0100 (CET) Received: (from tih@localhost) by athene.nhh.no (8.8.8/8.8.8) id OAA14713; Fri, 27 Nov 1998 14:25:02 +0100 (CET) To: The Hermit Hacker Cc: Andrew McNaughton , Iani Brankov , pgsql-hackers@postgreSQL.org, database@FreeBSD.ORG Subject: Re: [HACKERS] Re: Mysql 321 - Mysql 322 - msql References: From: Tom Ivar Helbekkmo Date: 27 Nov 1998 14:25:00 +0100 In-Reply-To: The Hermit Hacker's message of "Fri, 27 Nov 1998 08:54:57 -0400 (AST)" Message-ID: <86ogptmfo3.fsf@athene.nhh.no> Lines: 23 X-Mailer: Gnus v5.6.44/Emacs 19.34 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk The Hermit Hacker writes: > What do you mean by "fulltext searching"? He's talking about inverted text indices, where text is indexed such that a word is the key, and the index returns pointers to all the places where that word occurs. Knowledge of word structure is usually built in, so that "hacks", "hacker", "hackers", "hacking" and so on are known to be derivatives of "hack", and can match it if requested. Noise words such as "a", "the" and so forth are usually not indexed. Inverted indexed text storage tends to take up much space, but there are ways to reduce this, and the best implementations do it remarkably well. A simple example: it is not really necessary to actually store the original text; it can instead be a sequence of links to the store of all individual words in the text database. See http://glimpse.cs.arizona.edu/ for a powerful inverted indexing engine and various related software. -tih -- Popularity is the hallmark of mediocrity. --Niles Crane, "Frasier" To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Nov 27 05:39:38 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id FAA21117 for freebsd-database-outgoing; Fri, 27 Nov 1998 05:39:38 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from thelab.hub.org (nat1001.mpoweredpc.net [142.177.191.239]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id FAA21112 for ; Fri, 27 Nov 1998 05:39:36 -0800 (PST) (envelope-from scrappy@hub.org) Received: from localhost (scrappy@localhost) by thelab.hub.org (8.9.1/8.9.1) with ESMTP id JAA21859; Fri, 27 Nov 1998 09:37:56 -0400 (AST) (envelope-from scrappy@hub.org) X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs Date: Fri, 27 Nov 1998 09:37:51 -0400 (AST) From: The Hermit Hacker To: Tom Ivar Helbekkmo cc: Andrew McNaughton , Iani Brankov , pgsql-hackers@postgreSQL.org, database@FreeBSD.ORG Subject: Re: [HACKERS] Re: Mysql 321 - Mysql 322 - msql In-Reply-To: <86ogptmfo3.fsf@athene.nhh.no> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On 27 Nov 1998, Tom Ivar Helbekkmo wrote: > The Hermit Hacker writes: > > > What do you mean by "fulltext searching"? > > He's talking about inverted text indices, where text is indexed such > that a word is the key, and the index returns pointers to all the > places where that word occurs. Knowledge of word structure is usually > built in, so that "hacks", "hacker", "hackers", "hacking" and so on > are known to be derivatives of "hack", and can match it if requested. > Noise words such as "a", "the" and so forth are usually not indexed. > > Inverted indexed text storage tends to take up much space, but there > are ways to reduce this, and the best implementations do it remarkably > well. A simple example: it is not really necessary to actually store > the original text; it can instead be a sequence of links to the store > of all individual words in the text database. > > See http://glimpse.cs.arizona.edu/ for a powerful inverted indexing > engine and various related software. Just curious, but other then specialized applications like Glimpse, does anyone actually support/do this? Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Nov 27 08:54:29 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id IAA07096 for freebsd-database-outgoing; Fri, 27 Nov 1998 08:54:29 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id IAA07091 for ; Fri, 27 Nov 1998 08:54:26 -0800 (PST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id LAA01749; Fri, 27 Nov 1998 11:53:45 -0500 (EST) To: pgsql-hackers@postgreSQL.org, database@FreeBSD.ORG Subject: Re: [HACKERS] Re: Mysql 321 - Mysql 322 - msql In-reply-to: Your message of Fri, 27 Nov 1998 09:37:51 -0400 (AST) Date: Fri, 27 Nov 1998 11:53:45 -0500 Message-ID: <1747.912185625@sss.pgh.pa.us> From: Tom Lane Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk The Hermit Hacker writes: > On 27 Nov 1998, Tom Ivar Helbekkmo wrote: >> See http://glimpse.cs.arizona.edu/ for a powerful inverted indexing >> engine and various related software. > Just curious, but other then specialized applications like > Glimpse, does anyone actually support/do this? I dearly love Glimpse. (Sample things I use it for: rooting through nearly 10 years worth of archived email; finding all references to a particular name in the Postgres sources, almost instantly; ditto for the even larger Ptolemy sources; looking for files that I can't remember where I put ... it's great. And aren't the Postgres mailing list archive indexes Glimpse-driven?) I don't currently have any databases that could benefit from full-text indexes. But I can think of applications where it'd be important, particularly after we get rid of the limit on tuple sizes so that it becomes reasonable to put fair-size chunks of text into database entries. For example: would it be useful to put my email archive into a Postgres database, one message per tuple? Maybe ... but if I can't glimpse it afterwards, forgetaboutit. You could probably glue something like this together from existing spare parts, say by running a nightly cron job that dumps out the text fields of your database for indexing by Glimpse. But it wouldn't be integrated into SQL --- you'd have to query the index separately outside of SQL, then use the results to drive a query to fetch the selected records. A seamless integration would make Glimpse indexes be a new type of index associated with a new match operator, something like create index index1 on table using glimpse (text_field); select * from table where glimpse(text_field, 'pattern'); I have no idea how hard that would be... regards, tom lane To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Nov 27 09:16:21 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id JAA08857 for freebsd-database-outgoing; Fri, 27 Nov 1998 09:16:21 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from thelab.hub.org (nat1001.mpoweredpc.net [142.177.191.239]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id JAA08851 for ; Fri, 27 Nov 1998 09:16:18 -0800 (PST) (envelope-from scrappy@hub.org) Received: from localhost (scrappy@localhost) by thelab.hub.org (8.9.1/8.9.1) with ESMTP id NAA24026; Fri, 27 Nov 1998 13:13:43 -0400 (AST) (envelope-from scrappy@hub.org) X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs Date: Fri, 27 Nov 1998 13:13:43 -0400 (AST) From: The Hermit Hacker To: Tom Lane cc: pgsql-hackers@postgreSQL.org, database@FreeBSD.ORG Subject: Re: [HACKERS] Re: Mysql 321 - Mysql 322 - msql In-Reply-To: <1747.912185625@sss.pgh.pa.us> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Fri, 27 Nov 1998, Tom Lane wrote: > The Hermit Hacker writes: > > On 27 Nov 1998, Tom Ivar Helbekkmo wrote: > >> See http://glimpse.cs.arizona.edu/ for a powerful inverted indexing > >> engine and various related software. > > > Just curious, but other then specialized applications like > > Glimpse, does anyone actually support/do this? > > I dearly love Glimpse. (Sample things I use it for: rooting through > nearly 10 years worth of archived email; finding all references to a > particular name in the Postgres sources, almost instantly; ditto for the > even larger Ptolemy sources; looking for files that I can't remember > where I put ... it's great. And aren't the Postgres mailing list > archive indexes Glimpse-driven?) Nope, I use ht/Dig for it... > A seamless integration would make Glimpse indexes be a new type of > index associated with a new match operator, something like > create index index1 on table using glimpse (text_field); > select * from table where glimpse(text_field, 'pattern'); > I have no idea how hard that would be... Anyone? This one I'd love to see... Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Nov 27 10:45:27 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id KAA15675 for freebsd-database-outgoing; Fri, 27 Nov 1998 10:45:27 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from misery.sdf.com (misery.sdf.com [204.244.213.49]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id KAA15643 for ; Fri, 27 Nov 1998 10:45:23 -0800 (PST) (envelope-from tom@sdf.com) Received: from tom by misery.sdf.com with esmtp (Exim 1.82 #3) id 0zjRzw-0004PM-00; Fri, 27 Nov 1998 09:48:05 -0800 Date: Fri, 27 Nov 1998 09:47:55 -0800 (PST) From: Tom To: The Hermit Hacker cc: Tom Ivar Helbekkmo , Andrew McNaughton , Iani Brankov , pgsql-hackers@postgreSQL.org, database@FreeBSD.ORG Subject: Re: [HACKERS] Re: Mysql 321 - Mysql 322 - msql In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Fri, 27 Nov 1998, The Hermit Hacker wrote: > Just curious, but other then specialized applications like > Glimpse, does anyone actually support/do this? Well, Oracle has their ConText option that does stuff like this. > Marc G. Fournier > Systems Administrator @ hub.org > primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Nov 27 11:20:30 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id LAA17985 for freebsd-database-outgoing; Fri, 27 Nov 1998 11:20:30 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from hesiod.nhh.no (hesiod.nhh.no [158.37.96.15]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id LAA17977 for ; Fri, 27 Nov 1998 11:20:28 -0800 (PST) (envelope-from tih@athene.nhh.no) Received: from athene.nhh.no (athene.nhh.no [158.37.96.16]) by hesiod.nhh.no (8.8.8/8.8.8) with ESMTP id UAA21041; Fri, 27 Nov 1998 20:20:17 +0100 (CET) Received: (from tih@localhost) by athene.nhh.no (8.8.8/8.8.8) id UAA15125; Fri, 27 Nov 1998 20:20:17 +0100 (CET) To: Tom Lane Cc: pgsql-hackers@postgreSQL.org, database@FreeBSD.ORG Subject: Re: [HACKERS] Re: Mysql 321 - Mysql 322 - msql References: <1747.912185625@sss.pgh.pa.us> From: Tom Ivar Helbekkmo Date: 27 Nov 1998 20:20:16 +0100 In-Reply-To: Tom Lane's message of "Fri, 27 Nov 1998 11:53:45 -0500" Message-ID: <861zmpj633.fsf@athene.nhh.no> Lines: 24 X-Mailer: Gnus v5.6.44/Emacs 19.34 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Tom Lane writes: > I don't currently have any databases that could benefit from full-text > indexes. But I can think of applications where it'd be important, > particularly after we get rid of the limit on tuple sizes so that it > becomes reasonable to put fair-size chunks of text into database > entries. For example: would it be useful to put my email archive into > a Postgres database, one message per tuple? Maybe ... but if I can't > glimpse it afterwards, forgetaboutit. Another very important application is the keeping of structured documents in a database system. Advanced SGML environments do this, and Philip Greenspun of MIT, the author of the excellent book "Database Backed Web Sites" (see http://photo.net/ for information) recommends doing it for HTML and other data for web publishing. The web server AOLserver is just one example of an application that can do this -- and if I'm not mistaken, AOLserver can even use PostgreSQL. Anyway, once the data is in the database, and much of it is text, it becomes very interesting to be able to efficiently index and search. -tih -- Popularity is the hallmark of mediocrity. --Niles Crane, "Frasier" To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Nov 27 18:47:19 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id SAA24417 for freebsd-database-outgoing; Fri, 27 Nov 1998 18:47:19 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from liberty.bulinfo.net (liberty.bulinfo.net [195.10.36.71]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id SAA24407 for ; Fri, 27 Nov 1998 18:47:09 -0800 (PST) (envelope-from ian@bulinfo.net) Received: (qmail 31486 invoked from network); 28 Nov 1998 02:46:59 -0000 Received: from gate.bulinfo.net (195.10.36.66) by liberty.bulinfo.net with SMTP; 28 Nov 1998 02:46:59 -0000 Received: (qmail 14109 invoked from network); 28 Nov 1998 02:46:54 -0000 Received: from ppp49.bulinfo.net (HELO cserv.oksys.bg) (195.10.36.73) by gate.bulinfo.net with SMTP; 28 Nov 1998 02:46:54 -0000 Received: from cserv.oksys.bg (ian@cserv.oksys.bg [192.72.180.21]) by cserv.oksys.bg (8.8.8/8.8.8) with SMTP id EAA23151; Sat, 28 Nov 1998 04:46:49 +0200 (EET) (envelope-from ian@bulinfo.net) Message-ID: <365F6419.41C67EA6@bulinfo.net> Date: Sat, 28 Nov 1998 04:46:49 +0200 From: Yani Brankov Organization: ok systems X-Mailer: Mozilla 3.04 (X11; I; FreeBSD 2.2.7-STABLE i386) MIME-Version: 1.0 To: andrew@squiz.co.nz CC: database@FreeBSD.ORG Subject: Re: Mysql 321 - Mysql 322 - msql References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Andrew McNaughton wrote: > It's possibly stronger on features, but it's slower than mysql. It is > speed he's emphasizing. > Yes. It's much stronger on features, but (i heard, never tried it) mysql doesn't have commit/rollback command. It's a very big disadvantage. > there was some discussion earlier this year on this list about adding > indexes suitable for fulltext searching to PostgreSQL. Did anything > happen in the end? It's the one feature I'd really like to have. I > suspect it would be an important one to James also. I don't know the end of this discussion. I have a friend who is an internet provider. They use mysql on (Linux) for database containing offers for selling/renting houses. He said that in the begining, when the database was smaller mysql was may be the best choice, but now he is preparing to move to PostgreSQL 6.4 on FreeBSD. He's not satisfied with mysql for bigger databases. He said also the same thing for Linux and FreeBSD. :) --ian To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sat Nov 28 05:46:54 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id FAA14136 for freebsd-database-outgoing; Sat, 28 Nov 1998 05:46:54 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from fallout.campusview.indiana.edu (fallout.campusview.indiana.edu [149.159.1.1]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id FAA14131 for ; Sat, 28 Nov 1998 05:46:52 -0800 (PST) (envelope-from jfieber@fallout.campusview.indiana.edu) Received: from localhost (jfieber@localhost) by fallout.campusview.indiana.edu (8.9.1/8.9.1) with ESMTP id IAA16048; Sat, 28 Nov 1998 08:41:33 -0500 (EST) Date: Sat, 28 Nov 1998 08:41:33 -0500 (EST) From: John Fieber To: Yani Brankov cc: andrew@squiz.co.nz, database@FreeBSD.ORG Subject: Re: Mysql 321 - Mysql 322 - msql In-Reply-To: <365F6419.41C67EA6@bulinfo.net> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Sat, 28 Nov 1998, Yani Brankov wrote: > Andrew McNaughton wrote: > > > It's possibly stronger on features, but it's slower than mysql. It is > > speed he's emphasizing. > > Yes. It's much stronger on features, but (i heard, never tried it) mysql > doesn't have commit/rollback command. It's a very big disadvantage. Nor does it have (last I checked) subqueries or views which eliminate fairly large classes of useful queries. But, if you can live without these features, mySQL is a real speed demon and an excellent for database backed web sites. In working with the two, I've also found a couple complicated join queries where I just couldn't get the optimizer in PostgreSQL (6.3.2 and 6.4) to do the right thing, resulting in several minutes of processing per query, while mySQL did the same query in the blink of an eye. -john To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sat Nov 28 11:54:55 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id LAA08403 for freebsd-database-outgoing; Sat, 28 Nov 1998 11:54:55 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from thelab.hub.org (nat1001.mpoweredpc.net [142.177.191.239]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id LAA08397 for ; Sat, 28 Nov 1998 11:54:53 -0800 (PST) (envelope-from scrappy@hub.org) Received: from localhost (scrappy@localhost) by thelab.hub.org (8.9.1/8.9.1) with ESMTP id PAA04650; Sat, 28 Nov 1998 15:53:11 -0400 (AST) (envelope-from scrappy@hub.org) X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs Date: Sat, 28 Nov 1998 15:53:10 -0400 (AST) From: The Hermit Hacker To: Yani Brankov cc: andrew@squiz.co.nz, database@FreeBSD.ORG Subject: Re: Mysql 321 - Mysql 322 - msql In-Reply-To: <365F6419.41C67EA6@bulinfo.net> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Sat, 28 Nov 1998, Yani Brankov wrote: > Andrew McNaughton wrote: > > > > It's possibly stronger on features, but it's slower than mysql. It is > > speed he's emphasizing. > > > > Yes. It's much stronger on features, but (i heard, never tried it) mysql > doesn't have commit/rollback command. It's a very big disadvantage. The last time this was discussed on the PostgreSQL lists, the argument went that mySQL can't call itself a true RDBMS because it doesn't support one thing that was considered to be *crucial* to any RBDMS...transactions Whether this is still true or not, I don't know, since I don't use MySQL... Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sat Nov 28 11:57:11 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id LAA08692 for freebsd-database-outgoing; Sat, 28 Nov 1998 11:57:11 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from thelab.hub.org (nat1001.mpoweredpc.net [142.177.191.239]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id LAA08687 for ; Sat, 28 Nov 1998 11:57:09 -0800 (PST) (envelope-from scrappy@hub.org) Received: from localhost (scrappy@localhost) by thelab.hub.org (8.9.1/8.9.1) with ESMTP id PAA04721; Sat, 28 Nov 1998 15:54:51 -0400 (AST) (envelope-from scrappy@hub.org) X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs Date: Sat, 28 Nov 1998 15:54:46 -0400 (AST) From: The Hermit Hacker To: John Fieber cc: Yani Brankov , andrew@squiz.co.nz, pgsql-hackers@postgresql.org, database@FreeBSD.ORG Subject: Re: Mysql 321 - Mysql 322 - msql In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Sat, 28 Nov 1998, John Fieber wrote: > In working with the two, I've also found a couple complicated > join queries where I just couldn't get the optimizer in > PostgreSQL (6.3.2 and 6.4) to do the right thing, resulting in > several minutes of processing per query, while mySQL did the same > query in the blink of an eye. You mention v6.4 above, so could you provide us with a way of "reproducing" the bug? Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sat Nov 28 22:49:23 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id WAA29911 for freebsd-database-outgoing; Sat, 28 Nov 1998 22:49:23 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from aniwa.sky (p25-nas1.wlg.ihug.co.nz [216.100.145.25]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id WAA29906 for ; Sat, 28 Nov 1998 22:49:17 -0800 (PST) (envelope-from andrew@squiz.co.nz) Received: from localhost (andrew@localhost) by aniwa.sky (8.8.8/8.8.7) with ESMTP id OAA08482; Sun, 29 Nov 1998 14:37:10 +1300 (NZDT) (envelope-from andrew@squiz.co.nz) Date: Sun, 29 Nov 1998 14:37:09 +1300 (NZDT) From: Andrew McNaughton X-Sender: andrew@aniwa.sky Reply-To: andrew@squiz.co.nz To: The Hermit Hacker cc: Yani Brankov , database@FreeBSD.ORG Subject: Re: Mysql 321 - Mysql 322 - msql In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Sat, 28 Nov 1998, The Hermit Hacker wrote: > On Sat, 28 Nov 1998, Yani Brankov wrote: > > > Andrew McNaughton wrote: > > > > > > > It's possibly stronger on features, but it's slower than mysql. It is > > > speed he's emphasizing. > > > > > > > Yes. It's much stronger on features, but (i heard, never tried it) mysql > > doesn't have commit/rollback command. It's a very big disadvantage. > > The last time this was discussed on the PostgreSQL lists, the > argument went that mySQL can't call itself a true RDBMS because it doesn't > support one thing that was considered to be *crucial* to any > RBDMS...transactions > > Whether this is still true or not, I don't know, since I don't use > MySQL... >From the version 3.21.29 documentation: * 18.8 Some things we don't have any plans to do. * * Transactions with rollback (we mainly do selects, and because we * don't do transactions we can be much quicker on everything else). * We will support some kind of atomic operations on multiple tables * though. Currently atomic operations can be done with LOCK * TABLES/UNLOCK TABLES but we will make this more automatic in the * future. How much of a problem this is depends on how many threads are going to be trying to get at the tables at once. Andrew McNaughton To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message