Hi,
I was comparing speed of inserts in C vs JDBC and
found that as the table size increases the speed
differential decreases till there is no difference (no
problem). However inserts kept getting slower and
slower as the table size increased and the performance
became quite poor. Here is the
--- Tom Lane [EMAIL PROTECTED] wrote:
Rini Dutta [EMAIL PROTECTED] writes:
Here is the performance statistics on the same
table.
Note the fall in performance as the test proceeds.
Try 7.1. I think you are running into the
lots-of-pending-triggers
problem that was found and fixed
Hi,
I am using the JDBC interface. Does anybody know what
could lead to the following two errors I ran into -
1. Cannot handle multiple result groups.
at
org.postgresql.Connection.ExecSQL(Connection.java,
Compiled Code)
at
the
table and bails out of
the transaction. I just wish it didn't happen so
often... grin
Mike Diehl,
Network Monitoring Tool Devl.
284-3137
[EMAIL PROTECTED]
-Original Message-
From: Rini Dutta [mailto:[EMAIL PROTECTED]]
Sent: February 20, 2001 9:35 AM
To: [EMAIL
Hi,
Does anyone know how postgres/ postmaster handles the
situation where the physical hard disk space is full ?
Does it crash / corrupt the database, or does it
cleanly exit with appopriate message so that relevant
tables can be pruned (by the user) to free up disk
space and get it working
Hi,
I happenned to come across the following in the
documentation on WAL implementation in v7.1 -
*
Before WAL, any crash during writing could result in:
1.index tuples pointing to non-existent table rows
2.index tuples lost in
Is there a way to temporarily turn of the use of a
default editor when using psql ?
I need to do this when I try to use psql from a
script/batch file. Whenever a query is executed psql
displays a result, displays it - I need to hit 'q' to
end the display and would like to avoid this
unnecessary