On Wed, 2006-03-15 at 13:36, Abbath wrote: > Hello Richard, > > Wednesday, March 15, 2006, 3:35:26 PM, you wrote: > > If you want to force the data to be cached, just put a cron-job in to > > run a query for "abc" or whatever once a minute. > > I can't guess what the user want to search. But that query will likely load up all the index info into memory. > > Of course, if it turns out that your users aren't running the query very > > often then you're wasting resources, and if they are running it often > > then again you're wasting resources. But - if you really need to, that's > > the solution. > > It seems if I periodically use VACUUM ANALYZE, it helps to reduce the search > time...I will see how can I tune it more. That statement is pretty telling. You're new to PostgreSQL I'll assume. You'll need to read up on the periodic maintenance section of the docs. Here ya go: http://www.postgresql.org/docs/8.1/interactive/maintenance.html
