Re: [ADMIN] Where is my bottleneck?

Hi Arnau, >> - Is all the memory used by postgres ? > I'm not sure how to look at that (how could I do it?). In TOP you can see how much memory is used by postmaster process'es. > SD22-SINER5:~# top > top - 15:09:50 up 453 days, 11:47, 3 users, load average: 4.08, 3.90, 2.64 > Tasks: 70 to

Re: [ADMIN] Where is my bottleneck?

Hi Arnau, Poor performance on idle cpu is normally due to an I/O bottleneck. The bottleneck can be either network (unlikely but easy to check) or disk i/o. Excessive disk i/o can be caused by memory starvation or maybe you just need to move a lot of data. Adding memory will give you more cache spac

Re: [ADMIN] Server Hardware Configuration

Performance questions are terrible to answer because we all use our systems in different ways. Here's my 2 bits for what they're worth. > The idea behind the first is to keep the > entire database in memory, by way of the disk cache. What you describe is a real-time system. Does your requireme

Re: [ADMIN] Backup

Hi, I have a 61Gig base at the moment and do a full online backup each night. It's not really that much of a strain so I haven't bothered with cooking up a scheme for differential backups. Using my simple scripts it takes one hour and in my case I end up with 2.5Gigs (compressed) worth of backup fi

Re: [ADMIN] Question

First its bad style to use a generic subject like "Question". Use something related to the specific problem. "Help" is an other poor choice. Second you need to put in a lot more information about your setup. As an absolute minimum provide postgresql release and operating system. Third it sounds l

Re: [ADMIN] who is best for support?

Hi Joel, I'm running on a more or less similar hw config and my speed is pretty ok. My base is currently weighing in at 50Gig. You may be having problems with the query itself. Aside from index'es how you construct the query can have a dramatic impact on execution time. I can highly recommend th

Re: [ADMIN] Setting up data on two drives newb version. left

Bruce Momjian has an other interesting manual on hardware performance tuning: http://candle.pha.pa.us/main/writings/pgsql/hw_performance/index.html It covers a lot of the same ground plus some other goodies. /John >>> "Joel Fradkin" <[EMAIL PROTECTED]> 12-02-2005 16:22:28 >>> This was also in t

Re: [ADMIN] Win32 Postgresql Command Line Password

This might not apply to the win32 version. But in the Unix version you can put this information in a .pgpass file. This enables you to keep passwords on all user accounts and still be able to automate tasks. There is a number of permission/ownership requirements on this file in the Unix version. T

Re: [ADMIN] Problem with permanent connections from Tomcat

Hi, An elegant solution to this problem is to instruct the Tomcat developers to use conection-pooling datasources. That way their Tomcat server takes care of the connection pool and terminates idle connections when they time out. This way Tomcat also tear down its connections when it's shut down.

Re: [ADMIN] i need it

You can also try reading the book: Practical PostgreSQL. You can find it online at: http://www.faqs.org/docs/ppbook/book1.htm /John >>> Bruno Wolff III <[EMAIL PROTECTED]> 24-12-2004 17:29:30 >>> On Tue, Dec 21, 2004 at 18:51:22 +0300, advanced techno medical <[EMAIL PROTECTED]> wrote: Have y

Re: [ADMIN] Backup is too slow

tem snapshot, then release the locks. I'm sure Tom, Josh or someone more in the know would have imput for this option. Greg -Original Message- From: John Jensen [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 07, 2004 6:48 AM To: [EMAIL PROTECTED] Subject: [ADMIN] Backup is too s

[ADMIN] Backup is too slow

Hi all, I'm a bit unhappy with the time it takes to do backup of my PG7.4.6 base. I have 13GB under the pg/data dir and it takes 30 minutes to do the backup. Using top and iostat I've figured out that the backup job is cpu bound in the postmaster process. It eats up 95% cpu while the disk is at 10