vacuum analyze database? | Poker Tools | PokerStrategy.com Forum

In order to %1$slearn poker%2$s and receive %1$sfree poker money%2$s, you need to activate JavaScript in your browser.

This site uses cookies to improve your browsing experience. By continuing to browse the website, you accept such cookies. For more details and to change your settings, see our Cookie Policy and Privacy Policy. Close

Complete these tasks and win iPads, Steam vouchers and more

Enter your first poker room account

1

ticket

Go

Get your starting capital

10

tickets

Go

Read a strategy article

1

ticket

Go

Watch a video

1

ticket

Go

Visit a coaching

5

tickets

Go

Discuss poker strategy and hands

5

tickets

Go

Write 1 forum post

5

tickets

Go

Write 5 forum posts

5

tickets

Go

Write 10 forum posts

20

tickets

Go

Earn 1 StrategyPoint

1

ticket

Go

Reach Silver status

10

tickets

Go

Reach Gold status

10

tickets

Go

Refer a friend

10

tickets

Go

Refer 1 new player

10

tickets

Go

Refer 2 new players

10

tickets

Go

Refer 3 new players

20

tickets

Go

Write 1 news comment

5

tickets

Go

Write 5 news comments

5

tickets

Go

Write 10 news comments

10

tickets

Go

Write 1 video comment

1

ticket

Go

You have

0

raffle tickets

Next draw in

Learn more

- Last post
- First unread post
- roopopper
  
  Bronze
  Joined: 31.12.2010 Posts: 4,289
  - 12.11.2011, 19:24
  - 0
  - This post has been edited 1 time(s), it was last edited by roopopper: 12.11.2011 19:50.
  Hello
  
  could someone please explain this function to me?
  Better add this is on hem
  
  Roo
  - Reply
  - Quote
2 replies
- VorpalF2F
  
  Super Moderator
  
  Super Moderator
  
  Joined: 02.09.2010 Posts: 10,728
  - 12.11.2011, 20:20
  - 0
  In short, "vacuum analyse" checks your database integrity, and sucks out any dirt.
  
  A thorough -- too thorough -- explanation is here:
  http://wiki.postgresql.org/wiki/Introduction_to_VACUUM,_ANALYZE,_EXPLAIN,_and_COUNT
  
  I don't do it often, but the other day, I regular on whom I have several hundred hands showed up at a table with only a few.
  
  Following the vacuum analyse, all was sweetness and light.
  - Reply
  - Quote
- roopopper
  
  Bronze
  Joined: 31.12.2010 Posts: 4,289
  - 12.11.2011, 20:30
  - 0
  Originally posted by VorpalF2F
  In short, "vacuum analyse" checks your database integrity, and sucks out any dirt.
  
  A thorough -- too thorough -- explanation is here:
  http://wiki.postgresql.org/wiki/Introduction_to_VACUUM,_ANALYZE,_EXPLAIN,_and_COUNT
  
  I don't do it often, but the other day, I regular on whom I have several hundred hands showed up at a table with only a few.
  
  Following the vacuum analyse, all was sweetness and light.
  Thanks
  - Reply
  - Quote