Re: [GENERAL] PostgresSQL vs. Informix

2007-11-29 Thread Trent Shipley
In answering the question, it might help to have information on two background items. The first item is the politics of the situation. I gather from Chad Hendren's post that an individual in the top-8-OEM-customer enterprise is advocating for Postgresql. The second item is the existing

Re: [GENERAL] Bigtime scaling of Postgresql (cluster and stuff I suppose)

2007-08-29 Thread Trent Shipley
On Monday 2007-08-27 08:04, Andrew Sullivan wrote: On Sat, Aug 25, 2007 at 11:13:45AM -0400, Tom Lane wrote: In case you hadn't noticed the disconnect between these statements: if they have to be that close together, there *will* be a single point of failure. Fire in your data center, for

Re: [GENERAL] Blobs in Postgresql

2007-08-17 Thread Trent Shipley
On Wednesday 2007-08-15 05:52, Gregory Stark wrote: Ron Olson [EMAIL PROTECTED] writes: Hi all- I am evaluating databases for use in a large project that will hold image data as blobs. I know, everybody says to just store pointers to files on the disk... Well not everyone. I usually

Re: [GENERAL] Fabian Pascal and RDBMS deficiencies in fully implementing

2006-06-13 Thread Trent Shipley
On Tuesday 2006-06-13 09:26, David Fetter wrote: On Tue, Jun 13, 2006 at 09:18:17AM -0600, Scott Ribe wrote: What say we just stop right there and call Date's Relational Model what it is: a silly edifice built atop wrong premises. SQL was a quick and dirty hack (Systems R and R* needed

Re: [GENERAL] postgres vs. oracle for very large tables

2006-06-13 Thread Trent Shipley
On Tuesday 2006-06-13 16:19, Jim C. Nasby wrote: On Mon, May 15, 2006 at 12:24:51PM -0700, TJ O'Donnell wrote: I've written some extensions to postgres to implement chemical structure searching. I get inquiries about the performance of postgres vs. oracle. This is a huge topic, with

Re: [GENERAL] Fabian Pascal and RDBMS deficiencies in fully

2006-06-09 Thread Trent Shipley
On Friday 2006-06-09 09:50, Martijn van Oosterhout wrote: On Fri, Jun 09, 2006 at 12:01:07PM -0400, A.M. wrote: So you should normalize and add relations to represent the state adequately. NULL doesn't give you enough information anyway- does NULL in a birthday header mean no birthday, n/a

Re: [GENERAL] Fabian Pascal and RDBMS deficiencies in fully implementing the relational model

2006-06-08 Thread Trent Shipley
On Thursday 2006-06-08 15:14, David Fetter wrote: On Thu, Jun 08, 2006 at 05:21:07AM -0700, [EMAIL PROTECTED] wrote: on bag theory[1] and 3-value logic[2]. Until they come up with a testable system, or Hell freezes over, whichever comes first, Pascal's book will make a good companion on your

Re: [GENERAL] Any *real* reason to choose a natural, composite PK over a surrogate, simple PK?

2006-06-08 Thread Trent Shipley
On Thursday 2006-06-08 05:48, [EMAIL PROTECTED] wrote: What am I missing? Why use a composite key *ever* aside from familiarity? Could someone give a real-world example where familiarity is a compelling reason to choose a composite PK, and trumps stability and simplicity? Another familiarity

Re: [GENERAL] Oracle purchases Sleepycat - is this the other shoe for MySQL AB?

2006-02-15 Thread Trent Shipley
On Wednesday 2006-02-15 18:42, Leonard Soetedjo wrote: On Wednesday 15 February 2006 01:38, Tom Lane wrote: merlyn@stonehenge.com (Randal L. Schwartz) writes: Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the other way that MySQL could have transactions if Oracle

[GENERAL] RAID-50

2006-01-18 Thread Trent Shipley
I once read in an O'Reilly book on tuning Solaris about RAID-50. That's right multiple RAID-5 disk sets each treated as a single logical drive then striped with RAID-0. The book said that if built correctly load balancing could make performance approach RAID-10 at considerably lower cost for

Re: [GENERAL] RAID-50

2006-01-18 Thread Trent Shipley
On Wednesday 2006-01-18 17:38, Michael Crozier wrote: I once read in an O'Reilly book on tuning Solaris about RAID-50. That's right multiple RAID-5 disk sets each treated as a single logical drive then striped with RAID-0. The book said that if built correctly load balancing could make

[GENERAL] Relational Inheritance Thoughts

2006-01-06 Thread Trent Shipley
Relational Inheritance Thoughts The most fundamental property of relational inheritance is that it creates hierarchies of relations that act as composite relations. That is, relational inheritance produces a tree of relations (presumably tables) that itself can be treated as a relation. The

[GENERAL] Relational Inheritance Features.

2006-01-06 Thread Trent Shipley
Relational Inheritance Supporting Features Perhaps the most important deficit in Postgresql's current INHERITS model is hard to detect. That deficit is the inability to name inheritance classes themselves. One has to refer to the _per se_ class by referencing an associated table. While it

Re: [GENERAL] WAL logs multiplexing?

2005-12-28 Thread Trent Shipley
On Wednesday 2005-12-28 05:38, Martijn van Oosterhout wrote: On Wed, Dec 28, 2005 at 03:17:40PM +0300, Dmitry Panov wrote: I'm currently considering setting up online backup procedure and I thought maybe it would be a useful feature if the online logs could be written into more than one

Re: [GENERAL] Inheritance Algebra

2005-12-22 Thread Trent Shipley
On Wednesday 2005-12-21 07:50, Karsten Hilbert wrote: On Wed, Dec 21, 2005 at 01:52:34PM +0100, Martijn van Oosterhout wrote: On Sun, Dec 04, 2005 at 10:59:10PM -0700, Trent Shipley wrote: Relational Constraint Inheritance Algebra With regard to class and attribute uniqueness It's

[GENERAL] Inheritance Algebra

2005-12-04 Thread Trent Shipley
[ This post is theory oriented, so it can't go in HACKERS nor can it go in SQL so it gets posted to GENERAL. I would polish this more. Unfortunately, it is at the point were I'd seek feedback were I in a seminar. ] Relational Constraint Inheritance Algebra With regard to class and attribute

Re: [GENERAL] 3 x PostgreSQL in cluster/redunant

2005-11-15 Thread Trent Shipley
On Tuesday 2005-11-15 13:06, Joshua D. Drake wrote: Michelle Konzack wrote: Am 2005-11-14 16:54:41, schrieb Jim C. Nasby: On Mon, Nov 14, 2005 at 07:36:44PM +0100, Michelle Konzack wrote: Hello *, I have three Sun Server where I have reserved on each Server a Raid-5 of 1 TByte for my

[GENERAL] FOSS Reporting tools (was Oracle 10g Express - any danger for Postgres?)

2005-11-02 Thread Trent Shipley
On Wednesday 2005-11-02 13:11, Jim C. Nasby wrote: On Wed, Nov 02, 2005 at 01:25:31PM -0600, James Thompson wrote: Yes, sqlplus looks especially bad once you're used to banging around in psql. Although, I recently discovered rlwrap (a generic readline wrapper) which makes sqlplus almost