Re: [ADMIN] open source ERD for postgresql database

2008-09-16 Thread Thomas Jacob
Looks interesting, how well does MICRO-OLAP support the full range of PostgreSQL's types? Things like "cidr" for instance. On Mon, 2008-09-15 at 15:06 -0400, Anibal David Acosta wrote: > MICRO-OLAP Database designer for postgres is a great tool. > > > > -Mensaje original- > De: [EMAIL

[ADMIN] Help request: how to tune performance?

2008-09-16 Thread Mauri Sahlberg
Hi, We just upgraded Best Practical's RT from 3.6 to 3.81 and gave the database completely own machine. And the users still complain that it is dog slow. :-( I installed pg_top and it seems that at the beginning of the ticket display RT-issues a query that eats everything the database has. Query i

Re: [ADMIN] Heavy postgres process

2008-09-16 Thread Vivek_Sharan
Thanks for the information so far My Application runs on FreeBSd box and main technological component are Apache and mod Perl, database is postgres. I have already scanned pg_stat_activity and pg_listener table but could get any clue. Pg_stat_activity shows list of all idle processes but command

[ADMIN] pgBee - a Postgresql Bulk Updater in Java

2008-09-16 Thread Michael Nacos
"pgBee is a set of Java classes I wrote for automating bulk updates of Postgresql databases on Linux servers. It requires Java (doh!) and Ant (as a build/execute front-end), it is cronnable and performs very well, especially in multi-threaded mode, which takes full advantage of multi-core CPUs in m

Re: [ADMIN] Heavy postgres process

2008-09-16 Thread Guido Barosio
On Tue, Sep 16, 2008 at 1:41 AM, Vivek_Sharan <[EMAIL PROTECTED]> wrote: > Thanks for the information so far > My Application runs on FreeBSd box and main technological component are > Apache and mod Perl, database is postgres. I have already scanned > pg_stat_activity and pg_listener table but c

[ADMIN] Setting Effective Cache Size

2008-09-16 Thread kevin kempter
Hi All; Is there an easy way to determine the actual OS disk cache size or at least a set of guidelines based on the OS and disk subsystem type ? Thanks in advance... /Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.

Re: [ADMIN] Help request: how to tune performance?

2008-09-16 Thread Scott Marlowe
On Tue, Sep 16, 2008 at 2:31 AM, Mauri Sahlberg <[EMAIL PROTECTED]> wrote: > Hi, > > We just upgraded Best Practical's RT from 3.6 to 3.81 and gave the > database completely own machine. And the users still complain that it is > dog slow. Moved up from below: > Version : 8.1.11

Re: [ADMIN] Heavy postgres process

2008-09-16 Thread Scott Marlowe
On Tue, Sep 16, 2008 at 8:37 AM, Guido Barosio <[EMAIL PROTECTED]> wrote: > On Tue, Sep 16, 2008 at 1:41 AM, Vivek_Sharan <[EMAIL PROTECTED]> wrote: >> Thanks for the information so far OK, I'm not BSD expert (Tom Lane might help out here) but I'm guessing that what we see in the following lines o

Re: [ADMIN] Setting Effective Cache Size

2008-09-16 Thread Scott Marlowe
On Tue, Sep 16, 2008 at 9:30 AM, kevin kempter <[EMAIL PROTECTED]> wrote: > Hi All; > > Is there an easy way to determine the actual OS disk cache size or at least > a set of guidelines based on the OS and disk subsystem type ? On a DB only machine, you can expect the OS to use most of the spare m

Re: [ADMIN] Help request: how to tune performance?

2008-09-16 Thread Kenneth Marshall
On Tue, Sep 16, 2008 at 11:10:01AM -0600, Scott Marlowe wrote: > On Tue, Sep 16, 2008 at 2:31 AM, Mauri Sahlberg > <[EMAIL PROTECTED]> wrote: > > Hi, > > > > We just upgraded Best Practical's RT from 3.6 to 3.81 and gave the > > database completely own machine. And the users still complain that it

[ADMIN] Postgres && Swap

2008-09-16 Thread steve
Hi All I recently made a change to my Postgres Server and upped the max_fsm_page size to 6 Since then, Postgres has been using about 30-80MB of swap space. This box has 4GB of RAM. All up Postgres has not been allocated no more than 3G Is this swapping something to be worried about? Chee

Re: [ADMIN] Postgres && Swap

2008-09-16 Thread Scott Marlowe
On Tue, Sep 16, 2008 at 11:30 PM, <[EMAIL PROTECTED]> wrote: > Hi All > > > I recently made a change to my Postgres Server and upped the max_fsm_page > size to 6 > Since then, Postgres has been using about 30-80MB of swap space. > > This box has 4GB of RAM. All up Postgres has not been allocat