Re: psql large RSS (1.6GB)
Josh Berkus <josh@agliodbs.com>
From: Josh Berkus <josh@agliodbs.com>
To: pgsql-performance@postgresql.org
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Bruce Momjian <pgman@candle.pha.pa.us>, Gavin Sherry <swm@alcove.com.au>, Dustin Sallings <dustin@spy.net>, TTK Ciar <ttk2@hardpoint.ciar.org>
Date: 2004-11-01T18:49:06Z
Lists: pgsql-performance
Tom, > Far more useful would be some sort of streaming API to let the > application process the rows as they arrive, or at least fetch the rows > in small batches (the V3 protocol supports the latter even without any > explicit use of a cursor). I'm not sure if this can be bolted onto the > existing libpq framework reasonably, but that's the direction I'd prefer > to go in. I think that TelegraphCQ incorporates this. However, I'm not sure whether it's a portable component; it may be too tied in to their streaming query engine. They have talked about porting their "background query" patch for PSQL, though ... -- Josh Berkus Aglio Database Solutions San Francisco