[Xastir-Dev] Short list, stable release, then Xastir-2 development?

[Gerry Creager N5JXS]

I've seen some markedly slower performance with Postgres when tables get 
out of hand and indices are not, or improperly used.  And vacuum is a 
valuable tool for keeping a lot of the works in check.  Still, it does 
handle larger data sets a bit better than MySQL.

 From my perspective, the major draw for xastir is the spatial 
capability.  If we weren't talking about a spatial application from the 
start, MySQL _would_ be my choice because it's relational, SQL-based and 
lighter-weight.  That said, it's been my experience that the extra 
overhead associated with PostGres is not a show stopper and it offers us 
benefits today in the spatial arena.

And, just to give the short answer, I think we're in violent agreement!

73,
gerry

Jeff Brenton KA9VNV wrote:
> Hello Gerry,
> 
> GCN> Well, there are several. But first, Curt tells me that MySQL will
> GCN> soon include spatial elements, so that's not as high on the
> GCN> list...
> 
> Hopefully, another "feature" of Postgres will not be a problem with
> what's being discussed here. It seems on some databases, with lots of
> large inserts and deletes, Postgres can start eating disk space for
> seemingly no reason (there are reasons, but they aren't obvious).
> 
> This is a critical item for another project I'm involved in, which
> uses either Postgres or MySQL as the back end for mail servers.
> Postgres has several advantages that some people want (the triggers
> and stored procedures), but it comes with the cost of slower inserts
> and queries, AND the necessity of running VACUUM several times per day
> to keep the database sizes in check.
> 
> (VACUUM is a procedure for rebuilding various behind-the-scenes
> tables, from what I understand, and one outfit is running it every 30
> minutes on their 22,000-user system mail system.)
> 
> Again, this should NOT be a factor for Xastir...
> 


-- 
Gerry Creager -- gerry.creager at tamu.edu
Network Engineering -- AATLT, Texas A&M University	
Cell: 979.229.5301 Office: 979.458.4020 FAX: 979.847.8578
Page: 979.228.0173
Office: 903A Eller Bldg, TAMU, College Station, TX 77843