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 Herrera||Date: 2006-06-30 14:14:55|
|Subject: Re: Index Being Ignored?|
|Previous:||From: Joe Lester||Date: 2006-06-30 13:31:52|
|Subject: Index Being Ignored?|