| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | go <go(at)ugnn(dot)ru> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Database became very slow(Help PLS) |
| Date: | 2005-06-15 06:08:02 |
| Message-ID: | 42AFC5C2.6070204@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
go wrote:
> Hi,
>
> After about 2 month of greate work, my database (running under
> PG 8.01 on Win2000) very slow.Reindexing all tables, Vacuum Full,Freeze
> and Analyze didn't help(i did it from pg_admin III).
> But after dropdb and pg_restore it become fast again.
> (The same database -both very small , about 50 Mb- running under PG 8.01
> on Linux RHEL AS3 do not need in recreating db = only a dayly vacuumdb)
> Tell me please what im doing wrong on Win2000?
Difficult to say without some evidence.
Keep an eye on the size of your database files and use the oid2name tool
in contrib to see if any particular object is growing in size.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannu Krosing | 2005-06-15 08:50:42 | Re: Autovacuum in the backend |
| Previous Message | Marek Lewczuk | 2005-06-15 05:59:49 | Re: [SPAM] Current transaction ID? |