[postgis-users] Speed issues again

[Zamil Murji]

I don't know what happened but the speeds just got a lot faster. Sorry if I wasted anybodies time. I didn't even change anything and all of a sudden everything started working.

Thanks
Zamil

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of Zamil
Murji
Sent: Thursday, May 06, 2004 4:26 PM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] Speed issues again


I have also tried VACCUUM ANALYZE and dropping and recreating the indexes to no avail.

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of Zamil
Murji
Sent: Thursday, May 06, 2004 4:24 PM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] Speed issues again


Running top as user root and then refreshing the query page shows the following:

- nothing for approx. 2 seconds
- after two seconds this shows up in top:
10061 postgres  17   0  2628 2476  1836 R     7.7  0.4   0:00   0 postmaster
10059 nobody    21   0  2284 2284  1892 S     0.3  0.4   0:00   0 mapserv
- this stays up for approximately 2-3 seconds

Yes, I am running mapserver on the same machine as the database.
The same mapserver is used to hit two different databases: one for prod and one for dev.
When I run top as user root and then refresh the prod query (the fast one), I can't even switch windows fast enough to see the mapserv or postmaster processes.

Zamil

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of David
Blasby
Sent: Thursday, May 06, 2004 4:17 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Speed issues again


Are you running mapserver on the same machine as the database?

What does 'top' say its doing during the 5 seconds?

dave

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users