topic Re: Use SAS-provided PostgreSQL instance for my own data? in Administration and Deployment

Use SAS-provided PostgreSQL instance for my own data?

bheinsius — Tue, 22 Dec 2015 21:35:22 GMT

Hi,

I have SAS/ACCESS to PostgreSQL licensed.

I want to use PostgreSQL as a data store for my ETL jobstats.

I want this data store to reside on my compute server.

SAS provides a bundled instance of PostgreSQL, which it uses for the WIP database on that same compute tier.

I would like to hear opinions on whether to use the SAS-provided PostgreSQL instance for storing my own ETL jobstats data.

Or do you find I should install a separate instance of PostgreSQL for this data?

Thanks,

Bart

Re: Use SAS-provided PostgreSQL instance for my own data?

LinusH — Tue, 22 Dec 2015 21:39:47 GMT

My gut feeling (not fact based!) is to use a separate instance.

The bundled one is a part of the SAS product/configuration, and could in some future change with a new SAS release, a dependancy your might don't want.

Also, if you need to trouble shoot some SAS content behaviour, you don't need to rule out explicitly your own use of the same database.

Re: Use SAS-provided PostgreSQL instance for my own data?

JuanS_OCS — Wed, 06 Jan 2016 15:20:07 GMT

Hi,

I personally agree completely with LinusH. I would use a different instance as well.

The reason is that the WIP db it has a performance tuning (and encoding, usually just UTF-8) configured for the kind of data and transactions it is expected to be handled by the shared services, VA and so.

Given this scenario, as I want the SAS system to work as optimal as possible, I would not include external factors or change the performance settings.

In other hand, I would chose to optimize the performance, encoding and colate settings for my ETL data and transactions too. Therefore I would create a different instance, with better conditions for my ETLs.

I am feeling curious too about other perspectives.

Regards,

Juan

Re: Use SAS-provided PostgreSQL instance for my own data?

bheinsius — Wed, 06 Jan 2016 16:03:15 GMT

Thank you both.

i agree to use a separate instance.

regards Bart