"Ed L." <pgsql@bluepolka.net> writes:
> $ file `which psql`
> /opt/pgsql/postgresql-8.0.0beta1/bin/psql: ELF-32 executable object file
> - IA64
> This is the same for *many* of the executables in /bin. Does this mean it
> is a 32-bit executable?
Looks like it to me.
> Does it also, therefore, mean that is not taking
> advantage of the 64-bit hardware? If so, is there something special I need
> to pass to pgsql's configure to get it to build 64-bit executables to fully
> exploit this expensive hardware?
I wouldn't panic. 99% of the value of a 64-bit box for database work
is that you can handle more than 4Gb worth of RAM for disk cache. Since
in Postgres's worldview most of the disk caching is supposed to be done
by the kernel, it really matters not whether the Postgres executables
think they are 32-bit or 64-bit. All you need is a 64-bit kernel.
regards, tom lane