Hello,
PG version 8.4.7 on AIX 6.1.
While creating a large multi-column index on a table of about 2.5 million rows,
I got the following error:
ERROR: out of memory
DETAIL: Failed on request of size 50331648.
I doubled the value of the "shared_buffers" parameter (from 512Mb to 1024Mb),
recycled the PG instance and then was able to run the "create index" statement
successfully.
Question: Does PG use a main memory sort algorithm for the creation of indexes?
Can it not make do with whatever memory is available and supplement it with
disk space (external sort)? I have a temporaray tablespace defined (with the
"temp_tablespaces") parameter. The disk area for this tablespace had about 2GB
of free space available. But the sort does not seem to have used it.
Thanks.
Alanoly Andrews.
****************************************************
This e-mail may be privileged and/or confidential, and the sender does not
waive any related rights and obligations. Any distribution, use or copying of
this e-mail or the information it contains by other than an intended recipient
is unauthorized. If you received this e-mail in error, please advise me (by
return e-mail or otherwise) immediately.
Ce courriel est confidentiel et protégé. L'expéditeur ne renonce pas aux droits
et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce
message ou des renseignements qu'il contient par une personne autre que le
(les) destinataire(s) désigné(s) est interdite. Si vous recevez ce courriel par
erreur, veuillez m'en aviser immédiatement, par retour de courriel ou par un
autre moyen.
****************************************************
