Re: [PERFORM] Query slows after offset of 100K

2008-02-14 Thread Michael Lorenz
uld I just force the user to limit their result set to some given number of records before allowing any paginated access? Or is it just not practical, period? Thanks, Michael Lorenz > To: [EMAIL PROTECTED] > CC: pgsql-performance@postgresql.o

[PERFORM] Query slows after offset of 100K

2008-02-14 Thread Michael Lorenz
n, then I can get the extra changes made. I'm running a quad core 2.33GHz Xeon with 4GB memory (1.2GB free), using Postgres 8.1.11. Thanks, Michael Lorenz _ It's simple! Sell your car for just $30 at CarPoint.com.au ht