Postgres Pro
Downloads
Home   >   mailing lists

Database became very slow(Help PLS) - Mailing list pgsql-general

From go
Subject Database became very slow(Help PLS)
Date
Msg-id 342958000.20050615075511@ugnn.ru
Whole thread Raw
Responses Re: Database became very slow(Help PLS)  (Richard Huxton <dev@archonet.com>)
Re: Database became very slow(Help PLS)  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
Tree view 
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?


Tanks and Have a nice day!
--

 Igor                          mailto:go@ugnn.ru

pgsql-general by date:

Previous
From: "Qingqing Zhou"
Date:
Subject: Re: (NONE)
Next
From: "Qingqing Zhou"
Date:
Subject: Re: How to set an expiration date for a WHOLE user account