Skip site navigation (1) Skip section navigation (2)

newly created database makes queries run 300% faster

From: "Ksenia Marasanova" <ksenia(dot)marasanova(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: newly created database makes queries run 300% faster
Date: 2006-06-30 14:13:52
Message-ID: 130df1930606300713y55496692l3ee844f055305aa8@mail.gmail.com (view raw or flat)
Thread:
Lists: 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.

Responses

pgsql-performance by date

Next:From: Alvaro HerreraDate: 2006-06-30 14:14:55
Subject: Re: Index Being Ignored?
Previous:From: Joe LesterDate: 2006-06-30 13:31:52
Subject: Index Being Ignored?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group