| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Pandurang <pandurang(at)manas-solutions(dot)com> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Strange..!!! Can u tell me why this ? |
| Date: | 2002-10-28 16:38:48 |
| Message-ID: | 20021028083802.J79386-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On 26 Oct 2002, Pandurang wrote:
> But Later on as the DB size get increased the time was also get
> increased. And at one point i noticed the time required to gererate
> this report is very high near abt 10 to 15 hrs. So I checked for
> performanance.
>
> Site was also become very slow. A simple page which is fetching just
> 20 records, for that also I got the error page not displayed.I tried
> my level best to find out the problem. But I couldn't...!!! :-((
>
> So at last I decided to drop DB and recreate once more after taking
> backup of data. And I did that. After that i was surprised that site
> become very very fast. And the pages for which I got the error comes
> in less than 10 seconds.
>
> So can u tell me why this happens ? Why suddenly DB performanance get
> increased so fastly ? Prev.ly I tried for vacuumdb also....
You tried vacuuming, but were you doing analyze (I believe -z to
vacuumdb)? What does explain show for the queries in question?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nick Sayer | 2002-10-28 16:59:42 | Understanding pg_dump/pg_restore |
| Previous Message | mallah | 2002-10-28 15:21:37 | Re: counting tupples |