3 Replies Latest reply on Nov 15, 2011 8:30 AM by Robert Morton

    PostgreSQL Master/Slave and temporary tables

    Sekine Coulibaly

      Hi there,

       

      I'm in the process of looking for datawarehousing for 2/3 TB datawarehouse, and the more I think about it, the more I think about using vanilla PostgreSQL.

       

      Using a Master/Slave architecture with Postgres and PgPool might allow for horizontal scaling, but with a limitation : since writes only can be handled by the Master, this means that if Tableau uses temporary tables for a given request, then that request will only target master and will not take advantage of the master/slave architecture.

       

      Does Tableau need to write at any time, and in any kind in the datasource ?

       

      Thank you !