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: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance

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



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-2017 The PostgreSQL Global Development Group