Hi
There,
We
having some problem with the DB which logs sometimes "could not receive
data from client: Connection timed out" error.
We
couldn't find when it happens, and why..
Also
from the client side (we facing some transaction that comes back after something
like 15 min) BDW:
Hi
What is your Postgres-Version and with which programming
language are you connecting to the db?
greetings,
Martin
Am Mittwoch, den 29.06.2005, 11:49 +0200 schrieb Shay Kachlon:
> pgsql-performance@postgresql.org
---(end of broadcast)---
TIP 4
[Please copy the mailing list on replies so others can contribute
to and learn from the discussion.]
On Wed, Jun 29, 2005 at 12:29:42PM +0800, Chun Yit(Chronos) wrote:
>
> Yes, the function will delete records from the temporary table every time
> on each call.
> if leaving a lot of dead tuples,
I have been trying to diagnose a performance problem we have been seeing with
a postgres application. The performance of the database server is usually
quite good but every now and then it slows to a crawl. The output of vmstat
does not show excessive CPU usage or disk IO. The output of ps does
Emil Briggs <[EMAIL PROTECTED]> writes:
> When I see the slowdowns there are hundreds of these with no entry for
> relation or database. Any ideas what is being locked in this case?
Per the pg_locks documentation:
Every transaction holds an exclusive lock on its transaction ID for its
entire dur