[postgis-devel] pgsql2shp dump optimization and change

[strk at refractions.net]

On Tue, Sep 21, 2004 at 11:11:14PM +1200, Jeremy Palmer wrote:
> That's strange, are you running the queries directly after one another on
> the same client connect?

yes

> 
> When I run a test queries I get this:
> 
> Table with 5062 records
> Group by 1101ms 
> Distinct select 1352ms
> 
> Table with 268294 records
> Group by 5718ms 
> Distinct select 11857ms
> 
> I'm using PostgreSQL 7.42 with default configuration.

I'm using PostgreSQL 7.3.
Try asking on the pgsql-users or pgsql-hackers mailing list
and let me know..

> Thanks for the message about views I tried it a while back and got seg
> faults, however it does not happen any more.
> 
> Jeremy
> 

--strk;