>> 7. How many concurrent readers of your database, and what's the average transfer rate, suppose all readers are doing
onetable scaning.
>
> Concurrent but idle connections in production are around 600. Active
> connections at a time are in the dozens. I can read at about 60 to 70
> Megs a second for random access and around 350 to 400 Megs a second
> for sequential reads.
>
I am not so familiar with PostgreSQL, it uses a one process per connection architecture, let me say one agent process
perclient , what I am wondering is how multiple agent process share page caches. In many other databases, client agents
usesthe multiple thread method, so they can share memory buffers within the same process, are there share-memory
mechanismsbetween PostgreSQL agent processes?