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.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq