> So, may I have the envelope please? What's the timings?
6.5.3:
StartTransactionCommand
query: select * from applicants as a,applicants_states as s where
a.firstname ~* '^mitch' and s.rstate='AL' and s.app_id=a.app_id limit 10
offset 0;
ProcessQuery
! system usage stats:
! 0.436792 elapsed 0.275139 user 0.157033 system sec
! [0.283135 user 0.173026 sys total]
! 0/0 [0/0] filesystem blocks in/out
! 0/149 [0/332] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [2/2] messages rcvd/sent
! 0/8 [2/9] voluntary/involuntary context switches
! postgres usage stats:
! Shared blocks: 1403 read, 0 written, buffer hit rate
= 51.22%
! Local blocks: 0 read, 0 written, buffer hit rate
= 0.00%
! Direct blocks: 0 read, 0 written
CommitTransactionCommand
proc_exit(0) [#0]
shmem_exit(0) [#0]
exit(0)
______________________________________________________________________
7.0 :
StartTransactionCommand
query: select * from applicants as a,applicants_states as s where
a.firstname ~*
'^mitch' and s.rstate='AL' and s.app_id=a.app_id limit 10 offset 0;
ProcessQuery
! system usage stats:
! 1.461997 elapsed 1.224377 user 0.234618 system sec
! [1.238219 user 0.255382 sys total]
! 0/12 [0/12] filesystem blocks in/out
! 0/60 [0/318] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [2/2] messages rcvd/sent
! 0/22 [1/24] voluntary/involuntary context switches
! postgres usage stats:
! Shared blocks: 2713 read, 0 written, buffer hit rate
= 25.34%
! Local blocks: 0 read, 0 written, buffer hit rate
= 0.00%
! Direct blocks: 0 read, 0 written
CommitTransactionCommand
proc_exit(0)
shmem_exit(0)
exit(0)
/usr/local/pgsql/bin/postmaster: reaping dead processes...
/usr/local/pgsql/bin/postmaster: CleanupProc: pid 60606 exited with status 0
Sorry, I didn't get what you wanted at first. I'm down to my last brain cell
today.
-Mitch
