Is there anything I can do to prevent the API from attempting to put the entire query result in memory?Use a cursor, and fetch chunks of the result set one at a time. http://www.postgresql.org/docs/current/interactive/sql-declare.html -- Joshua Tolley / eggyknap End Point Corporation
[root@medo etc]# ../bin/indexer --all
Sphinx 0.9.9-release (r2117)
Copyright (c) 2001-2009, Andrew Aksyonoff
using config file '/usr/local/etc/sphinx.conf'...
indexing index 'test1'...
collected 12757000 docs, 21313.6 MB
-- Mladen Gogala Sr. Oracle DBA 1500 Broadway New York, NY 10036 (212) 329-5251 www.vmsinfo.com