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

2007-01-14 Thread Jaime Casanova
On 1/13/07, Albert Cervera Areny [EMAIL PROTECTED] wrote: It was already possible to set the guc on postgresql.conf when I posted the patch... ok... fixed... the problem was that this code only let num_temp_tablespaces be greater than zero when we are in an interactive command (eg. a SET

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

2007-01-13 Thread Albert Cervera Areny
It was already possible to set the guc on postgresql.conf when I posted the patch... A Divendres 12 Gener 2007 07:28, Jaime Casanova va escriure: On 1/11/07, Joshua D. Drake [EMAIL PROTECTED] wrote: On Thu, 2007-01-11 at 21:05 -0500, Jaime Casanova wrote: On 1/11/07, Albert Cervera Areny

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

2007-01-11 Thread Albert Cervera Areny
Please, go on with that, I hadn't seen that problem. Indeed, I read Andrew answer to your question and I think it's a nice solution. A Dimecres 10 Gener 2007 05:33, Jaime Casanova va escriure: On 1/9/07, Albert Cervera Areny [EMAIL PROTECTED] wrote: I don't have much time lately so if you're

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

2007-01-11 Thread Jaime Casanova
On 1/11/07, Albert Cervera Areny [EMAIL PROTECTED] wrote: Please, go on with that, I hadn't seen that problem. Indeed, I read Andrew answer to your question and I think it's a nice solution. yes... i'm always trying to kill flies with tanks... ;) i will use Andrew's suggestion... -- regards,

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

2007-01-11 Thread Jaime Casanova
On 1/11/07, Joshua D. Drake [EMAIL PROTECTED] wrote: On Thu, 2007-01-11 at 21:05 -0500, Jaime Casanova wrote: On 1/11/07, Albert Cervera Areny [EMAIL PROTECTED] wrote: Please, go on with that, I hadn't seen that problem. Indeed, I read Andrew answer to your question and I think it's a nice

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

2007-01-11 Thread Jaime Casanova
Sorry, patch attached this time... On 1/12/07, Jaime Casanova [EMAIL PROTECTED] wrote: On 1/11/07, Joshua D. Drake [EMAIL PROTECTED] wrote: On Thu, 2007-01-11 at 21:05 -0500, Jaime Casanova wrote: On 1/11/07, Albert Cervera Areny [EMAIL PROTECTED] wrote: Please, go on with that, I hadn't

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-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

[PATCHES] Tablespace for temporary objects and sort files

2006-10-24 Thread Albert Cervera Areny
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 temp_tablespaces. The tablespace changes correctly for me when