From owner-freebsd-database Tue Jun 15 7:32:45 1999 Delivered-To: freebsd-database@freebsd.org Received: from scoisntc02.Scott.af.mil (scoisntc02.scott.af.mil [140.175.36.48]) by hub.freebsd.org (Postfix) with ESMTP id 6AE2715560 for ; Tue, 15 Jun 1999 07:32:39 -0700 (PDT) (envelope-from Joel.Clark@scott.af.mil) Received: by scoisntc02.scott.af.mil with Internet Mail Service (5.5.2232.9) id ; Tue, 15 Jun 1999 09:36:47 -0500 Message-ID: From: Clark Joel A1C AMC CSS To: "'freebsd-database@freebsd.org'" Subject: PostgreSQL 6.5 Date: Tue, 15 Jun 1999 09:33:37 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2232.9) Content-Type: text/plain; charset="ISO-8859-1" Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk I am not the official announcer or anything, but I noticed that PostgreSQL is 6.5 is out. It now supports row-level locking and other neato features. I am a big fan of this product so please head out to http://www.postgresql.org and check it out...nice redesign of the site, too! jc -- A1C Joel S. Clark Rapid Applications Developer 01010101010100110100000101000110 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Jun 15 8:24:28 1999 Delivered-To: freebsd-database@freebsd.org Received: from blue.mpainc.com (proxy.mpainc.com [198.246.145.98]) by hub.freebsd.org (Postfix) with ESMTP id D12D314C7F for ; Tue, 15 Jun 1999 08:24:07 -0700 (PDT) (envelope-from RickSiple@mpainc.com) Received: by BLUE with Internet Mail Service (5.5.2448.0) id ; Tue, 15 Jun 1999 11:26:47 -0400 Message-ID: <8FCA4DE144C8D211A4D30090273D14196F4F@BLUE> From: Rick Siple To: "'freebsd-database@freebsd.org'" Subject: RE: PostgreSQL 6.5 Date: Tue, 15 Jun 1999 11:26:46 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: multipart/mixed; boundary="----_=_NextPart_000_01BEB743.7B2167D2" Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_000_01BEB743.7B2167D2 Content-Type: text/plain; charset="iso-8859-1" Actually, PostgreSQL 6.5 has skipped over row-level locking (apparently they only had table level locking in 6.4.2) and is using a mechanism they call Multi-version Concurrency Control (MVCC). It is supposed to be better than row-level locking in that a reader can never be blocked by a writer. In row-level locking, once a writer reads and updates a row in a transaction, any readers wanting access to that row get blocked until the writer commits his transaction. With MVCC the readers get to read the old version of the record until the writer commits. This mechanism also obviates the need to a set number of locks. I attached the messages that was posted to the pgsql-announce mailing list. It looks like they tried to post it to the freebsd-database mailing list also, but addressed it to 'freebsd-databases' plural. __________ Rick Siple ricksiple@mpainc.com -----Original Message----- From: Clark Joel A1C AMC CSS [mailto:Joel.Clark@scott.af.mil] Sent: Tuesday, June 15, 1999 10:34 AM To: 'freebsd-database@freebsd.org' Subject: PostgreSQL 6.5 I am not the official announcer or anything, but I noticed that PostgreSQL is 6.5 is out. It now supports row-level locking and other neato features. I am a big fan of this product so please head out to http://www.postgresql.org and check it out...nice redesign of the site, too! jc -- A1C Joel S. Clark Rapid Applications Developer 01010101010100110100000101000110 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message ------_=_NextPart_000_01BEB743.7B2167D2 Content-Type: message/rfc822 Content-Description: [ANNOUNCE] PostgreSQL v6.5: Officially Released ... Message-ID: From: The Hermit Hacker To: pgsql-announce@postgreSQL.org Cc: freebsd-databases@freebsd.org Subject: [ANNOUNCE] PostgreSQL v6.5: Officially Released ... Date: Tue, 15 Jun 1999 00:32:04 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain; charset="iso-8859-1" After several months of intense development, and only almost two months of testing and bug fixes, we are pleased to announce the release of PostgreSQL v6.5 ... Due to the huge number of changes and improvements made in this last development cycle, it is highly recommended that you scan through the HISTORY file, but a few of the major changes/improvements are: Multi-version concurrency control(MVCC) This removes our old table-level locking, and replaces it with a locking system that is superior to most commercial database systems. Hot backups from pg_dump New SQL features We now have CASE, INTERSECT, and EXCEPT statement support. We have new LIMIT/OFFSET, SET TRANSACTION ISOLATION LEVEL, SELECT ... FOR UPDATE, and an improved LOCK TABLE command. Ports We continue to expand our port list, this time including WinNT/ix86 and NetBSD/arm32. and SpeedUps to several key areas within the system, to improve performance...as well as improved resource utilitization enhancements. This new release of PostgreSQL is available via: http://www.postgresql.org -> Software -> Download ------_=_NextPart_000_01BEB743.7B2167D2-- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Jun 15 11:18: 5 1999 Delivered-To: freebsd-database@freebsd.org Received: from thelab.hub.org (nat192.211.mpoweredpc.net [142.177.192.211]) by hub.freebsd.org (Postfix) with ESMTP id 80226155EC for ; Tue, 15 Jun 1999 11:18:00 -0700 (PDT) (envelope-from scrappy@hub.org) Received: from localhost (scrappy@localhost) by thelab.hub.org (8.9.3/8.9.1) with ESMTP id PAA55198; Tue, 15 Jun 1999 15:18:03 -0300 (ADT) (envelope-from scrappy@hub.org) X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs Date: Tue, 15 Jun 1999 15:18:03 -0300 (ADT) From: The Hermit Hacker To: Rick Siple Cc: "'freebsd-database@freebsd.org'" Subject: RE: PostgreSQL 6.5 In-Reply-To: <8FCA4DE144C8D211A4D30090273D14196F4F@BLUE> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Tue, 15 Jun 1999, Rick Siple wrote: > I attached the messages that was posted to the pgsql-announce > mailing list. It looks like they tried to post it to the freebsd-database > mailing list also, but addressed it to 'freebsd-databases' plural. D'oh, and I'm even subscribed to this list *sigh* Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy 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 Tue Jun 15 19: 7:17 1999 Delivered-To: freebsd-database@freebsd.org Received: from home (stargate.oeit.vic.edu.au [203.0.93.167]) by hub.freebsd.org (Postfix) with ESMTP id D2A401516C for ; Tue, 15 Jun 1999 19:07:10 -0700 (PDT) (envelope-from jsutton@genesis.net.au) Received: from localhost (jsutton@localhost) by home (8.8.7/8.8.5) with SMTP id MAA18672 for ; Wed, 16 Jun 1999 12:05:27 +1000 (EST) X-Authentication-Warning: stargate.home: jsutton owned process doing -bs Date: Wed, 16 Jun 1999 12:05:26 +1000 (EST) From: Joel Sutton X-Sender: jsutton@stargate.home To: "'freebsd-database@freebsd.org'" Subject: Re: PostgreSQL 6.5 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 Tue, 15 Jun 1999, Clark Joel A1C AMC CSS wrote: > I am a big fan of this product so please head out to I've "read" that MySQL performs better under load than Postgresql. Has anyone found this to be true?? It certainly seems to have much more to offer as far as features go. And the price is defiantely right. ;-) Thanks, Joel... --- Joel Sutton | Busy Bee Consulting Phone: 0409 426-563 | Melbourne, Australia Email: jsutton@genesis.net.au | http://www.genesis.net.au/~jsutton VicFUG Webmaster/Acting President | http://www.vicfug.au.freebsd.org/ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Jun 15 19:32: 0 1999 Delivered-To: freebsd-database@freebsd.org Received: from thelab.hub.org (nat192.211.mpoweredpc.net [142.177.192.211]) by hub.freebsd.org (Postfix) with ESMTP id 97F36153DF for ; Tue, 15 Jun 1999 19:31:55 -0700 (PDT) (envelope-from scrappy@hub.org) Received: from localhost (scrappy@localhost) by thelab.hub.org (8.9.3/8.9.1) with ESMTP id XAA65307; Tue, 15 Jun 1999 23:31:48 -0300 (ADT) (envelope-from scrappy@hub.org) X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs Date: Tue, 15 Jun 1999 23:31:47 -0300 (ADT) From: The Hermit Hacker To: Joel Sutton Cc: "'freebsd-database@freebsd.org'" Subject: Re: PostgreSQL 6.5 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 Wed, 16 Jun 1999, Joel Sutton wrote: > On Tue, 15 Jun 1999, Clark Joel A1C AMC CSS wrote: > > > I am a big fan of this product so please head out to > > I've "read" that MySQL performs better under load than Postgresql. Has > anyone found this to be true?? The MySQL folks, back in v6.3.x, did a 'crash-me' test, comparing them against us (PostgreSQL) and, I believe, a few others...the test had major flaws that we proceeded to "educate" them about. They are missign features that are considered fundamental to an RDBMS (transactions being, IMHO, the biggest that I can think of), so their comparison "assumed" that those they were comparing with didn't have those features also, and didn't make use of them... Each release that we come out with is more stable, faster and more scaleable then the last, and it has been for pretty much every release so far...MySQL still, I believe, has the advantage of being faster for WWW sites *due* to its lack of features, but even that gap, I believe, is shrinking quickly. With the MVCC that has been integrated into v6.5, some sites have reported not only noticeable, but substantial increases in speed... As far as the 'load issue' is concerned, specifically...I'd be interested in knowing how and what was the problem. We had problems with shared memory, where the server would default to X blocks, but wouldn't pre-allocate them so if the system only has Y blocks, then as soon as Y blocks was hit, it would cause problems...this has also been fixed by reducing the default and pre-allocating on start up... Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy 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 Wed Jun 16 5:55:41 1999 Delivered-To: freebsd-database@freebsd.org Received: from scoisntc02.Scott.af.mil (scoisntc02.scott.af.mil [140.175.36.48]) by hub.freebsd.org (Postfix) with ESMTP id 1E57F150B7 for ; Wed, 16 Jun 1999 05:55:22 -0700 (PDT) (envelope-from Joel.Clark@scott.af.mil) Received: by scoisntc02.scott.af.mil with Internet Mail Service (5.5.2232.9) id ; Wed, 16 Jun 1999 07:59:44 -0500 Message-ID: From: Clark Joel A1C AMC CSS To: 'Joel Sutton' Cc: "'freebsd-database@freebsd.org'" Subject: RE: PostgreSQL 6.5 Date: Wed, 16 Jun 1999 07:56:19 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2232.9) Content-Type: text/plain; charset="ISO-8859-1" Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk >> I am a big fan of this product so please head out to >I've "read" that MySQL performs better under load than Postgresql. Has >anyone found this to be true?? Hermit was right on in his posting about MySQL being faster for lack of features. I did some testing myself (small scale) and was impressed with MySQL's speed, but when it came time to choose a db platform in our up-and-coming trucking company project, PostgreSQL was the only RDBMS that had the features we were looking for (to include being open source and free). The choice was obvious... FreeBSD and PostgreSQL >It certainly seems to have much more to offer as far as features go. And >the price is defiantely right. ;-) Indeed. jc To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Jun 16 8:34:30 1999 Delivered-To: freebsd-database@freebsd.org Received: from mail.go2france.com (go2france.com [209.51.193.70]) by hub.freebsd.org (Postfix) with SMTP id D588314BD8 for ; Wed, 16 Jun 1999 08:34:17 -0700 (PDT) (envelope-from lconrad@Go2France.com) Received: from superviseur [62.161.63.210] by mail.go2france.com with ESMTP (SMTPD32-4.03) id AFD67D860056; Wed, 16 Jun 1999 10:08:22 EST5EDT Message-Id: <4.2.0.56.19990616173207.01c7b3c0@go2france.com> X-Sender: lconrad@go2france.com X-Mailer: QUALCOMM Windows Eudora Pro Version 4.2.0.56 (Beta) Date: Wed, 16 Jun 1999 17:34:03 +0200 To: freebsd-database@freebsd.org From: Len Conrad Subject: RE: PostgreSQL 6.5 In-Reply-To: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=====================_2161998==_.ALT" Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk --=====================_2161998==_.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed Is there a Win NT ODBC driver (across ip) into PostgreSQL? We're thinking about FreeBSD and PostGreSQL as a backend for a ColdFusion/NT web server. Thanks, Len --=====================_2161998==_.ALT Content-Type: text/html; charset="us-ascii" Is there a Win NT ODBC driver (across ip) into PostgreSQL?  We're thinking about FreeBSD and PostGreSQL as a backend for a ColdFusion/NT web server.

