Re: [PERFORM] Help with EXPLAIN ANALYZE runtimes

2005-01-09 Thread Guenzl, Martin
In case anyone is interested, I finally found what I believe to be the cause ... Or at least, I found the solution, and think I understand why. Having read Section 10.3 Controlling the Planner with Explicit JOIN Clauses (http://postgresql.org/docs/7.3/interactive/explicit-joins.html), I modified

[PERFORM] PostgreSQL vs. Oracle vs. Microsoft

2005-01-09 Thread Randolf Richardson
I'm looking for recent performance statistics on PostgreSQL vs. Oracle vs. Microsoft SQL Server. Recently someone has been trying to convince my client to switch from SyBASE to Microsoft SQL Server (they originally wanted to go with Oracle but have since fallen in love with Microsoft).

Re: [PERFORM] Some Performance Advice Needed

2005-01-09 Thread Randolf Richardson
[EMAIL PROTECTED] (Joshua D. Drake) wrote in pgsql.performance: Jeff wrote: On Dec 23, 2004, at 9:27 AM, Alex wrote: Running hdparm reported A) 920mb/s (SCSI 10k) B) 270mb/s (SCSI 10k) C) 1750mb/s (IDE 7.2k) IDE disks lie about write completion (This can be disabled on some

Re: [PERFORM] PostgreSQL vs. Oracle vs. Microsoft

2005-01-09 Thread mudfoot
Quoting Randolf Richardson [EMAIL PROTECTED]: I'm looking for recent performance statistics on PostgreSQL vs. Oracle vs. Microsoft SQL Server. Recently someone has been trying to convince my I don't know anything about your customer's requirements other than that they have a DB

Re: [PERFORM] PostgreSQL vs. Oracle vs. Microsoft

2005-01-09 Thread Gary Doades
Randolf Richardson wrote: I'm looking for recent performance statistics on PostgreSQL vs. Oracle vs. Microsoft SQL Server. Recently someone has been trying to convince my client to switch from SyBASE to Microsoft SQL Server (they originally wanted to go with Oracle but have since fallen