What would you do?

[Floundering]

Ok, so it is a small money tournament but after 3 hours of playing, it was annoying to lose this way on the final table.
Should I have just gone allin as soon as the flop came down??


PokerStars Game $4.00+$0.40 Hold'em No Limit
- Level XIII (1000/2000) - 2006/11/06 - 17:09:12 (ET)
Table '35289185 2' 9-max Seat #5 is the button
Seat 1: X1 (10300 in chips)
Seat 2: X2 (6927 in chips)
Seat 3: X3 (20800 in chips)
Button: X4 (93538 in chips)
SB : Villain (45977 in chips)
BB : Me (46545 in chips)
Seat 9: X7 (45913 in chips)
X1: posts the ante 100
X2: posts the ante 100
X3: posts the ante 100
X4: posts the ante 100
Villain: posts the ante 100
Me: posts the ante 100
X7: posts the ante 100
Villain: posts small blind 1000
Me: posts big blind 2000
*** HOLE CARDS ***
Dealt to Me [9s Ac]
X7: folds
X1: folds
X2: folds
X3: folds
X4: folds
Villain: calls 1000
Me: raises 6000 to 8000
Villain: calls 6000
*** FLOP *** [Kh Ah 7d]
Villain: checks
Me: bets 6000
Villain: calls 6000
*** TURN *** [Kh Ah 7d] [9h]
Villain: checks
Me: bets 32445 and is all-in
Villain: calls 31877 and is all-in
*** RIVER *** [Kh Ah 7d 9h] [8h]
*** SHOW DOWN ***
Villain: shows [Kc Qh] (a flush, Ace high)
Me: shows [9s Ac] (two pair, Aces and Nines)
Villain collected 92454 from pot
*** SUMMARY ***
Total pot 92454 | Rake 0
Board [Kh Ah 7d 9h 8h]
Seat 1: X1 folded before Flop (didn't bet)
Seat 2: X2 folded before Flop (didn't bet)
Seat 3: X3 folded before Flop (didn't bet)
Seat 5: X4 (button) folded before Flop (didn't bet)
Seat 6: Villain (small blind) showed [Kc Qh] and won (92454) with a flush,
Ace high
Seat 8: Me (big blind) showed [9s Ac] and lost with two pair, Aces and
Nines
Seat 9: X7 folded before Flop (didn't bet)