Yes, if they were commented out then it was using the default value which was specified before you changed it.
Is that 115MB across all the postgres.exe processes? Or for one process?
Try something like...
- Code: Select all
SELECT
p.player_name,
count(hhps.id_hand)
FROM
holdem_hand_player_statistics hhps,
holdem_hand_player_detail hhpd,
holdem_hand_summary hhs,
player p
WHERE
hhs.id_hand = hhpd.id_hand
AND hhpd.id_hand = hhps.id_hand
AND hhpd.id_player = hhps.id_player
AND hhps.id_player = p.id_player
GROUP BY
p.player_name
A lot of the memory usage will depend on how large your database is too. If your database isnt large enough to require all of the memory usage then that could explain why its limited.
-Derek