Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003

    Unanswered: bad performance for the first request

    Hi all,
    The result of my first request to PostgreSQL is very long, then the other requests seem faster. Is there a configurable system of cache with Postgres?
    Can you help me with this problem ?


  2. #2
    Join Date
    Dec 2002
    Well without knowing more about your database and queries (if the data is normalized, how everything is indexed) I can only guess at what could be the problem. The best places for you to look on tweaking performance of PostGres would be
    (hardware/OS wise) (software/SQL wise)

    Hope this helps,
    (I'm only available at the email address provided in my profile on weekdays, if you have questions or advice, during off hours use AIM). Also any views I provide here or on my website are mine and not representative of any views of my work, family, friends and sometimes even myself.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts