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.

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: 9,415
  - 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