> All of the types you list were designed around the MS SQL/MSDE server
> architecture, and many do not apply to PostgreSQL (for
> example, Postgres does not use read locks and does not support
> client-side keyset cursors as far as I know).
Thanks, this backs up my feelings from some of my limited experiments
I guess I need to keep trying to rewrite my queries to avoid nested
loops then, as this seems to be the main performance hit I get as all
use indexes properly.
Robert John Shepherd.
The UK's BIGGEST Online DVD Magazine
For a copy of my Public PGP key, email: pgp(at)robertsworld(dot)org(dot)uk
In response to
pgsql-performance by date
|Next:||From: mallah||Date: 2003-04-29 15:48:57|
|Subject: Re: Is 292 inserts/sec acceptable performance ?|
|Previous:||From: Josh Berkus||Date: 2003-04-29 15:38:50|
|Subject: Re: Best ODBC cursor and lock types for fastest reading?|