On Wed, 14 Apr 2004 06:22:56 -0700, "Barry L. Geipel" <barry@GeipelNet.com> wrote: >How should the random_page_cost be calculated? There are so many factors involved that I'd say it cannot be calculated. The best strategy is to start with the default value of 4 and only fine tune it based on the run times of real world queries. If you experience problems with certain queries, post a short description of your problem and EXPLAIN ANALYSE output to the -performance mailing list. Servus Manfred ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly