Re: [DOCS] [GENERAL] Server side large object functions

2008-12-18 Thread Alvaro Herrera
George Weaver wrote:

> As an aside, if I do a PostgreSQL Website search for "loread", I get not  
> hits.

Apparently these functions are not documented at all :-(  Most of the
chapter on large objects
http://www.postgresql.org/docs/8.3/static/lo-funcs.html
seems predicated on that one will be using libpq and C.

-- 
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

-- 
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs


Re: [DOCS] [ADMIN] shared_buffers and shmmax

2008-12-18 Thread Bruce Momjian
Alvaro Herrera wrote:
> Bruce Momjian wrote:
> 
> > I decided I didn't like what I did either;  updated version with new
> > headings and shorter descriptions:
> > 
> > http://momjian.us/tmp/pgsql/kernel-resources.html
> 
> This version seems good to me, except please put back the B to the end
> of "770 k".

Patch applied with "B" re-added, though I would like to mention again
that it is inconsistent because we don't mention bytes in any other row
in that column.

-- 
  Bruce Momjian  http://momjian.us
  EnterpriseDB http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +
Index: runtime.sgml
===
RCS file: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v
retrieving revision 1.423
retrieving revision 1.424
diff -c -c -r1.423 -r1.424
*** runtime.sgml	16 Dec 2008 19:30:43 -	1.423
--- runtime.sgml	18 Dec 2008 17:03:09 -	1.424
***
*** 1,4 
! 
  
  
   Operating System Environment
--- 1,4 
! 
  
  
   Operating System Environment
***
*** 1080,1120 
  
  
 
! Configuration parameters affecting
! PostgreSQL's shared memory usage
  
  
   

!Name
!Approximate multiplier (bytes per increment) as of 8.3

   
  
   

!
!1800 + 270 * 

  

!
!1800 + 270 * 

  

!
!770 + 270 * 

  

!
!8400 (assuming 8 kB BLCKSZ)

  

!
!8200 (assuming 8 kB XLOG_BLCKSZ)

  

--- 1080,1124 
  
  
 
! PostgreSQL shared memory usage
  
  
   

!Usage
!Approximate shared memory bytes required (as of 8.3)

   
  
   

!Connections
!(1800 + 270 * ) * 

  

!Autovacuum workers
!(1800 + 270 * ) * 

  

!Prepared transactions
!(770 + 270 * ) * 

  

!Shared disk buffers
!( + 208) * 

  

!WAL buffers
!( + 8) * 

  

***
*** 1125,1142 
  
 
  
-
- 
-  The multipliers for shared_buffers and
-  wal_buffers should be the number of buffers, not the
-  amount in bytes.  To find out the number of shared or wal buffers, divide
-  the amount in bytes by  and
-  , respectively.
- 
-

  
- 

 Resource Limits
  
--- 1129,1136 

-- 
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs


Re: [DOCS] [ADMIN] shared_buffers and shmmax

2008-12-18 Thread Alvaro Herrera
Bruce Momjian wrote:
> Alvaro Herrera wrote:

> > This version seems good to me, except please put back the B to the end
> > of "770 k".
> 
> Patch applied with "B" re-added, though I would like to mention again
> that it is inconsistent because we don't mention bytes in any other row
> in that column.

The heading already says "bytes".

-- 
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

-- 
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs