[postgis-users] Hardware requirements
ValiSystem
vali.system at free.fr
Fri Jun 8 07:33:00 PDT 2007
On 8 juin 07, at 16:12, ValiSystem wrote:
>
>
> On 8 juin 07, at 12:25, Matt Doughty wrote:
>
>> Thinking about the memory issue, do Postgres and PostGIS have
>> recommended hardware requirements in terms of RAM, processor
>> speed, etc.
>> etc. Obviously this would depend upon how big the tables to be
>> processed
>> are and what type of operations are performed, but is there a general
>> 'rule of thumb'?
>>
>> Cheers,
>>
>> Matt
>>
>>
>>
>> Matt Doughty
>>
>> GEOGRAMA S.L.
>> Tel.: +34 945 13 13 72 652 77 14 15
>> Fax: +34 945 23 03 40
>> www.geograma.com
>>
>
> Well, for simple operations on indexes (overlapping,
> inclusion, ...) and some test,calculations (Contains, Distance) in
> the same query on a 10000 more or less complex polygons table i
> have an average 120ms for query processing for Mac OS X PPC
> 1.67GHz with one Gigabyte of ram. Same result on Linux with a
> 800Mhz C7 processor with 1GB ram.
>
> Searching points in a little area against a 100 000 points tables
> took around 300 ms on same hardware.(hum, i not sure, but i
> remember that 300ms were through a webservice call, so pure
> database query time might be the half time)
>
> re-projecting and calculating sum of areas of 11000 polygons takes
> 700ms on my PPC and les than 500ms on a 2Ghz C7.
>
> Memory is not very important eiser if you don't care waiting up to
> few seconds for query result (typically for development or desktop
> use, not multiuser use) - a few megabytes of memory are enough for
> postgres/postgis, depending of the size of your database of course
> (70 000 polygons here).
>
> My opinion is that as soon has you don't have to do full joins
> between two tables (eg having O(NxM) processing, N and M are the
> size of tables in rows with more than 5 000 elements to be really
> significative), or having to handle dozens of request per second,
> you really don't need huge hardware.
>
> So for a small database (few hundreds of objects), desktop/
> development use i would say that any hardware would fit (hum, don't
> try on your iPod, though). For multi user use, up to ten, without
> huge queries, i think that a little server (monocore, 1GB ram)
> would be enough.
>
>
>
oops typos
> few hundreds of objects
of course i meant "few hundred thousand objects"
More information about the postgis-users
mailing list