Re: PSORT_DBTEMP and DBSPACETEMP

ibogorad@lhr-sys.dhl.com wrote: : In article : <B5EA844F2DE58DEB.0A67072B0CAC1F49.38844D7C19E18CCC@library-proxy.airnews.net>, : Hari says... : > : >Hi, : > : > I am working on INFORMIX ONLINE Dynamic Server. I have come across a : >problem where when I do a sort using Sequential Scan it blows up during : >the weekends and sometimes during night time. ( SQL ERR:567 ISAM : >ERR:28). : > : > The PSORT_DBTEMP is pointing to the logical logs directory. When I : >change it to /tmp, the sort queries work. The manual says using : >PSORT_DBTEMP will definitely cause this problem. I outputted the disk : >space in the logical logs directory when the problem happened, and there : >was plenty of disk space. : > I am working on optimizing postgrSQL's psort function (www.postgresql.org), and found it curious that postgreSQL uses the same name, psort, for that piece of code as Informix. Do they come from a common code base (university Ingres?) or is psort some standard name for the code that sorts result rows? -- Bruce Momjian | 830 Blythe Avenue root@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h)