Re: [PATCHES] [HACKERS] [COMMITTERS] pgsql: /contrib/cube improvements:

2006-07-27 Thread Rocco Altier
There is also an issue with PPC processors with +/-0 in the cube test: *** ./expected/cube.out Thu Jul 27 05:23:14 2006 --- ./results/cube.out Thu Jul 27 05:43:21 2006 *** *** 144,150 SELECT '-1e-700'::cube AS cube; cube -- ! (0) (1 row) SELECT

Re: [PATCHES] [PATCH] Improve EXPLAIN ANALYZE overhead by sampling

2006-05-09 Thread Rocco Altier
- To get this close it needs to get an estimate of the sampling overhead. It does this by a little calibration loop that is run once per backend. If you don't do this, you end up assuming all tuples take the same time as tuples with the overhead, resulting in nodes apparently taking longer

Re: [PATCHES] [HACKERS] pgxs/windows

2006-01-19 Thread Rocco Altier
If I understand correctly, atleast for the AIX case, the reason that Makefile.aix is referencing DESTDIR is for the PGXS case. I thought that PGXS was supposed to be able to be run after things were installed, and you might not have the compile tree anymore. Basically, if you wanted to build

Re: [PATCHES] AIX - pgport/contrib resolution

2005-07-28 Thread Rocco Altier
, 2005 9:53 AM To: Tom Lane Cc: Rocco Altier; pgsql-patches@postgresql.org Subject: Re: [PATCHES] AIX - pgport/contrib resolution Tom Lane wrote: Pushed these in too ... hope to see a green board on the AIX buildfarm machines soon. That's what we have. Good work

[PATCHES] AIX - pgport/contrib resolution

2005-07-27 Thread Rocco Altier
The comment in regress/GNUmakefile about the pgport symbols not being found got me thinking about why that might be the case. I finally noticed that when we are building the postgres.imp file, we are not pulling in the pgport symbols, since they are not being linked into the local SUBSYS.o before

Re: [PATCHES] Proposed patch to remove .so pattern rules from platform Makefiles

2005-07-26 Thread Rocco Altier
Please disregard this patch. I have a ton of lib%.exp and similar files created currently. I am working on a new patch to deal with the MODULES expansion correctly. Thanks, -rocco -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rocco Altier

Re: [PATCHES] Proposed patch to remove .so pattern rules from platform Makefiles

2005-07-26 Thread Rocco Altier
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Rocco Altier [EMAIL PROTECTED] writes: Please disregard this patch. I have a ton of lib%.exp and similar files created currently. Yeah, that was one of the reasons I called it ugly :-(. I had put in an rm step

Re: [PATCHES] Proposed patch to remove .so pattern rules from platform Makefiles

2005-07-25 Thread Rocco Altier
The patch works on AIX with one small tweak to Makefile.shlib (attached). This is needed because of the clever trick with using % as name, and when its evaulated for the mkldexport. Also, it appears that the changes for regress/GNUmakefile are already applied. I am able to build everything and

Re: [PATCHES] Regression - GNUmakefile - pg_usleep

2005-07-25 Thread Rocco Altier
. Thanks -rocco (desperate to get AIX green on buildfarm) -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Sunday, July 24, 2005 7:34 PM To: Rocco Altier Cc: Patches (PostgreSQL) Subject: Re: [PATCHES] Regression - GNUmakefile - pg_usleep Rocco Altier

Re: [PATCHES] fix integer datetime division rounding error

2005-07-24 Thread Rocco Altier
This fixes the problem for me. Thanks, -rocco -Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: Sunday, July 24, 2005 12:37 AM To: Andrew Dunstan Cc: Patches (PostgreSQL); Rocco Altier Subject: Re: [PATCHES] fix integer datetime division rounding error

Re: [PATCHES] Regression - GNUmakefile - pg_usleep

2005-07-24 Thread Rocco Altier
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane Sent: Sunday, July 24, 2005 10:47 AM To: Rocco Altier Cc: Patches (PostgreSQL) Subject: Re: [PATCHES] Regression - GNUmakefile - pg_usleep Rocco Altier [EMAIL PROTECTED] writes

Re: [PATCHES] Regression - GNUmakefile - pg_usleep

2005-07-24 Thread Rocco Altier
This time I actually have the patches :-) -rocco -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rocco Altier Sent: Sunday, July 24, 2005 1:15 PM To: Tom Lane Cc: Patches (PostgreSQL) Subject: Re: [PATCHES] Regression - GNUmakefile

