make default TABLESPACE belong to target table.

From: Amos Bird <amosbird(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: make default TABLESPACE belong to target table.
Date: 2016-11-25 07:48:31
Message-ID: 87y408f19s.fsf@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Dear pgsql community,

I've been using postgres for a long time. Recently I'm doing table
sharding over a bunch of pgsql instances. I'm using multiple tablespaces
one per disk to utilize all the IO bandwidth. Things went on pretty
well, however there is a troublesome problem I have when adding
auxiliary structures to sharded tables, such as Indexes. These objects
have their storage default to the database's tablespace, and it's
difficult to shard them by hand.

I'd like to implement this small feature --- making table's auxiliary
structures store their data to the target table's tablespace by default.
I've done a thorough search over the mailing list and there is nothing
relevant. Well I may miss some corners :-)

What do you think?

Regards,
Amos

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Laurenz Albe 2016-11-25 07:48:40 Re: Parallel execution and prepared statements
Previous Message Michael Paquier 2016-11-25 07:41:41 Re: Forbid use of LF and CR characters in database and role names