Re: [GENERAL] Postgresql - commercial version

2017-07-07 Thread Terry Schmitt
You have the open source version installed. Now where it was installed from is a different story. EnterpriseDB Advanced Server will look like: EnterpriseDB 9.5.5.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-16), 64-bit T On Fri, Jul 7, 2017 at 7:04 AM,

Re: [GENERAL] PG vs ElasticSearch for Logs

2016-08-23 Thread Terry Schmitt
Certainly Postgres is capable of handling this volume just fine. Throw in some partition rotation handling and you have a solution. If you want to play with something different, check out Graylog, which is backed by Elasticsearch. A bit more work to set up than a single Postgres table, but it has

Re: [GENERAL] Next steps in debugging database storage problems?

2014-08-15 Thread Terry Schmitt
I can't offer a whole lot of detail at this point, but I experienced a pretty bad caching issue about 2 years ago using XFS. We were migrating a 1TB+ Oracle database to EDB's Advanced server 9.1 (Close enough for this discussion). I normally use ext4, but decided to try XFS for this build-out.

Re: [GENERAL] question about readonly instances

2011-05-18 Thread Terry Schmitt
I have no idea what type of storage that you are using, but we utilize NetApp storage and use Flexclones to create multiple read-only copies of a master database. The flexclone takes seconds to configure and essentially only consume delta space. Works great so far. Terry On Wed, May 18, 2011 at