On Fri, Aug 9, 2019 at 7:15 AM Tom Lane wrote:
> Harold Falkmeyer writes:
> > As an example of the seeming inconsistency, pg_class indicated that
> certain
> > tables and indexes were on reltablespace 0, which, as we understood,
> refers
> > to pg_default, which, coincidentally is listed with pg
Harold Falkmeyer writes:
> As an example of the seeming inconsistency, pg_class indicated that certain
> tables and indexes were on reltablespace 0, which, as we understood, refers
> to pg_default, which, coincidentally is listed with pg_tablespace with oid
> 1663. That same pg_class object is cl
Hello,
We operate a PostgreSQL 8.4.22 database on RHEL 6.10. Over the years,
we've attempted to intelligently distribute tables and indexes across
multiple tablespaces. After introducing a new tablespace, we attempted to
inventory which tables and indexes were on which tablespaces only to find
t
