Re: [PERFORM] query slows under load

2004-01-25 Thread Stephan Szabo
On Fri, 23 Jan 2004, Jenny Zhang wrote: > 3. index with desc/asc is not supported in PG, why it is not needed? Is > there any work-around? You can do this with index operator classes. There aren't any automatically provided ones that do the reversed sort iirc, but I think that's come up before

[PERFORM] query slows under load

2004-01-23 Thread Jenny Zhang
Hi, Sorry for the long e-mail. Here is a summary of my questions: I am running osdl-dbt1 against pgsql-7.3.3. The result is at: http://khack.osdl.org/stp/286627/ 1. Based on the hardware and software configuration, does my database configuration make sense? 2. Is 'defining a cursor and fetch m