Re: [PERFORM] [PATCHES] Template0 age is increasing speedily.
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..Can you suggest any tools which will help in diagnosing the root cause behiond the data load. Hi, first of all: there is no need to cross post on 4 lists. If you have a performance problem, post on pgsql-performance. Second, please tell us which version of PostgreSQL on which operating system you're using. Diagnosing your problem might depend on which OS you use... Finally, explain what you mean by the age of template0 is increasing very rapidly, you mean the size is increasing? Bye, Chris. -- Chris Mair http://www.1006.org ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [PERFORM] [PATCHES] Template0 age is increasing speedily.
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 increasing pretty fast for template0. Please let me know if this a problem. Regards, Nimesh. On 9/7/06, Chris Mair [EMAIL PROTECTED] wrote: On Thu, 2006-09-07 at 16:01 +0530, Nimesh Satam wrote: I noticed that the age oftemplate0 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 root cause behiond the data load.Hi,first of all: there is no need to cross post on 4 lists.If you have a performance problem, post on pgsql-performance.Second, please tell us which version of PostgreSQL on which operating system you're using. Diagnosing yourproblem might depend on which OS you use...Finally, explain what you mean by the age of template0 isincreasing very rapidly, you mean the size is increasing? Bye,Chris.--Chris Mairhttp://www.1006.org
Re: [PERFORM] [PATCHES] Template0 age is increasing speedily.
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 This is the command which I tried and got the above output, and the number is increasing pretty fast for template0. Please let me know if this a problem. Short answer: no, this is not a problem. Long answer: http://www.postgresql.org/docs/8.1/interactive/manage-ag-templatedbs.html -- Bill Moran Collaborative Fusion Inc. IMPORTANT: This message contains confidential information and is intended only for the individual named. If the reader of this message is not an intended recipient (or the individual responsible for the delivery of this message to an intended recipient), please be advised that any re-use, dissemination, distribution or copying of this message is prohibited. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [PERFORM] [PATCHES] Template0 age is increasing speedily.
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 databases by 1. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nimesh SatamSent: Thursday, September 07, 2006 5:49 AMTo: Chris MairCc: pgsql-performance@postgresql.orgSubject: Re: [PERFORM] [PATCHES] Template0 age is increasing speedily. 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 increasing pretty fast for template0. Please let me know if this a problem. Regards, Nimesh. On 9/7/06, Chris Mair [EMAIL PROTECTED] wrote: On Thu, 2006-09-07 at 16:01 +0530, Nimesh Satam wrote: I noticed that the age oftemplate0 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 root cause behiond the data load.Hi,first of all: there is no need to cross post on 4 lists.If you have a performance problem, post on pgsql-performance.Second, please tell us which version of PostgreSQL on which operating system you're using. Diagnosing yourproblem might depend on which OS you use...Finally, explain what you mean by "the age of template0 isincreasing very rapidly", you mean "the size is increasing"? Bye,Chris.--Chris Mairhttp://www.1006.org
Re: [PERFORM] [HACKERS] Template0 age is increasing speedily.
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 things. use standard tools to diagnose the problem, including: unix tools: top, vmstat, etc postgresql query logging, including min_statement_duration explain analyze ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [PERFORM] 64bit vs 32bit build on amd64
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) and 32-bit with CFLAGS=... -m32, and LD = /usr/x86_64-pc-linux-gnu/bin/ld -melf_i386 in src/Makefile.global. 32-bit build runs much faster than 64 apparently. What benchmark utility should I run to provide more concrete info (numbers)? What could be the reason of that difference in performance? I am also interested in 32-bit versus 64-bit performance. If I only have 4GB of RAM, does it make sense to compile postgresql as a 64-bit executable? I assume there's no reason for PostgreSQL's shared buffers, etc., to add up to more than 2GB on a system with 4GB of RAM. Is there a general consensus on the matter, or is it highly application- dependent? I am not doing any huge amount of 64-bit arithmetic. I am using Woodcrest, not Opteron. Regards, Jeff Davis ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[PERFORM] Xeon Woodcrest/Dempsey vs Opteron Socket F/940 with postgresql and some SAS raid-figures
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' Socket F- and 940-versions (2216, 280). You can see the english translation here: http://tweakers.net/reviews/646 The Woodcrest is quite a bit faster than the Opterons. Actually... With Hyperthreading *enabled* the older Dempsey-processor is also faster than the Opterons with PostgreSQL. But then again, it is the top-model Dempsey and not a top-model Opteron so that isn't a clear win. Of course its clear that even a top-Opteron wouldn't beat the Dempsey's as easily as it would have beaten the older Xeon's before that. Again PostgreSQL shows very good scalability, so good even HyperThreading adds extra performance to it with 4 cores enabled... while MySQL in every version we tested (5.1.9 is not displayed, but showed similar performance) was slower with HT enabled. Further more we received our ordered Dell MD1000 SAS-enclosure which has 15 SAS Fujitsu MAX3036RC disks and that unit is controlled using a Dell PERC 5/e. We've done some benchmarks (unfortunately everything is in Dutch for this). We tested varying amounts of disks in RAID10 (a set of 4,5,6 and 7 2-disk-mirrors striped), RAID50 and RAID5. The interfaces to display the results are in a google-stylee beta-state, but here is a list of all benchmarks done: http://tweakers.net/benchdb/search?query=md1000ColcomboID=5 Hover over the left titles to see how many disks and in what raid-level was done. Here is a comparison of 14 disk RAID5/50/10's: http://tweakers.net/benchdb/testcombo/wide/?TestcomboIDs%5B1156%5D=1TestcomboIDs%5B1178%5D=1TestcomboIDs%5B1176%5D=1DB=NieuwsQuery=Keyword For raid5 we have some graphs: http://tweakers.net/benchdb/testcombo/1156 Scroll down to see how adding disks improves performance on it. The Areca 1280 with WD Raptor's is a very good alternative (or even better) as you can see for most benchmarks, but is beaten as soon as the relative weight of random-IO increases (I/O-meter fileserver and database benchmarks), the processor on the 1280 is faster than the one on the Dell-controller so its faster in sequential IO. These benchmarks were not done using postgresql, so you shouldn't read them as absolute for all your situations ;-) But you can get a good impression I think. Best regards, Arjen van der Meijden Tweakers.net ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[PERFORM] Template0 age is increasing speedily.
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 root cause behiond the data load. Regards, Nimesh.