From: JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>
To: 'Ken J. Wright' <ken@ori-ind.com>
Cc: 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org>
Subject: RE: [INTERFACES] fetching way too much or too often???
Date: Wed, 30 Jun 1999 15:13:00 -0400
Message-ID: <01BEC30B.0C103D40.jt-kirkpatrick@mpsllc.com> (raw)
well, with use declare / fetch turned OFF on everyone's machine, the
activity on the server per user action appears to be less than 1/5th!
(i.e., greatly reduced!). we have been running now for an hour with no
lockups -- that hasn't happened yet today! but i also made another change
at the same time as removing declare/fetch -- i increased the buffers in
the startup script on the server from 256 to 512 (and then restarted).
earlier today i removed the -B option altogether, letting it use default
64 buffers -- and we started locking up like crazy! so i don't know which
is making the difference -- the buffers or no declare/fetch. . . but in
any case, for the benefit of all who read this, unchecking declare / fetch
SIGNIFICANTLY reduces the activity between the client and a postgres
server!!!
jt
-----Original Message-----
From: Ken J. Wright [SMTP:ken@ori-ind.com]
Sent: Wednesday, June 30, 1999 2:30 PM
To: JT Kirkpatrick
Subject: Re: [INTERFACES] fetching way too much or too often???
At 14:11 06/30/1999 -0400, you wrote:
>we have about 20 folks linked to a postgres 6.4.2 database through
>msaccess97 and the latest odbc driver. we have declare/fetch turned on.
> we are having a problem with the database locking up often! i am trying
>to eliminate the possibilities / theories, and i am on the declare/fetch
>process now.
>
>when a user selects one record, as a watch on the debug window (started
>postmaster w/ debug 3), it is processing many (25-50? who can count that
>fast??) fetch 100's -- but they only selected one record from one table!
> why so many fetch 100's?? should i turn off declare / fetch on
everyone's
>odbc??
YES! turn it off!
I think that was before Byron had the cursor library included. It has
little to no value at this point.
Ken
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jt-kirkpatrick@mpsllc.com, ken@ori-ind.com, pgsql-interfaces@hub.org
Subject: RE: [INTERFACES] fetching way too much or too often???
In-Reply-To: <01BEC30B.0C103D40.jt-kirkpatrick@mpsllc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox