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
