| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Milen A(dot) Radev" <milen(at)securax(dot)org> |
| Cc: | Michael Fuhr <mike(at)fuhr(dot)org>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Too frequent warnings for wraparound failure |
| Date: | 2005-03-11 16:40:11 |
| Message-ID: | 3233.1110559211@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-hackers |
"Milen A. Radev" <milen(at)securax(dot)org> writes:
> Tom Lane wrote:
>> So you managed to execute about 6000 transactions in those two seconds.
>> Doing what?
> Well that could be the problem - I'm 99.99% positive we do not execute
> so many transactions - may be 30-40 thousand per day and that's only for
> one relatively busy DB. The example database ("xxx1") you've chosen is
> not used at all. As most of the other databases in that cluster.
It doesn't matter --- all the age counts are going up at exactly the
same rate. Somewhere you've got a client that's issuing dummy
transaction starts at an insane rate. Some attention to "top" output
on the server might help identify it ;-)
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-03-11 16:42:53 | Re: [HACKERS] PostgreSQL pam ldap document |
| Previous Message | John DeSoi | 2005-03-11 15:41:54 | Re: Restoring a Dump with psql on Windows Fails - Password Cannot Be Entered (?) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-03-11 16:42:53 | Re: [HACKERS] PostgreSQL pam ldap document |
| Previous Message | Bruce Momjian | 2005-03-11 16:32:04 | Re: TODO item: support triggers on columns |