Re: [ADMIN] smp , php and postmaster distant

tions to > > postmaster to accept multi prcocessors ? > > > > The web server and the database server are link with a 100Mbit link > > ! > > > > thanks for > > all -- Chris Albertson [EMAIL PROTECTED] Voice: 626-351-0089 x17 Logicon, Pasadena CaliforniaFax: 626-351-0699

Re: [ADMIN] Database/table limits ??????

Can a table be spread over more than one disk drive? Yes (1) the RAID system will do this for you and (2) should your table be so large that it spans multiple files you can move and link some of the files. -- Chris Albertson [EMAIL PROTECTED] Voice: 626-351-0089 x17 Lo

Re: [ADMIN] Database/table limits ??????

8k, configurable to 32k > Maximum number of rows in a table? unlimited > Maximum number of columns table? unlimited > Maximum number of indexes on a table? unlimited > > The row length limit will be removed in 7.1. > > == -- Chris Albertso

Re: [ADMIN] Re: few more securiry questions :-)

rder to connect > you have to be authenticated. That's not to hard to fix. You just have initdb create system catalogs with a the required settings. -- Chris Albertson [EMAIL PROTECTED] Voice: 626-351-0089 x17 Logicon, Pasadena CaliforniaFax: 626-351-0699

Re: [ADMIN] table size limit under Linux

just a table. (Someone please correct me if I am wrong) So you can have only 4 giga-rows in a database. Our project may bump into this limit in a few years but by then maybe Postgresql will allow 64 bit OIDs > > Thanks in advance > Norbert -- Chris Albertson [EMAIL PROTECTED]

Re: [ADMIN] 'postmaster -B [nBuffers]'

CPU is waiting on the disk. A direct answer is "B = a few thousand" --Chris Albertson home: [EMAIL PROTECTED] Redondo Beach, California work: [EMAIL PROTECTED]

Re: [ADMIN] postgres on WIN32

Donald Fowler wrote: > > Why is it thinking the database in named after my user name? Because that is the default database name if you don't specify a name on the command line. -- --Chris Albertson home: [EMAIL PROTECTED] Redondo Beach, Califo

Re: [ADMIN] performance

with 512 MB of >RAM. > > Any suggestions would be appreciated. > > Joe Conway > > p.s. I tried to search the archives, but it did not return any results with even the >simplest of searches. -- --Chris Albertson home: [EMAIL PROTECTED] Redondo Beach, California work: [EMAIL PROTECTED]

Re: [ADMIN] Is it possible?

ensitive "=" operator. or just redefine the = for an existing character type. -- Chris Albertson [EMAIL PROTECTED] Voice: 626-351-0089 X127 Logicon, Pasadena CaliforniaFax: 626-351-0699

Re: [ADMIN] Need postgres password!

Likely there is none. Do an "su" to root then do "su - postgres". This will make you the postgres user without having to know the password if it exists. Oscar Monroy Brise~no wrote: ...anybody know the password for the user postgres ??? -- Chris Albertson

Re: [ADMIN] Tuning postgres for high volume applications

gt; Brian > -- > [EMAIL PROTECTED] > http://www.baquiran.com > US Fax: (603) 908-0727 > AIM: bbaquiran -- Chris Albertson [EMAIL PROTECTED] Voice: 626-351-0089 X127 Logicon, Pasadena CaliforniaFax: 626-351-0699

Re: [ADMIN] Reducing the search results to a certain number of results -i.e. 10 per page

[ LIMIT { count | ALL } [ { OFFSET | , } count ] ] -- Chris Albertson [EMAIL PROTECTED] Voice: 626-351-0089 X127 Logicon, Pasadena CaliforniaFax: 626-351-0699

[ADMIN] Re: pgsql-admin-digest V1 #452

for what ppurpose and CPU utilazation. Your goal is to adjust things such that your CPU utilazation is close to 100%. Any less means you are waiting on your disk. > > End of pgsql-admin-digest V1 #452 > * > > -- Chris Albertson [EMAIL PROTECTED] Voice: 626-351-0089 X127 Logicon, Pasadena CaliforniaFax: 626-351-0699

[ADMIN] Re: pgsql-admin-digest V1 #392

gt; > I know I am asking a lot here, and would be satisfied with where in > the docs to look. > > Thanks hal > > ------ > > End of pgsql-admin-digest V1 #392 > * > > -- Chris Albertson [EMAIL PROTECTED] Voice: 626-351-0089 X127 Logicon, Pasadena CaliforniaFax: 626-351-0699

[ADMIN] Re: HSA (Highly Scalable Architecture) Distribution and replication

e. > I don't use order by, although I'd like to, because the docs said that > indexes are not used on order by queries. I use limit also. > > I think writing a Distribution/Replication engine using Java servlets > should be a medium size task. Making it fault-tolerant and dealin

[ADMIN] Re: HSA (Highly Scalable Architecture) Distribution and replication

work for us. PS Please cc any reply to me directly as a get the digest. -- Chris Albertson [EMAIL PROTECTED] Voice: 626-351-0089 X127 Logicon, Pasadena CaliforniaFax: 626-351-0699

[ADMIN] postgres ODBC

first. Load some data and make sure you can access it over your network. Once this works install ODBC drivers of the PC. Go one step at a time and you should have no throuble. -- Chris Albertson [EMAIL PROTECTED] Voice: 626-351-0089 X127 Logicon, Pasadena CaliforniaFax: 626-351-0699

[ADMIN] How to restrict use of CREATE TABLE?

allowed more open access. What is the best why to disable both CREATE TABLE and SELECT INTO... Thanks, PS Could you cc me via e-mail as I get the degest. -- Chris Albertson [EMAIL PROTECTED] Voice: 626-351-0089 X127 Logicon, Pasadena CaliforniaFax: 626-351