[Benchmarking] PostGIS

Paul Ramsey pramsey at cleverelephant.ca
Fri Aug 13 10:25:07 EDT 2010

Be sure to run cluster on them after, if you are doing an add column update column process, otherwise you'll have a pile of dead tuples at the top of the table making things slow.


On 2010-08-13, at 5:45 AM, Jeff McKenna <jmckenna at gatewaygeomatics.com> wrote:

> Martin Daly wrote:
>> All,
>> Any objections to me adding a single additional int4 column to each of the PostGIS tables, for a best effort?
>> I'd be happy to copy the tables instead if there is space.
> No objection, go for it.
> -jeff
> _______________________________________________
> Benchmarking mailing list
> Benchmarking at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/benchmarking

More information about the Benchmarking mailing list