Hi,
Il 19/05/12 19:09, c k ha scritto:
similar tasks and already using it. This problem arises when I have to
issue an update script to the client having only function mostly. And
as most of the functions are dependent on others and having more than
1100 functions it becomes hard to write a
I have a situation where an increase in volume of inserts into the
main transaction table causes a huge slowdown. The table has lots of
indexes and foreign keys and a trigger.
Clearly, something is causing a resource contention issue, but here's
my main question:
I have log_lock_waits = on and
On Sat, May 19, 2012 at 10:57 PM, Bosco Rama postg...@boscorama.com wrote:
Hey Josh,
I found the message I was seeing. It was/is(?) in StartRestoreBlob() and it
looks like this:
ahlog(AH, 2, restoring large object with OID %u\n, oid);
But I don't know how to find it in the current git
John Townsend wrote:
It appears that some developers (Davart) are by-passing the standard
client library, “libpq.dll”, and directly accessing the server using
Delphi or FPC. I am not sure of the advantage here. All libpq.dll
I'm FPC user and I use libpq.so(.dll,.dylib) via zeoslib.
Those who
On Sun, May 20, 2012 at 12:26:26AM -0700, Ian Harding wrote:
I have a situation where an increase in volume of inserts into the
main transaction table causes a huge slowdown. The table has lots of
indexes and foreign keys and a trigger.
Clearly, something is causing a resource contention
On Sun, May 20, 2012 at 02:51:42PM +0200, zeljko wrote:
John Townsend wrote:
It appears that some developers (Davart) are by-passing the standard
client library, ???libpq.dll???, and directly accessing the server using
Delphi or FPC. I am not sure of the advantage here. All libpq.dll
Chris Angelico ros...@gmail.com writes:
On Sat, May 19, 2012 at 3:09 AM, Steve Crawford
scrawf...@pinpointresearch.com wrote:
I also don't understand the xcrm.channel_id in (1) instead of
xcrm.channel_id = 1 unless this is a generated query and there could be
multiple ids in that condition.
One thing you may want to look at (if this is PG 8.4.x) is the number of
large objects in pg_largeobjects. If your apps don't use large objects
this is not relevant. If they do, then it may be. I've noticed that
pg_restore no longer reports the restoration of individual LO items. It
used to
Josh Kupershmidt schmi...@gmail.com writes:
... Notice that pg_backup_archiver.c and
pg_backup_tar.c use an inconsistent log level for this same message,
which might explain where you saw the message previously.
Seems like that ought to be fixed.
... Or change this bit in pg_restore.c to
On Sun, May 20, 2012 at 8:39 AM, Poul Møller Hansen free...@pbnet.dk wrote:
Anyway, if you are seeing no activity at the end of the restore for quite
a while you may want to see if large objects are the reason.
The dump are from a version 9.0.7 and it's being restored in a version
9.1.3.
On Sunday, May 20, 2012, Martijn van Oosterhout wrote:
On Sun, May 20, 2012 at 12:26:26AM -0700, Ian Harding wrote:
I have a situation where an increase in volume of inserts into the
main transaction table causes a huge slowdown. The table has lots of
indexes and foreign keys and a
Yes, It is useful. But situation is different. Most of the times objects
are first created, tested and only after finalization can go in the
extension update file. Also it can be difficult not to get the object
definitions from an extension in the backup from pg_dump. A customer could
have to
Hi all,
Many times I have to dump all objects from a schema (single schema holding
only functions and views) in plain text format. It is found that pg_dump
includes a set search_path statement at the beginning and drops all
occurrences of the schema name (to which dumped object belongs) from
By by-passing the dll (or so on Linux) library I mean you write
function or procedure calls to the server that is running as a service
on Windows. You don't use the library with its 160 exported functions.
You connect directly to the server thus saving one layer of protocols.
To do this, you
On 05/20/12 12:52 PM, John Townsend wrote:
By by-passing the dll (or so on Linux) library I mean you write
function or procedure calls to the server that is running as a service
on Windows. You don't use the library with its 160 exported functions.
You connect directly to the server thus
I also needed to give the privilege to execute pg_terminate_backend to
non-superusers and I made it in a separate schema, too. But, to avoid users
killing other user connections I made another function that only gives the
option to kill connections made by the same user that's executing the
On Mon, May 21, 2012 at 6:12 AM, John R Pierce pie...@hogranch.com wrote:
On 05/20/12 12:52 PM, John Townsend wrote:
By by-passing the dll (or so on Linux) library I mean you write
function or procedure calls to the server that is running as a service on
Windows. You don't use the library
David Salisbury salisb...@globe.gov writes:
Actually, figured I'd post the whole function, painful as it
might be for anyone to read. If anyone sees something that's a bit
of a risk ( like perhaps the whole thing ;)
Well, I don't know exactly what's causing your issue, but I see a few
things
18 matches
Mail list logo