[postgis-users] Large Databases

[Martin Daly]

Jim,

> > We did this with a Big Dumb Upload(tm) into a single table, on a
> > standard (i.e. with no config tuning at all) PostgreSQL 
> 8.0.4/PostGIS
> > 1.0.4 installation on Windows, and are getting excellent 
> results.  The
> > machine spec is as follows:
>  
> Wow, you should try tuning it and see what happens. In particular,
> increasing shared_buffers, effective_cache_size, and possibly 
> work_mem.
> 
> You're also likely to see a noticable gain by going to 8.1.4 
> (you should
> at least get the latest 8.0 release; there's data loss bugs that have
> been fixed).

Luckily, this is just a test database, not a production one.  Also, we
were primarily interested in the upload performance, to see if it scaled
linearly up to national coverage, which it did very nicely.

That said, the server is mine to play with, so I will rerun the upload
some time soon with the latest PostgreSQL/PostGIS, plus some of your
dark arts tuning.

Regards,
Martin