Re: Implementing postgres database timeouts

2009-02-04 Thread RahulDave
ng into the iterator protocol used by django and why it calls __len__ but perhaps someone more familiar with the workings of query.py could point me in the right direction? Rahul On Feb 3, 10:39 pm, Malcolm Tredinnick <malc...@pointy-stick.com> wrote: > On Tue, 2009-02-03 at 07:03 -0800,

Re: Implementing postgres database timeouts

2009-02-03 Thread RahulDave
Thanks for the reply! On Feb 3, 1:25 am, Malcolm Tredinnick wrote: > > > My first question is , how could I wrap eachdjangoquery in such a > > set of stataemtns. I could figure that its the web ui from a custom > > header or user agent and set this , but its not

Re: Implementing postgres database timeouts

2009-02-02 Thread RahulDave
ct_id", "maindb_lcot"."band_id", "maindb_lcot"."when", "maindb_lcot"."whenend", "maindb_lcot"."created_at", "maindb_lcot"."updated_at" FROM "maindb_lcot" So you can see a ProgrammingEr

Implementing postgres database timeouts

2009-02-02 Thread RahulDave
Hi Folks, I have a django astronomy application which fronts a 73 million row main table and 150 million row secondary table database, highly indexed of-course. The back-end database is postgres. The application itself is two-fold, a web services backend which can tolerate extremely long queries