Thanks,
Len
--=====================_2161998==_.ALT-- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Jun 16 9:16:13 1999 Delivered-To: freebsd-database@freebsd.org Received: from thelab.hub.org (nat192.211.mpoweredpc.net [142.177.192.211]) by hub.freebsd.org (Postfix) with ESMTP id 0B75B15460 for ; Wed, 16 Jun 1999 09:16:07 -0700 (PDT) (envelope-from scrappy@hub.org) Received: from localhost (scrappy@localhost) by thelab.hub.org (8.9.3/8.9.1) with ESMTP id NAA77444; Wed, 16 Jun 1999 13:15:24 -0300 (ADT) (envelope-from scrappy@hub.org) X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs Date: Wed, 16 Jun 1999 13:15:24 -0300 (ADT) From: The Hermit Hacker To: Len Conrad Cc: freebsd-database@FreeBSD.ORG Subject: RE: PostgreSQL 6.5 In-Reply-To: <4.2.0.56.19990616173207.01c7b3c0@go2france.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Wed, 16 Jun 1999, Len Conrad wrote: > Is there a Win NT ODBC driver (across ip) into PostgreSQL? We're thinking > about FreeBSD and PostGreSQL as a backend for a ColdFusion/NT web server. To the best of my knowledge, the ODBC driver that comes with PostgreSQL, as source, will work under NT...if you don't want to compile it, check out: http://www.insightdist.com/psqlodbc/ for a binary ... Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy 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 Wed Jun 16 11:49: 4 1999 Delivered-To: freebsd-database@freebsd.org Received: from scoisntc02.Scott.af.mil (scoisntc02.scott.af.mil [140.175.36.48]) by hub.freebsd.org (Postfix) with ESMTP id EAD28154A1 for ; Wed, 16 Jun 1999 11:48:33 -0700 (PDT) (envelope-from Joel.Clark@scott.af.mil) Received: by scoisntc02.scott.af.mil with Internet Mail Service (5.5.2232.9) id ; Wed, 16 Jun 1999 13:51:33 -0500 Message-ID: From: Clark Joel A1C AMC CSS To: "'freebsd-database@freebsd.org'" Subject: RE: PostgreSQL 6.5 Date: Wed, 16 Jun 1999 13:48:00 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2232.9) Content-Type: text/plain; charset="ISO-8859-1" Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk >On Wed, 16 Jun 1999, Len Conrad wrote: > >> Is there a Win NT ODBC driver (across ip) into PostgreSQL? We're thinking >> about FreeBSD and PostGreSQL as a backend for a ColdFusion/NT web server. > >To the best of my knowledge, the ODBC driver that comes with PostgreSQL, >as source, will work under NT... In theory (*sigh*) it should be the same across all Win32 platforms. (And yes it uses IP to get from point a to point b.) Go ahead and give it a whirl! jc To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message