temporary table space usage

From: ghiureai <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: temporary table space usage
Date: 2017-08-02 20:23:58
Message-ID: 598234DE.1000204@nrc-cnrc.gc.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi List
I would like to know if I need a dedicated temporary/"temp" table space
for a large wharehouse database > 500GB, how is PG sql optimizer using
internal temp table ( not the user tables/ session tables), in special
I am thinking about the PG 10 which comes with a improve usage of
parallelism when compiling SQL .

Isabella

Browse pgsql-admin by date

  From Date Subject
Next Message amandeep singh 2017-08-03 08:05:38 Re: Terminate connections using non-superuser
Previous Message Pankaj Arora 2017-08-02 18:12:55 PostgreSQL 9.3 Uninstall error - Windows 2012