newly created database makes queries run 300% faster - Mailing list pgsql-performance

From Ksenia Marasanova
Subject newly created database makes queries run 300% faster
Date
Msg-id 130df1930606300713y55496692l3ee844f055305aa8@mail.gmail.com
Whole thread Raw
Responses Re: newly created database makes queries run 300% faster
List pgsql-performance
Hi,

Alfter hours of adjusting performance of the queries in my Postgres
7.3 database - reprogramming the queries, VACUUMing, changing value of
enable_seqscan - I gived it up, recreated the database and transferred
the dump of the old database into it.
The queries went from 15 sec to 50 msec!! Wow.
Now I would really love to know how the old database got that slow,
and how can I avoid it in the future. Any tips are greatly
appreciated!

Thanks!
Ksenia.

pgsql-performance by date:

Previous
From: Joe Lester
Date:
Subject: Index Being Ignored?
Next
From: Markus Schaber
Date:
Subject: Re: Index Being Ignored?