How does one set up ODBC on a cygwin/NT/Postgres 7.1 installation? I already had
a psqlodbc.dll from the last install (7.0.3). Do I need to recompile a new one
with VC++? Do I need to recompile postgres with --with-odbc? I'm using a
precompiled 7.1 that came along with cygwin 1.1.8 and I don't
On Sun, Apr 22, 2001 at 06:52:26PM -0400, [EMAIL PROTECTED] wrote:
I'm spawning 6 backends to query the data. top lists 6 postmaster processes
working, and therefore the idle time should hit 0% easily. Also, the hard
drive light goes nuts when I'm running this.
Here is the pertinent
For other users, you have to provide username and password which should
existed in your db.
Jie LIANG
St. Bernard Software
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
[EMAIL PROTECTED]
www.stbernard.com
www.ipinc.com
On Sun, 22 Apr 2001, Randall Perry
Below are snippets from:
strace postmaster -i -D `pwd` -B 48000
A large snippet:
.
.
.
socket(PF_UNIX, SOCK_STREAM, 0) = 4
bind(4, {sun_family=AF_UNIX, sun_path=/tmp/.s.PGSQL.5432}, 20) = 0
listen(4, 128) = 0
chmod(/tmp/.s.PGSQL.5432, 0777) = 0
I'm trying to figure that out myself :-)
According to the strace info I sent in my last message, it is in fact
creating a 381MB shmem block.. which makes no sense, I agree.
-Xavier
At 01:07 AM 4/23/01 -0400, Tom Lane wrote:
27 processes: 24 sleeping, 3 running, 0 zombie, 0 stopped
CPU
On Mon, Apr 23, 2001 at 06:13:38PM -0400, [EMAIL PROTECTED] wrote:
A smaller snippet:
shmget(5432001, 400385024, IPC_CREAT|0x180|0600) = 2945
shmget(5432001, 400385024, 0) = 2945
shmat(2945, 0, 0) = 0x40176000
I'm no Unix expert, but this would seem to
[EMAIL PROTECTED] writes:
I'm no Unix expert, but this would seem to indicate that shmget is
successfully allocating 400385024/1024/1024=381MB of shared memory. I don't
know enough about how the postgres parent/child/shmem scheme works to know
why this is working yet the children only
By my reading, the machine is definitely swapping, and not writing to a log
file (unless its writing obscene amounts of data to the log, which
presumably the default settings won't do).
postmaster -i -D /home/mg/pgsql -B 100
produces almost identical results in terms of performance and disk