Re: cannot get stable function to use index
От | Andy Colson |
---|---|
Тема | Re: cannot get stable function to use index |
Дата | |
Msg-id | 56843C9C.1040307@squeakycode.net обсуждение исходный текст |
Ответ на | Re: cannot get stable function to use index (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: cannot get stable function to use index
|
Список | 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 по дате отправления: