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 in
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 c
On Thu, 6 Jan 2005 19:01:38 + (UTC)
Randolf Richardson <[EMAIL PROTECTED]> 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
I have an integer column that is not needed for some rows in the table
(whether it is necessary is a factor of other row attributes, and it
isn't worth putting in a separate table).
What are the performance tradeoffs (storage space, query speed) of using
NULL versus a sentinel integer value?
No
"[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 completio
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).
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
