Hi all!
Alan Knight wrote:
> I've been seeing the public repository be significantly slower over
> the last several months. It used to be that it was significantly
> faster to get to the public store (which is in Cincinnati) than to
> the internal Cincom database in California. But the last while
> that's been reersed. I don't know what's responsible, if it's
> approaching limits on disk size, or on database capacity (it's on
> quite an old version of Postgresql), or if it's just being bogged
> down because of all the blogs and such on the same server/net.
> We've asked our sysadmin to look at upgrading the database version,
> but it's not been a top-priority task, and it's not at all sure
> that that would make a significant difference.
old PostgreSQL versions (ISTR less than 7.4, yes coincidentaly
similar to VW version number) have a problem with subselects
using "IN" clauses. These are heavily used by some store
operations. This bit us a while ago, when a repository grew
with a lot of versions. This has much approved, we are
currently running a 8.1 subversion.
Still, size does matter for query response times, so every couple
of years we start a new db and keep the old one for reference.
Regards
Jan
Locked