Re: [PATCHES] [HACKERS] regressin failure on latest CVS

2005-07-23 Thread Rocco Altier
, July 23, 2005 10:54 AM To: Rocco Altier Cc: Michael Glaesemann; pgsql-patches@postgresql.org; pgsql-hackers@postgresql.org; ohp@pyrenet.fr Subject: Re: [HACKERS] regressin failure on latest CVS Rocco Altier wrote: This patch fixes the interval regression on my AIX box (kookaburra

Re: [PATCHES] [HACKERS] regressin failure on latest CVS

2005-07-23 Thread Rocco Altier
: Saturday, July 23, 2005 2:51 PM To: Rocco Altier Cc: Michael Glaesemann; pgsql-patches@postgresql.org; ohp@pyrenet.fr Subject: Re: [HACKERS] regressin failure on latest CVS Would you please try the attached patch and let me know if it fixes the problem? I avoided accumulating

[PATCHES] Regression - GNUmakefile - pg_usleep

2005-07-23 Thread Rocco Altier
Attached patch fixes the SHLIB_LINK to add pgport now that pg_usleep is added. This is needed for AIX to resolve symbols at compile time. This is also to be used in conjuction with the other patch I have pending for Makefile.aix to SHLIB_LINK instead of LIBS to compile shared objects. Thanks,

Re: [PATCHES] Changes for AIX buildfarm

2005-07-21 Thread Rocco Altier
the link rules from Makefile.shlib. -rocco -Original Message- From: Peter Eisentraut [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 20, 2005 2:12 PM To: Rocco Altier Cc: pgsql-patches@postgresql.org; Tom Lane; Andrew Dunstan; Zeugswetter Andreas DAZ SD Subject: Re

Re: [PATCHES] [COMMITTERS] pgsql: Add 'day' field to INTERVAL so 1 day interval

2005-07-20 Thread Rocco Altier
This is also broken for make check with --enable-integer-datetimes on kookaburra (AIX). It looks like the other members of buildfarm that fail on contrib aren't using integer datetimes. -rocco -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of

[PATCHES] Changes for AIX buildfarm

2005-07-18 Thread Rocco Altier
Need to have these patches applied to get AIX 5.2 to build as a member of the buildfarm. The Makefile.shlib patch allows all the contrib modules to build (this seems to be the same problem that cygwin is facing). AIX needs -lm (to pick up math routines for atleast cube module). I am not sure

Re: [PATCHES] Changes for AIX buildfarm

2005-07-18 Thread Rocco Altier
-rocco -Original Message- From: Andrew Dunstan [mailto:[EMAIL PROTECTED] Sent: Monday, July 18, 2005 12:42 PM To: Tom Lane Cc: Rocco Altier; pgsql-patches@postgresql.org Subject: Re: [PATCHES] Changes for AIX buildfarm Tom Lane wrote: Rocco Altier [EMAIL PROTECTED

Re: [PATCHES] Changes for AIX buildfarm

2005-07-18 Thread Rocco Altier
] Sent: Monday, July 18, 2005 12:47 PM To: Andrew Dunstan Cc: Rocco Altier; Zeugswetter Andreas DAZ SD; pgsql-patches@postgresql.org Subject: Re: [PATCHES] Changes for AIX buildfarm Andrew Dunstan [EMAIL PROTECTED] writes: Tom Lane wrote: Er, which buildfarm report is prompting

Re: [PATCHES] Changes for AIX buildfarm

2005-07-18 Thread Rocco Altier
), but that userlocks is using MODULES which is working correctly. I will dig further and come up with another patch. -rocco -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Monday, July 18, 2005 12:47 PM To: Andrew Dunstan Cc: Rocco Altier; Zeugswetter Andreas DAZ SD