Re: [HACKERS] PATCH: default_index_tablespace

2015-04-26 Thread Stephen Frost
J.L., * jltal...@adv-solutions.net (jltal...@adv-solutions.net) wrote: > Any suggestions on how to do it "properly"? > Does Greg Stark's suggestion (at > ) > make sense to you? > This approach might suffer from the same problem as mine, though. Well, Greg's suggestion was intended to specifically

Re: [HACKERS] PATCH: default_index_tablespace

2015-04-16 Thread jltallon
> > I'm afraid this idea is a nonstarter, because it will break existing > applications, and in particular existing pg_dump output files, which > expect to be able to determine an index's tablespace by setting > "default_tablespace". (It is *not* adequate that the code falls back > to "defaul

Re: [HACKERS] PATCH: default_index_tablespace

2015-04-16 Thread David Steele
On 4/15/15 11:33 PM, Amit Kapila wrote: > On Thu, Apr 16, 2015 at 8:01 AM, Bruce Momjian > wrote: >> >> On Wed, Apr 15, 2015 at 07:12:11PM -0400, Tom Lane wrote: >> > jltal...@adv-solutions.net writes: >> > > This small patch implements

Re: [HACKERS] PATCH: default_index_tablespace

2015-04-16 Thread Greg Stark
On 15 Apr 2015 19:12, "Tom Lane" wrote: > > I'm afraid this idea is a nonstarter, because it will break existing > applications, and in particular existing pg_dump output files, which > expect to be able to determine an index's tablespace by setting > "default_tablespace". (It is *not* adequate t

Re: [HACKERS] PATCH: default_index_tablespace

2015-04-15 Thread Amit Kapila
On Thu, Apr 16, 2015 at 8:01 AM, Bruce Momjian wrote: > > On Wed, Apr 15, 2015 at 07:12:11PM -0400, Tom Lane wrote: > > jltal...@adv-solutions.net writes: > > > This small patch implements a new GUC (default_index_tablespace) plus > > > supporting code. > > > Originated from a customer request, th

Re: [HACKERS] PATCH: default_index_tablespace

2015-04-15 Thread Stephen Frost
* Bruce Momjian (br...@momjian.us) wrote: > On Wed, Apr 15, 2015 at 07:12:11PM -0400, Tom Lane wrote: > > jltal...@adv-solutions.net writes: > > > This small patch implements a new GUC (default_index_tablespace) plus > > > supporting code. > > > Originated from a customer request, the feature inte

Re: [HACKERS] PATCH: default_index_tablespace

2015-04-15 Thread Bruce Momjian
On Wed, Apr 15, 2015 at 07:12:11PM -0400, Tom Lane wrote: > jltal...@adv-solutions.net writes: > > This small patch implements a new GUC (default_index_tablespace) plus > > supporting code. > > Originated from a customer request, the feature intends to make > > creation of indexes on SSD-backed t

Re: [HACKERS] PATCH: default_index_tablespace

2015-04-15 Thread Tom Lane
jltal...@adv-solutions.net writes: > This small patch implements a new GUC (default_index_tablespace) plus > supporting code. > Originated from a customer request, the feature intends to make > creation of indexes on SSD-backed tablespaces easy and convenient > (almost transparent) for users: th

[HACKERS] PATCH: default_index_tablespace

2015-04-15 Thread jltallon
Hi, This small patch implements a new GUC (default_index_tablespace) plus supporting code. Originated from a customer request, the feature intends to make creation of indexes on SSD-backed tablespaces easy and convenient (almost transparent) for users: the DBA can just set it and indexes will