Postgres Pro
Downloads
Home   >   mailing lists

Re: is it possible to create partitioned tables using tables fromdifferent schemas - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: is it possible to create partitioned tables using tables fromdifferent schemas
Date
Msg-id 20190417225648.GA2004@alvherre.pgsql
Whole thread Raw
In response to is it possible to create partitioned tables using tables fromdifferent schemas  (pabloa98 <pabloa98@gmail.com>)
Responses Re: is it possible to create partitioned tables using tables fromdifferent schemas  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: is it possible to create partitioned tables using tables fromdifferent schemas  (David Rowley <david.rowley@2ndquadrant.com>)
List pgsql-general
Tree view 
Note that unless you regularly query for only-manually-inserted or
only-automatically-inserted data, this will be useless and will make
queries more expensive, with no upside.

Generally speaking, it's not a problem to put partitions in different
schemas.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-general by date:

Previous
From: pabloa98
Date:
Subject: Re: is it possible to create partitioned tables using tables fromdifferent schemas
Next
From: Adrian Klaver
Date:
Subject: Re: is it possible to create partitioned tables using tables fromdifferent schemas