Re: Index Anding

Поиск
Список
Период
Сортировка
От Hiltibidal, Robert
Тема Re: Index Anding
Дата
Msg-id A6C93EF9812C8346A8E8BD6AE573E52D055B9728@ARG-EXVS01.corp.argushealth.com
обсуждение исходный текст
Ответ на Index Anding  ("Hiltibidal, Robert" <Robert.Hiltibidal@argushealth.com>)
Список pgsql-sql
I will investigate this.

Our gcc is only able to compile 32 bit. I think I will have to see if I
can get/compile a 64 bit gcc

I appreciate the help!

-R

-----Original Message-----
From: pgsql-sql-owner@postgresql.org
[mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Chris Browne
Sent: Thursday, February 01, 2007 4:45 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] Index Anding

ajs@crankycanuck.ca (Andrew Sullivan) writes:
>> Does postgres provide 64 bit support? If so is there a precompiled 64
>> bit version for AIX? I have the 32 bit GCC and can compile 32 bit. 64
>> bit GCC I have not gotten stabilized. (I cold use a tip in that
>> direction if anyone lese has experienced similar issues)
>
> I know we've managed to get it to work using gcc, but I haven't had
> to do it in a while (ask on -general or -admin, I suggest).  More
> important is to make sure you tell the compiler to use all the
> memory.  For reasons that are completely beyond my ken, AIX imposes
> a memory limitation on every program at compile time.  There are
> some hints about this in the FAQ_AIX.

Here's the environment data submitted to ./configure for a recent build
of 8.1.5:
pgdba@ydb1 $ ./pg_config --configure '--prefix=/where/I/stow/it
'--enable-thread-safety' '--enable-debug'
'--with-libraries=/opt/freeware/lib'
'--with-includes=/opt/freeware/include' 'CC=gcc -maix64'
'LDFLAGS=-Wl,-bmaxdata:0x80000000,-bbigtoc'

Note that you also need to export:
export OBJECT_MODE=64

And you need to make sure that you are using the AIX ld, and not GNU
ld...

For version 7.4, it was considerably fiddlier to do a build.  For 8.2,
it is neither overly baroque nor overly unpleasant, which I consider a
direct result of the combination of Seneca Cunningham's reports to
-hackers/-ports as well as BuildFarm runs...
--
(reverse (concatenate 'string "ofni.sesabatadxunil" "@" "enworbbc"))
http://cbbrowne.com/info/finances.html
Rules  of the  Evil  Overlord #30.   "All  bumbling conjurers,  clumsy
squires, no-talent  bards, and  cowardly thieves in  the land  will be
preemptively put  to death.  My foes  will surely give  up and abandon
their quest if they have no source of comic relief."
<http://www.eviloverlord.com/>

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
              http://www.postgresql.org/docs/faq


PRIVILEGED AND CONFIDENTIAL
This email transmission contains privileged and confidential information intended only for the use of the individual or
entitynamed above.  If the reader of the email is not the intended recipient or the employee or agent responsible for
deliveringit to the intended recipient, you are hereby notified that any use, dissemination or copying of this email
transmissionis strictly prohibited by the sender.  If you have received this transmission in error, please delete the
emailand immediately notify the sender via the email return address or mailto:postmaster@argushealth.com.  Thank you. 






В списке pgsql-sql по дате отправления:

Предыдущее
От: Wei ZOU
Дата:
Сообщение: Search a range of cases/records
Следующее
От: "Shyju Narayanan"
Дата:
Сообщение: sql