Re: Why Not MySQL?

Mitch, one question ... what is the configuration (RAM, CPU, etc) of the
v6.5.3 machine vs v7.0 machine?  Also, how is your postmaster started
up?  What options?

On Wed, 3 May 2000, Mitch Vincent wrote:

> > 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
> 

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org