Re: Challenging SQL Query Problem. Can you solve it?

Karen Hill wrote:

>>>Not unless you use PostgreSQL.
>>
>>You mean not if they don't want support.

A couple of developers answering their email if they aren't at mom's for Christmas dinner is not 7x24 support but you are welcome to your concept.

>>You mean not if they don't want robust backup and recovery ability.

One possibility out of many: I cant wait to get me some of that.

>>You mean not if they don't care about US Federal law (SarbOx, FACTA, HIPAA)
>>You mean not if they don't care about European law (Basel II)

No. But it does require security and auditing capabilities that in other than the big two or three RDBMS products requires hand coding every line.

>>You mean if they don't need to store and retrieve TB

>>From the postgresql website: http://www.postgresql.org/about/


> 

> Maximum Database Size	Unlimited


> Maximum Table Size	32 TB

> Maximum Row Size	1.6 TB

> Maximum Field Size	1 GB

> Maximum Rows per Table	Unlimited

> Maximum Columns per Table	250 - 1600 depending on column types

> Maximum Indexes per Table	Unlimited


Have you ever actually done it? Have you looked at the performance?
Have you ever tried to tune a slow statement?

>>You mean if they don't need messaging

> You got me there, I don't
>

>>You mean if they don't need instrumentation for tuning

Not the same thing by a light-year.

>>You mean if they don't need advanced security and auditing

So does MS Access. That's not security.

>>Those people. Do they really BUY things?

Certainly my impression looking at the number of jobs at dice.com and monster.com wanting that skill set.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)