Re: [DOCS] [PERFORM] PostgreSQL vs. MySQL

2003-09-26 Thread Bruce Momjian 
Andrew Sullivan wrote:
> On Sat, Aug 16, 2003 at 08:36:57PM -0400, Bruce Momjian wrote:
> > 
> > Do we need to add a mention of the need for tuning to the install docs?
> 
> Wouldn't be a bad idea, as far as I'm concerned.

OK, I added a 'Tuning' section to the install instructions.  I can make
adjustments.

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073
Index: doc/src/sgml/installation.sgml
===
RCS file: /cvsroot/pgsql-server/doc/src/sgml/installation.sgml,v
retrieving revision 1.143
diff -c -c -r1.143 installation.sgml
*** doc/src/sgml/installation.sgml  13 Sep 2003 17:01:09 -  1.143
--- doc/src/sgml/installation.sgml  26 Sep 2003 17:40:53 -
***
*** 1156,1161 
--- 1156,1181 
Post-Installation Setup
  

+Tuning
+ 
+
+ tuning
+
+ 
+
+ By default, PostgreSQL is configured to run on minimal
+ hardware.  This allows it to start up with almost any hardware
+ configuration. However, the default configuration is not designed for
+ optimum performance. To achieve optimum performance, several server
+ variables must be adjusted,  the two most common being
+ shared_buffers and  sort_mem
+ mentioned in . Other
+ paramters in  also affect 
+ performance.
+
+   
+ 
+   
 Shared Libraries
  
 

---(end of broadcast)---
TIP 8: explain analyze is your friend

[DOCS] ODBC for PostgreSQL

2003-09-26 Thread Wayne W. Cheng 
Hello,

We have developed a C/C++ interpreter (Ch) that can run all
ODBC programs across platform without compilation and linking.
(http://gborg.postgresql.org/project/psqlodbc/genpage.php?howto-ch)
(http://www.softintegration.com/products/toolkit/odbc/)

I checked the documentation about ODBC "installation" and "Windows Application"
on the link below
http://www.postgresql.org/docs/view.php?version=7.2&idoc=0&file=odbc-install.html
http://www.postgresql.org/docs/view.php?version=7.2&idoc=0&file=odbc-windows.html

I wonder if you are able to add information about Ch 
to run ODBC programs in the documentation in addition to VB etc.
It could become that "Ch, Access, Delphi, and Visual Basic all support ODBC 
directly."

I think the benefit to mention Ch is that all ODBC programs can
run across platform in Windows, Unix, Mac OS X without the tedious
linking/compiling cycle. Moreover, free Ch CGI Toolkit provides easy way
of doing CGI programs with ODBC together.

Best regards,

Wayne 
http://www.softintegration.com




---(end of broadcast)---
TIP 8: explain analyze is your friend