Re: cannot get stable function to use index - Mailing list pgsql-general

From Andy Colson
Subject Re: cannot get stable function to use index
Date
Msg-id 56843C9C.1040307@squeakycode.net
Whole thread Raw
In response to Re: cannot get stable function to use index  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: cannot get stable function to use index  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 12/30/2015 2:18 PM, Tom Lane wrote:
> Andy Colson <andy@squeakycode.net> writes:
>> On 12/30/2015 1:55 PM, Tom Lane wrote:
>>> Are you using any nondefault planner settings?  Anything else
>>> unusual about your installation?
>
>> There are others, but I'll bet its:
>> random_page_cost = 1
>
> Nope...
>
> Maybe something weird about the build you're using?  What does
> pg_config print?
>
>             regards, tom lane
>

BINDIR = /usr/local/pg93/bin
DOCDIR = /usr/local/pg93/share/doc/postgresql
HTMLDIR = /usr/local/pg93/share/doc/postgresql
INCLUDEDIR = /usr/local/pg93/include
PKGINCLUDEDIR = /usr/local/pg93/include/postgresql
INCLUDEDIR-SERVER = /usr/local/pg93/include/postgresql/server
LIBDIR = /usr/local/pg93/lib
PKGLIBDIR = /usr/local/pg93/lib/postgresql
LOCALEDIR = /usr/local/pg93/share/locale
MANDIR = /usr/local/pg93/share/man
SHAREDIR = /usr/local/pg93/share/postgresql
SYSCONFDIR = /usr/local/pg93/etc/postgresql
PGXS = /usr/local/pg93/lib/postgresql/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--prefix=/usr/local/pg93' '--with-perl'
'--enable-thread-safety' '--build=x86_64-slackware-linux'
'build_alias=x86_64-slackware-linux' 'CFLAGS=-O2 -fPIC
-DLINUX_OOM_SCORE_ADJ=0'
CC = gcc
CPPFLAGS = -D_GNU_SOURCE
CFLAGS = -O2 -fPIC -DLINUX_OOM_SCORE_ADJ=0 -Wall -Wmissing-prototypes
-Wpointer-arith -Wdeclaration-after-statement -Wendif-labels
-Wmissing-format-attribute -Wformat-security -fno-strict-aliasing
-fwrapv -fexcess-precision=standard
CFLAGS_SL = -fpic
LDFLAGS = -L../../../src/common -Wl,--as-needed
-Wl,-rpath,'/usr/local/pg93/lib',--enable-new-dtags
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgport -lpgcommon -lz -lreadline -ltermcap -lcrypt -ldl -lm
VERSION = PostgreSQL 9.3.9




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: cannot get stable function to use index
Next
From: Tom Lane
Date:
Subject: Re: cannot get stable function to use index