Re: [postgis-users] how many min. floating-points?

From: Colin Wetherbee <cww(at)denterprises(dot)org>
To: Sam Mason <sam(at)samason(dot)me(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [postgis-users] how many min. floating-points?
Date: 2008-03-20 22:45:59
Message-ID: 47E2E927.7090901@denterprises.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sam Mason wrote:
> On Thu, Mar 20, 2008 at 02:02:12PM -0400, John Smith wrote:
>> how many min. floating-points must a server hardware support for
>> postgresql+postgis? does postgresql+postgis do much floating-point
>> math to make a difference? can someone give postgresql+postgis
>> application examples that will require high floating-points?
>
> I think you're referring to "floating point operations per second", not
> "floating points"---hence Colin's confusion.

Dunno about that. On the PostGIS list, he said:

"i got an old box supporting only 1 floating-point"

Maybe he means an FPU? *boggle*

Just for an interesting comparison, the Casio calculator I've used for
simple stuff for about 15 years runs at about 10 FLOPS. :)

> If I understand your question, PG doesn't require any specific
> performance level but your application probably does. For example, PG
> would be quite happy giving back one row per year if that's all your
> processor(s) were capable of. Your users may be a little unhappy with
> this though!

I think my calculator could weigh-in around one row per year. ;)

Colin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrej Ricnik-Bay 2008-03-20 23:28:55 Re: [postgis-users] how many min. floating-points?
Previous Message Tom Lane 2008-03-20 21:47:34 Re: [PATCHES] [GENERAL] Empty arrays with ARRAY[]