On Thu, 2006-09-07 at 16:01 +0530, Nimesh Satam wrote:
> I noticed that the age of template0 is increasing very rapidly..Can
> you please let me know how we can control this and what causes
> such problems.
>
> We also noticed that the database slow downs heavily at a particular
> time..C
Hi,
Postgres Version used is 8.1.3
OS: Linux
'SELECT datname, age(datfrozenxid) FROM pg_database'
postgres | 1575xyz | 1073743934template1 | 1632template0 | 61540256
This is the command which I tried and got the above output, and the number is in
In response to "Nimesh Satam" <[EMAIL PROTECTED]>:
> Hi,
>
> Postgres Version used is 8.1.3
> OS: Linux
>
>
> 'SELECT datname, age(datfrozenxid) FROM pg_database'
>
> postgres | 1575
> xyz | 1073743934
> template1 | 1632
> template0 | 61540256
>
> T
Title: Message
I
would expect that the age of Template0 is increasing at the same rate as every
other database in your cluster. Transaction IDs are global across all
databases in the cluster, so as I understand it, executing a transaction in any
database will increase the age of all databas
On 9/7/06, Nimesh Satam <[EMAIL PROTECTED]> wrote:
We also noticed that the database slow downs heavily at a particular
time..Can you suggest any tools which will help in diagnosing the root cause
behiond the data load.
possible checkpoint? poorly formulated query? it could be any number
of t
On Tue, 2006-09-05 at 00:42 +0400, Roman Krylov wrote:
> Hi.
> My config:
> gentoo linux "2005.1" on amd64x2 in 64-bit mode,
> kernel 2.6.16.12
> glibc 3.3.5(NPTL),
> gcc 3.4.3.
> I had not used portage for building.
> I built two versions of postgres from sources:
> postgresql-8.1.4 native(64bit)
Hi,
We've been running our "webapp database"-benchmark again on mysql and
postgresql. This time using a Fujitsu-Siemens RX300 S3 machine equipped
with a 2.66Ghz Woodcrest (5150) and a 3.73Ghz Dempsey (5080). And
compared those results to our earlier undertaken Opteron benchmarks on
2.4GHz' So
Very nice!
The 3Ware cards have fallen far behind Areca it seems. They look close in
Raid 10 performance, but with RAID5 they get crushed.
I'm about to purchase 20 machines for the lab and I think this article
pushes me toward Woodcrest, though I think it's a short term decision with
quad core A
Hi!..
I noticed that the age of template0 is increasing very rapidly..Can you please let me know how we can control this and what causes such problems.
We also noticed that the database slow downs heavily at a particular time..Can you suggest any tools which will help in diagnosing the ro
