ThreadOkay, my select count(1)...

4 messages · 21:31–17:19

Okay, my select count(1)... Only took 14:02:43.827... 14 hours. And I question the result. LOL it says 51,018,779,514 rows I am pulling the rows out and testing some stuff. I will be able to confirm that row count. I wonder how long it would take to turn checksums on? (ROTFLMAO)

21:31

G
Gunnar "Nick" Bluth
I wonder if your hint bits are set. Shouldn't take this long to count some pages...
13:37
1. K
  Kirk
  let me do a vacuum analyze. This will likely take awhile.. then I will try it again. (Last time I did it, it was over ssh but the connection was disconnected due to no activity, so I will do it on the host machine directly).
  14:31
K
Kirk
13hrs 22 minutes...
17:19