Re: [PERFORM] What is best way to stream terabytes of data into postgresql?

2005-07-21 Thread Josh Berkus
Jeff, > Streaming being the operative word. Not sure how much hacking you want to do, but the TelegraphCQ project is based on PostgreSQL: http://telegraph.cs.berkeley.edu/telegraphcq/v0.2/ -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadca

Re: [PERFORM] What is best way to stream terabytes of data into

2005-07-21 Thread Frank Wosczyna
> Subject: [PERFORM] What is best way to stream terabytes of > data into postgresql? > > Preferably via JDBC, but by C/C++ if necessary. > > Streaming being the operative word. > > Tips appreciated. > Hi, We granted our Java Loader to the Bizgres Open Source, http://www.bizgres.org/asset

Re: [PERFORM] Optimizer seems to be way off, why?

2005-07-21 Thread Greg Stark
John A Meinel <[EMAIL PROTECTED]> writes: > Now if you created the index on b(r,c), then it would have a much better > idea of how selective that would be. At the very least, it could index > on (r,c) rather than indexing on (r) and filtering by (c). There has been some discussion of adding func

[PERFORM] What is best way to stream terabytes of data into postgresql?

2005-07-21 Thread Jeffrey Tenny
Preferably via JDBC, but by C/C++ if necessary. Streaming being the operative word. Tips appreciated. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster