[Benchmarking] PostGIS

[Paul Ramsey]

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.

P.

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