> it was veery fast. To be honest I do not know what is happening?!
This is really weird.
It seems that PostgreSql OFFSET / LIMIT are not optimized and thus typical
SELECT ... FROM bigtable ORDER BY intprimarykey OFFSET pageno*100 LIMIT 100
or even first page query
SELECT ... FROM bigtable ORDER BY intprimarykey OFFSET 0 LIMIT 100
cannot be used in PostgreSql at all for big tables.
Do you have any idea how to fix this ?
In response to
pgsql-performance by date
|Next:||From: Kevin Kempter||Date: 2008-11-24 18:43:56|
|Subject: Monitoring buffercache...|
|Previous:||From: PFC||Date: 2008-11-24 16:56:31|
|Subject: Re: Perc 3 DC|