I did not conduct much more test but from what I've seen, it looks like the
ODBC driver is in the doldrums, not PG. For example, when I run my software
on Windows rather than Linux, everything just works as expected. Sorry for
disturbing.
And btw, I use ODBC because my target DB is Oracle and I
Is it possible another connection has updated the record and not committed,
and it takes a minute for the connection to time out and commit or roll back?
--
greg
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROT
Neil Conway <[EMAIL PROTECTED]> writes:
>> There are 6 rows in the table (given that size, I assumed that an
>> index was not necessary).
> That's a reasonable assumption.
But if he's updated those rows a few hundred thousand times and never
VACUUMed, he could be having some problems ...
Stefan Champailler <[EMAIL PROTECTED]> writes:
> So here's my trouble : some DELETE statement take up to 1 minute to
> complete (but not always, sometimes it's fast, sometimes it's that
> slow). Here's a typical one : DELETE FROM response_bool WHERE
> response_id = '125' The response_bool table has
Stefan Champailler wrote:
Dear You all,
(please tell me if this has already been discussed, I was unable to find any
convincing information)
I'm developing a small application, tied to a PG 7.4 beta 5 (i didn't
upgrade). The DB i use is roughly 20 tales each of them containing at most 30
recor