Euler, On Wed, Jan 03, 2007 at 09:50:15PM -0200, Euler Taveira de Oliveira wrote: > Dmitry D. Khlebnikov wrote: > > > The man page for postgres(1) has a wrong description of the '-S' option. > > Previously, the '-S' option means that postgres will start in the 'silent' > > mode, but in version 8.2 the '-S' option describes the amount of memory for > > sorts. > > > I think you change the order, in 8.1 -S option describes the amount of > memory but in 8.2 it describes the silent mode. This is because there
Perhaps. However, when I tried to follow the man page and run 'postgres' with '-S' it responded with: db!pgsql:~$ postgres --version postgres (PostgreSQL) 8.2.0 db!pgsql:~$ postgres -D /var/lib/pgsql -S postgres: option requires an argument -- S Try "postgres --help" for more information. db!pgsql:~$ postgres --help | fgrep -- -S -S WORK-MEM set amount of memory for sorts (in kB) db!pgsql:~$ zcat /usr/share/man/man1/postgres.1.gz | fgrep -A 3 -- -S \fB-S\fR Specifies that the \fBpostgres\fR process should start up in silent mode. That is, it will disassociate from the user's (controlling) terminal, start its db!pgsql:~$ All in all, I don't know how it was in the previous versions of PostgreSQL (I was using 7.x versions), I just merely want to point out that the man page provides the incorrect information wrt the '-S' option. -- (GM) ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match