<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>RE: [postgis-users] RE: Slow vacuuming</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Perhaps a problem with autovacuum settings ? Could you post your config file, esp. stuff having to do with fsm, WAL (never know), autovacuum and checkpoint settings, that might help, along with OS and RAM.<BR>
<BR>
Do you have output from vmstat or some other utility that might show if you are CPU or IO bound ?<BR>
<BR>
No real ideas, just hunting for clues ...<BR>
<BR>
Greg W.<BR>
<BR>
-----Original Message-----<BR>
From: postgis-users-bounces@postgis.refractions.net on behalf of Paragon<BR>
Sent: Thu 4/10/2008 7:11 PM<BR>
To: postgis-users@postgis.refractions.net<BR>
Subject: [postgis-users] RE: Slow vacuuming<BR>
<BR>
Forgot to add I'm running the following<BR>
<BR>
POSTGIS="1.3.3SVN" GEOS="3.0.0-CAPI-1.4.1" PROJ="Rel. 4.5.0, 22 Oct 2006"<BR>
USE_STATS<BR>
<BR>
(the SVN is probably from about a week ago. I haven't reloaded the latest<BR>
SVN yet)<BR>
Thanks,<BR>
Regina<BR>
<BR>
-----Original Message-----<BR>
From: Paragon [<A HREF="mailto:lr@pcorp.us">mailto:lr@pcorp.us</A>]<BR>
Sent: Thursday, April 10, 2008 10:00 PM<BR>
To: 'postgis-users@postgis.refractions.net'<BR>
Subject: Slow vacuuming<BR>
<BR>
Has anyone noticed an issue in 8.3 with vacuuming or clustering on<BR>
geometries. I remember there was an issue with running PostgreSQL on Xeon<BR>
processors - is that still a problem?<BR>
<BR>
I've been loading tiger data and for large states like Florida and<BR>
California, my process seems to be hanging a lot vacuuming and some on<BR>
clustering of the geometries. I'm beginning to point the finger at my<BR>
clustered geometries (but I'm performing experiments now to see if I can<BR>
rule it out).<BR>
<BR>
At first I blamed the box, but now they beefed it up to a 2 processor Quad<BR>
Core and added 4 gig and I upped some settings. I'm not sure. This seemed<BR>
to be faster on the old server I was on (which was considerably slower and<BR>
running 8.2) , but then too many variables have changed. E.g. the old was<BR>
regular non-xeon processors. <BR>
<BR>
Anyrate too many variables have changed between the 2 -e.g. before I was<BR>
running with Tiger 2006SE loading via Ogr and now I'm loading shape via<BR>
shp2pgsql Tiger2007FE and they've change the whole structure anyway. All I<BR>
know is that for some reason my<BR>
<BR>
Vacuum analyze on my florida edges table<BR>
<BR>
never seems to complete.<BR>
<BR>
This may not be an issue but could be just something stupid with my<BR>
configuration - like my box happens to be 32-bit instead of 64-bit which<BR>
frustrates me. RedHat Linux EL 5 is a new experience to me anyway.<BR>
<BR>
Thanks,<BR>
Regina<BR>
<BR>
<BR>
<BR>
_______________________________________________<BR>
postgis-users mailing list<BR>
postgis-users@postgis.refractions.net<BR>
<A HREF="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>