[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] may have postgis store limits for a big project?
From:       Mark Cave-Ayland <mark.cave-ayland () siriusit ! co ! uk>
Date:       2010-07-26 11:44:11
Message-ID: 4C4D750B.2050103 () siriusit ! co ! uk
[Download RAW message or body]

Sebastian E. Ovide wrote:

> Hi Mark,
> 
> what hardware would you use to manage tables of 40M rows ? (simple 
> queries without Joins !) Each query must response in under 0.1 sec.
> 
> thanks

Hi Sebastian,

In terms of CPU power, any modern multi-core processor will perform 
absolutely fine. Make sure that you have plenty of RAM for caching (more 
than 4Gb) with nice fast disks to boot.

As long as the majority of your queries don't return more than a few 
hundred rows then I think you will be fine.


HTH,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]