Re: [PATCHES] Tablespace for temporary objects and sort files

2007-01-09 Thread Albert Cervera Areny
I don't have much time lately so if you're willing to work on it, please do. A Dimarts 09 Gener 2007 02:51, Jaime Casanova va escriure: On 1/8/07, Jaime Casanova [EMAIL PROTECTED] wrote: maybe once this patch is applied you can think on make indexes and [temp] sequences on temp tables use

Re: [PATCHES] Tablespace for temporary objects and sort files

2007-01-09 Thread Jaime Casanova
On 1/9/07, Albert Cervera Areny [EMAIL PROTECTED] wrote: I don't have much time lately so if you're willing to work on it, please do. after doing the index part i revisited the patch again and saw that there is something fundamentally wrong here (sorry for no noticing that before :( ) your

Re: [PATCHES] Tablespace for temporary objects and sort files

2007-01-08 Thread Jaime Casanova
On 1/8/07, Jaime Casanova [EMAIL PROTECTED] wrote: maybe once this patch is applied you can think on make indexes and [temp] sequences on temp tables use the same temp_tablespace that table is using... actually, the index part is easy... do you want to do it? -- regards, Jaime Casanova

Re: [PATCHES] Tablespace for temporary objects and sort files

2007-01-05 Thread Albert Cervera Areny
Here's a new version that takes into account the SELECT INTO TEMP case. Thanks Jaime! What other temporary objects do you think should be considered? Any other comments on the patch? A Dijous 04 Gener 2007 05:33, Jaime Casanova va escriure: On 12/27/06, Albert Cervera Areny [EMAIL PROTECTED]

Re: [PATCHES] Tablespace for temporary objects and sort files

2007-01-03 Thread Jaime Casanova
On 12/27/06, Albert Cervera Areny [EMAIL PROTECTED] wrote: Hi, here's a new version of the patch against HEAD with both, table and sort files working correctly for me. Regression tests work too. I'd like to ask again the question I made on the first post as no answer was given at

Re: [PATCHES] Tablespace for temporary objects and sort files

2006-12-28 Thread Jaime Casanova
On 12/27/06, Albert Cervera Areny [EMAIL PROTECTED] wrote: Hi, here's a new version of the patch against HEAD with both, table and sort files working correctly for me. Regression tests work too. ok, i will test it a little ... what about temp tables created by SELECT INTO TEMP? look at

Re: [PATCHES] Tablespace for temporary objects and sort files

2006-12-24 Thread Jaime Casanova
On 12/24/06, Albert Cervera Areny [EMAIL PROTECTED] wrote: Hi, yes I'm working on it. I've got a more recent version that doesn't crash on initdb and works with sort files. I've got a couple of things pending and will post it as soon as I can. If you want I could make a diff and send it

Re: [PATCHES] Tablespace for temporary objects and sort files

2006-12-21 Thread Jaime Casanova
On 10/24/06, Albert Cervera Areny [EMAIL PROTECTED] wrote: Hi, I'm trying to introduce myself into postgresql development and I'm working on the tablespace for temporary objects and sort files TODO item. The attached patch shows what I've already done. The GUC is currently called

Re: [PATCHES] Tablespace for temporary objects and sort files

2006-10-26 Thread Albert Cervera Areny
Sorry about the wrong diff format. Attached is the good one. A Dimecres 25 Octubre 2006 09:07, Neil Conway va escriure: On Wed, 2006-10-25 at 00:45 +0200, Albert Cervera Areny wrote: Hope the diff and idents are ok. Patches should be submitted in context diff (diff -c) format. -Neil

Re: [PATCHES] Tablespace for temporary objects and sort files

2006-10-26 Thread Bruce Momjian
This has been saved for the 8.3 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --- Albert Cervera Areny wrote: Sorry about the wrong diff format. Attached is the good one. A Dimecres 25 Octubre

Re: [PATCHES] Tablespace for temporary objects and sort files

2006-10-26 Thread Dave Page
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Momjian Sent: 26 October 2006 14:19 To: Albert Cervera Areny Cc: pgsql-patches@postgresql.org Subject: Re: [PATCHES] Tablespace for temporary objects and sort files This has been saved

Re: [PATCHES] Tablespace for temporary objects and sort files

2006-10-26 Thread Bruce Momjian
bruce wrote: Dave Page wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Momjian Sent: 26 October 2006 14:19 To: Albert Cervera Areny Cc: pgsql-patches@postgresql.org Subject: Re: [PATCHES] Tablespace for temporary

Re: [PATCHES] Tablespace for temporary objects and sort files

2006-10-26 Thread Dave Page
-Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: 26 October 2006 14:37 To: [EMAIL PROTECTED] Cc: Dave Page; Albert Cervera Areny; pgsql-patches@postgresql.org Subject: Re: [PATCHES] Tablespace for temporary objects and sort files bruce wrote: Dave Page

Re: [PATCHES] Tablespace for temporary objects and sort files

2006-10-26 Thread Bruce Momjian
Dave Page wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Momjian Sent: 26 October 2006 14:19 To: Albert Cervera Areny Cc: pgsql-patches@postgresql.org Subject: Re: [PATCHES] Tablespace for temporary objects and sort files

Re: [PATCHES] Tablespace for temporary objects and sort files

2006-10-26 Thread Jaime Casanova
On 10/25/06, Jaime Casanova [EMAIL PROTECTED] wrote: On 10/24/06, Albert Cervera Areny [EMAIL PROTECTED] wrote: I'm trying to introduce myself into postgresql development and I'm working on the tablespace for temporary objects and sort files TODO item. Now, PG_TEMP_FILES_DIR seems to add

Re: [PATCHES] Tablespace for temporary objects and sort files

2006-10-25 Thread Neil Conway
On Wed, 2006-10-25 at 00:45 +0200, Albert Cervera Areny wrote: Hope the diff and idents are ok. Patches should be submitted in context diff (diff -c) format. -Neil ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore

Re: [PATCHES] Tablespace for temporary objects and sort files

2006-10-25 Thread Jaime Casanova
On 10/24/06, Albert Cervera Areny [EMAIL PROTECTED] wrote: Hi, I'm trying to introduce myself into postgresql development and I'm working on the tablespace for temporary objects and sort files TODO item. some comments from a non-hacker: your patch isn't doing nothing at all for temporary