Is there any way of reading the whole database into memory? By changing the number of shared buffers the first query still takes long time and the subsequent similar queries are fast. If there is way of pinning the database in the memory all similar queries will take the same time. thanks
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
