Re: Database maintainance in PGSQL

Posted by Verus Open Source Support on Feb 10, 2012; 9:56am
URL: http://ngl.70.s1.nabble.com/Database-maintainance-in-PGSQL-tp7268191p7272148.html

Hi,
Its speeds up the database response.

On Thursday 09 February 2012 02:32 PM, ramesh, g. [via NewGenLib] wrote:

WHAT IS THE USE OF MAINTAINING DATABASE?

On Thu, Feb 9, 2012 at 2:22 PM, Support [via NewGenLib] <[hidden email]> wrote:

Close all the programs on the Server first

1. Go to Pgadmin3 (Also login...Connect)
2. Select newgenlib database, right click and select maintenance
3. Select Vacuum (Selected by default), Full (Need to be selected by you), Analyse (Selected by default)
4. Click on "OK" and wait for the done button

---

If you reply to this email, your message will be added to the discussion below:

http://newgenlib.2944635.n2.nabble.com/Database-maintainance-in-PGSQL-tp7268191p7268608.html

To start a new topic under NewGenLib, email [hidden email]
To unsubscribe from NewGenLib, click here.
NAML

--
G. Ramesh
Librarian
Vikas College of Engg & Tech.
NUNNA - 521 212
Vijayawada Rural
Krishna Dist., A.P.
Cell: 9441527540

---

If you reply to this email, your message will be added to the discussion below:

http://newgenlib.2944635.n2.nabble.com/Database-maintainance-in-PGSQL-tp7268191p7268628.html

To start a new topic under NewGenLib, email [hidden email]
To unsubscribe from NewGenLib, click here.
NAML