Postgres Pro
Downloads
Home   >   mailing lists

[ADMIN] temporary table space usage - Mailing list pgsql-admin

From ghiureai
Subject [ADMIN] temporary table space usage
Date
Msg-id 598234DE.1000204@nrc-cnrc.gc.ca
Whole thread Raw
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Pankaj Arora
Date:
Subject: [ADMIN] PostgreSQL 9.3 Uninstall error - Windows 2012
Next
From: amandeep singh
Date:
Subject: Re: [ADMIN] Terminate connections using non-superuser