The following diff adds the NetBSD qsort() for all Solaris platforms.
If Sun ever fixes it, we will have to test version numbers somehow, but
for now, it is unconditionally used on Solaris for 7.3.
---------------------------------------------------------------------------
Andrew Sullivan wrote:
> On Tue, Jun 25, 2002 at 12:08:54PM +1200, Kurt at iadvance wrote:
> > Hi,
> >
> > Are there any actual times you can provide on operations on
> > some big tables (if you have any of around 10-100 Gb say) - just
> > 'select count(*)' kind of stuff, maybe a 'select *' where its doing a
> > sequential scan?
>
> Sorry, I intended to reply to this sooner. I went to perform such a
> test on 28 June, and (alas) the temporary license I had for Veritas
> had expired. So I couldn't run this. I'll have another opportunity,
> I believe, to run some tests in August, so I'll keep this on my TODO.
>
> A
>
> --
> ----
> Andrew Sullivan 87 Mowat Avenue
> Liberty RMS Toronto, Ontario Canada
> <andrew@libertyrms.info> M6K 3E3
> +1 416 646 3304 x110
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Index: configure
===================================================================
RCS file: /cvsroot/pgsql/configure,v
retrieving revision 1.201
diff -c -r1.201 configure
*** configure 18 Jul 2002 04:13:57 -0000 1.201
--- configure 19 Jul 2002 17:27:52 -0000
***************
*** 11902,11907 ****
--- 11902,11914 ----
esac
+ # Set path of qsort for solaris, which has a very slow qsort in certain cases.
+ QSORT=""
+ case $host_os in
+ solaris*) DLLINIT='$(top_builddir)/src/backend/port/qsort.o' ;;
+ esac
+
+
# On HPUX 9, rint() is not in regular libm.a but in /lib/pa1.1/libm.a;
# this hackery with HPUXMATHLIB allows us to cope.
HPUXMATHLIB=""
***************
*** 17584,17589 ****
--- 17591,17597 ----
s,@STRTOUL@,$STRTOUL,;t t
s,@STRCASECMP@,$STRCASECMP,;t t
s,@DLLINIT@,$DLLINIT,;t t
+ s,@QSORT@,$QSORT,;t t
s,@HPUXMATHLIB@,$HPUXMATHLIB,;t t
s,@HAVE_POSIX_SIGNALS@,$HAVE_POSIX_SIGNALS,;t t
s,@MSGFMT@,$MSGFMT,;t t
Index: configure.in
===================================================================
RCS file: /cvsroot/pgsql/configure.in,v
retrieving revision 1.192
diff -c -r1.192 configure.in
*** configure.in 18 Jul 2002 04:13:59 -0000 1.192
--- configure.in 19 Jul 2002 17:27:53 -0000
***************
*** 932,937 ****
--- 932,944 ----
esac
AC_SUBST(DLLINIT)
+ # Set path of qsort for solaris, which has a very slow qsort in certain cases.
+ QSORT=""
+ case $host_os in
+ solaris*) DLLINIT='$(top_builddir)/src/backend/port/qsort.o' ;;
+ esac
+ AC_SUBST(QSORT)
+
# On HPUX 9, rint() is not in regular libm.a but in /lib/pa1.1/libm.a;
# this hackery with HPUXMATHLIB allows us to cope.
HPUXMATHLIB=""
Index: src/Makefile.global.in
===================================================================
RCS file: /cvsroot/pgsql/src/Makefile.global.in,v
retrieving revision 1.150
diff -c -r1.150 Makefile.global.in
*** src/Makefile.global.in 18 Jul 2002 04:30:36 -0000 1.150
--- src/Makefile.global.in 19 Jul 2002 17:27:54 -0000
***************
*** 352,357 ****
--- 352,358 ----
ISINF = @ISINF@
MEMCMP = @MEMCMP@
MISSING_RANDOM = @MISSING_RANDOM@
+ QSORT = @QSORT@
SNPRINTF = @SNPRINTF@
SRANDOM = @SRANDOM@
STRCASECMP = @STRCASECMP@
***************
*** 360,366 ****
STRTOL = @STRTOL@
STRTOUL = @STRTOUL@
! # Used by the backend
DLLINIT = @DLLINIT@
TAS = @TAS@
--- 361,367 ----
STRTOL = @STRTOL@
STRTOUL = @STRTOUL@
! # Not really standard libc functions, used by the backend.
DLLINIT = @DLLINIT@
TAS = @TAS@
Index: src/backend/port/Makefile
===================================================================
RCS file: /cvsroot/pgsql/src/backend/port/Makefile,v
retrieving revision 1.16
diff -c -r1.16 Makefile
*** src/backend/port/Makefile 18 Jul 2002 04:13:59 -0000 1.16
--- src/backend/port/Makefile 19 Jul 2002 17:27:54 -0000
***************
*** 21,27 ****
top_builddir = ../../..
include $(top_builddir)/src/Makefile.global
! OBJS=dynloader.o pg_sema.o pg_shmem.o
OBJS+=$(DLLINIT)
--- 21,31 ----
top_builddir = ../../..
include $(top_builddir)/src/Makefile.global
! OBJS=$(GETHOSTNAME) $(GETRUSAGE) $(INET_ATON) $(ISINF) $(MEMCMP) \
! $(MISSING_RANDOM) $(QSORT) $(SNPRINTF) $(SRANDOM) $(STRCASECMP) \
! $(STRDUP) $(STRERROR) $(STRTOL) $(STRTOUL)
!
! OBJS+=dynloader.o pg_sema.o pg_shmem.o
OBJS+=$(DLLINIT)
Index: src/port/Makefile
===================================================================
RCS file: /cvsroot/pgsql/src/port/Makefile,v
retrieving revision 1.1
diff -c -r1.1 Makefile
*** src/port/Makefile 18 Jul 2002 04:13:59 -0000 1.1
--- src/port/Makefile 19 Jul 2002 17:27:57 -0000
***************
*** 15,23 ****
top_builddir = ../..
include $(top_builddir)/src/Makefile.global
- OBJS=$(GETHOSTNAME) $(GETRUSAGE) $(INET_ATON) $(ISINF) $(MEMCMP) \
- $(MISSING_RANDOM) $(SNPRINTF) $(SRANDOM) $(STRCASECMP) $(STRDUP) \
- $(STRERROR) $(STRTOL) $(STRTOUL)
! distclean clean:
! rm -f $(OBJS)
--- 15,23 ----
top_builddir = ../..
include $(top_builddir)/src/Makefile.global
! #
! # The backend/port directory removes these files.
! #
! #distclean clean:
! # rm -f $(OBJS)
