Re: [Wonder-disc] ERPrototypes Date Postgres

[Chuck H. <ch...@gl...>]

Thanks for this.

Chuck


On Apr 28, 2011, at 8:43 AM, John Huss wrote:

> On Thu, Apr 28, 2011 at 10:26 AM, Chuck Hill <ch...@gl...> wrote:
>> I'm SO glad I switched from FrontBase to PostgreSQL.  It's a bit harder to set up and configure, but it's worth it.
> 
> What do you find is better with PostgreSQL?
> 
> Our primary app is probably not a typical WO app.  It is used almost solely for reporting -- aggregating lots of data over date ranges.  At the time of the switch the largest DB was about 100GB and growing at a steady rate.  FrontBase just became unusable.  I took 6-8 hours to add a column to the largest table and usually the DB would crash before completion.  Performance was just as bad evening deleting a column or creating an index.  So the primary driver was the complete inability to make metadata changes on a large DB.  Using PostgreSQL, most metdata changes complete in less than 30 seconds.
> 
> But I also find the performance for ad-hoc complex queries that I have to run to be far better on PostgreSQL.  And I like some of the language features it has (which I can use for ad-hoc queries) like date_trunc, case statements, derived tables (select from select...) , the pgsql language for functions, etc.
> 
> PostgreSQL has much larger community and better documentation and the development of the software is continuing at a steady pace.  It's open source, so it will remain free forever.
> 
> John

-- 
Chuck Hill             Senior Consultant / VP Development

Come to WOWODC this July for unparalleled WO learning opportunities and real peer to peer problem solving!  Network, socialize, and enjoy a great cosmopolitan city.  See you there!  http://www.wocommunity.org/wowodc11/