Results 1 to 2 of 2

Thread: Reindex postgre

  1. #1
    Join Date
    Apr 2008
    Posts
    1

    Unanswered: Reindex postgre

    Helo.

    I have problem. i have application payroll with postgre db.
    every day i have 1000 people to check clock.
    the problem i always missing same NIK (it my identity of my people).
    than i check in postgre web i must have reindex dan vacuum.
    can i make auto reindex ?
    because i can access vacuum from may application with shell
    like
    SHELL("C:\Program Files\\PostgreSQL\\8.2\\bin\\vacuumdb.exe -f -d Mypeople -U postgres")

    but i want make reindex too, please help me thank you

  2. #2
    Join Date
    Mar 2008
    Posts
    14
    I am not sure what your exact problem is,
    but you can turn on auto vacuum if you want.

    You normally don't have to re-index every day, only under special conditions.

    Ries

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •