[ADMIN] Re: [SQL] Can't starting postmaster with -B 512 Option

1998-11-12 Thread The Hermit Hacker
On Fri, 13 Nov 1998, [euc-kr] ¼Û±â¿ø wrote: > System Spec > SUN OS 2.6 > PostgreSQL 6.3 Version > > [Error Message] > sol% postmaster -B 512 -S -D /usr/local/pgsql/data > IpcMemoryCreate: memKey=5432001 , size=4501144 , > permission=384IpcMemoryCreate: shmget(..., create, ...) failed: In

Re: [ADMIN] indexing issues: what's the fasted join method?

1998-11-12 Thread Zachariah Baum
[EMAIL PROTECTED] said: > Did you do a VACUUM ANALYZE? that worked! Thanks a lot. -- Yes is a BARGAIN No is a TURNOFF - Wire --Zachariah - Studio Archetype - 415-659-4435 - mailto:[EMAIL PROTECTED]

Re: [ADMIN] indexing issues: what's the fasted join method?

1998-11-12 Thread David Hartwig
Did you do a VACUUM ANALYZE? Check out man page on: vacuum Zachariah Baum wrote: > I'm running PostgreSQL 6.4 on Linux, and have the following database setup: > > i have 2 tables, table1 and table2, both with an 'id' field, and both with > an index on the 'id' field. > Usually my selects invo

Re: [ADMIN] StreamServerPort: bind() failed

1998-11-12 Thread Zachariah Baum
[EMAIL PROTECTED] said: > after killing a running postmaster I wanted to restart it with > postmaster -i -d 1 -B 2048 -D /data_dir but it gave the following > error message: On Linux postmaster creates the file /tmp/.s.PGSQL.5432, a named pipe (???) that it uses for IPC I believe. The 5432

[ADMIN] indexing issues: what's the fasted join method?

1998-11-12 Thread Zachariah Baum
I'm running PostgreSQL 6.4 on Linux, and have the following database setup: i have 2 tables, table1 and table2, both with an 'id' field, and both with an index on the 'id' field. Usually my selects involve a join between the tables, but the join is quite slow. I played around with the EXPLAI

[ADMIN] StreamServerPort: bind() failed

1998-11-12 Thread Joerg Schultz
Hi, after killing a running postmaster I wanted to restart it with postmaster -i -d 1 -B 2048 -D /data_dir but it gave the following error message: FindBackend: searching PATH ... FindBackend: found "/coot1/postgres/bin/postgres" using PATH FATAL: StreamServerPort: bind() failed: errno=125