Linking a surface to a table which is, in turn, linked to a Postgres table takes about 1,000 seconds to refresh. (estimated time but it appears to be refreshing at a rate of 1,000 records per second)

(EDIT: Table has 1,000,000 records for a 1000 x 1000 surface)

Linking the same way to a table in an MDB file with the same data refreshes completely in 11 seconds.

The tables themselves refresh quickly in both cases. It is the "Importing record" step of the surface "refresh" that takes forever with Postgres.

Any suggestions on what is happening?

I have renamed both extents() and st_extents() in Postgres

A second oddity, if I put a Query into the Postgres situation (i.e. Postgres table > linked Manifold table > Manifold Query > linked Manifold surface) there is no difference initially but if I add a WHERE clause into the Query the refresh speed increases to about 3,000 records per second (e.g. WHERE [X] < 1000 AND [Y] < 1000)

The DB table only contains X, Y, Height

I'm using Postgresql 8.3.7 and Manifold 8.0.12 on 32-bit Win XP Pro SP3

Hi there

I'm not of a great help here but I guess the dataset is smaller by writing < 1000 instead of <= 1000.

or <1001..