thomasrebele commented on code in PR #6825: URL: https://github.com/apache/hive/pull/6825#discussion_r4216804583
########## standalone-metastore/metastore-server/docker/hive-postgres-tpcds-metastore/Dockerfile: ########## @@ -14,9 +14,19 @@ # See the License for the specific language governing permissions and # limitations under the License. # -FROM postgres:12.3 +FROM postgres:18-alpine + +RUN wget -O /tmp/metastore_db.zstd https://github.com/thomasrebele/hive-postgres-metastore/releases/download/tpcds-30tb-histogram-1.1/metastore_tpcds30tb_with_histograms.raw_db.zstd \ + && echo 'bc9e206d5f963a14451dad6f499ab069800be9ce /tmp/metastore_db.zstd' > /tmp/metastore_db.sha1 \ + && sha1sum -c /tmp/metastore_db.sha1 \ + && chown postgres:postgres /tmp/metastore_db.zstd + +COPY entrypoint.sh /usr/local/bin/entrypoint.sh +RUN chmod u+x /usr/local/bin/entrypoint.sh +COPY postgresql.conf /etc/postgresql/postgresql.conf +RUN chown postgres:postgres /etc/postgresql/postgresql.conf + +ENTRYPOINT ["/usr/local/bin/entrypoint.sh"] + +CMD ["postgres", "-c", "config_file=/etc/postgresql/postgresql.conf"] Review Comment: Thank you for pointing this out! That explains why changing the `work_mem` parameter in the postgresql.conf file had almost no effect on the runtime of TestTezTPCDS30TBPerfCliDriver. I'll have another try changing that parameter to see whether it improves test performance. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
