Re: Why Not MySQL?

> 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