Fine. If the pg team want to call their shared memory space a disk
buffer, let them. And you can too. Anything committed to disk still
has to traverse the os disk cache. So in reality, it depends upon how
you balance parameters such as your os disk cache and your sql disk
cache etc etc. I
On Fri, 19 Aug 2005 15:01:12 +1000 Graeme Lee [EMAIL PROTECTED]
wrote:
I think I was talking about the disk buffer, not the shared buffer.
You said it uses the os disk buffer and doesn't maintain its own.
Everything that reads data from the filesystem uses the OS's buffer.
Postgresql's shared
Adam wrote:
On Fri, 19 Aug 2005 15:01:12 +1000 Graeme Lee [EMAIL PROTECTED]
wrote:
I think I was talking about the disk buffer, not the shared buffer.
You said it uses the os disk buffer and doesn't maintain its own.
its own disk buffer
Everything that reads data from the
On Fri, 19 Aug 2005 17:08:36 +1000 Graeme Lee [EMAIL PROTECTED]
wrote:
This is very much off topic, but you seem to be misunderstanding me.
The shared buffer is used by all the postmaster processes as a shared
memory pool for selects/inserts/updates on the table space. The disk
buffer is
Adam wrote:
On Fri, 19 Aug 2005 17:08:36 +1000 Graeme Lee [EMAIL PROTECTED]
wrote:
This is very much off topic, but you seem to be misunderstanding me.
The shared buffer is used by all the postmaster processes as a shared
memory pool for selects/inserts/updates on the table space. The
On Fri, 19 Aug 2005, Adam wrote:
Postgresql's shared buffer cache is used to cache data read from disk,
so it is a disk cache maintained by on its own. I think postgresql
stores and purges data in the shared buffer cache with an understanding
of table/column access, so you should get more
Hello -
I need to build a server that will run PostgreSQL 8, handling up to 150
connections. The current database size is roughly 2GB now with 2.8 million
rows in it's biggest table. This is expected to continue to grow steadily over
time.
The hardware I have to work with is a single 3Ghz p4
David Hill wrote:
Hello -
I need to build a server that will run PostgreSQL 8, handling up to 150
connections. The current database size is roughly 2GB now with 2.8 million
rows in it's biggest table. This is expected to continue to grow steadily over
time.
The hardware I have to work with
Adam wrote:
On Fri, 19 Aug 2005 12:28:20 +1000 Graeme Lee [EMAIL PROTECTED]
wrote:
Postgresql uses the os disk buffer. It does not maintain its own.
Yes it does. Postgresql uses a shared buffer cache, and increasing the
number of shared buffers in your postgresql.conf can make a
9 matches
Mail list logo