Questions about TW

This message was edited 2 times. Last update was at 07/10/2008 02:19:09

Hi,

I got couple of questions.

First, Our Servers are located behind the firewall(private network) and WAN connections are restricted. In this case, Can I use TW?

Second, Can I set the database's characteristic? for e.g., 'OLTP', 'OLAP(DW)' or 'Hybrid'.

Thanks.

-YW KIM

My apologies for not replying sooner - I failed to enable monitoring of this forum and thus missed your post.

youngwoo_k wrote:Hi,

I got couple of questions.

First, Our Servers are located behind the firewall(private network) and WAN connections are restricted. In this case, Can I use TW?

Unfortunately no. The tuning wizard uses a web service to perform the tuning which is based on the DynaTune technology in our commercial product. We use the web service so we can improve the algorithms used without requiring updates to be downloaded whereever possible.

youngwoo_k wrote:
Second, Can I set the database's characteristic? for e.g., 'OLTP', 'OLAP(DW)' or 'Hybrid'.

The tuning wizard allows you to select a workload type, but PostgreSQL doesn't. The wizard takes your workload choice, and in conjunction with various metrics from your machine, figures out appropriate settings for various PostgreSQL configuration options.

Regards, Dave.