Skip site navigation (1) Skip section navigation (2)

Re: Call for meeting topics! Next meeting: January 17

From: "Hu, William" <HuW(at)trimet(dot)org>
To: "Jeff Davis" <pgsql(at)j-davis(dot)com>,"Selena Deckelmann" <selenamarie(at)gmail(dot)com>
Cc: "Postgresql PDX_Users" <pdxpug(at)postgresql(dot)org>
Subject: Re: Call for meeting topics! Next meeting: January 17
Date: 2008-01-04 01:58:50
Message-ID: 3A218E3A521D4349B37D2880AAD684C3E160C8@csmail4.tri-met.org (view raw or flat)
Thread:
Lists: pdxpug
Hi Guys,

I work at TriMet as a programmer analyst.  We have installed some open
source applications and on the process of implementing more open source
applications.  During the process, we have stayed with postgresql
database as the backend.  Recently, I recognized that we have to
consolidate all the separate postgresql databases for easy maintenance
while still keeping the development, test, and production environments.
My plan is to create 3 database servers as pgdev, pgtest, and pgprod.
Each database server will host multiple databases for their
applications.  For example, a point of sales application will have a POS
database in pgdev, pgtest, and pgprod.  While a CMS Plone application
will have a Plone database in pgdev, pgtest, and pgprod.

I am interested learning from you about the following:
1.) Size of the databases you have? 
2.) Number of database users? Number of application users? Number of
concurrent users?
3.) How you have set the size of shared memory of the database server?
Any other performance issues?
4.) Can you create cross database/schema reference in Postgresql?
similar like Oracle's synonymous.
5.) Have you tried convert Oracle PL/SQL into pgPL/SQL?  How about
triggers?  
6.) Postgresql database backup and restore using text or non-text files?
Eg, psql dbname < backup_file vs. pg_restore
7.) Database vacuum flags, such as the one for the ANALYZE option, can
we use it during production hours?
8.) Any security features you may have implemented in addition to the
user, group or roles?

Regards,

William Hu

-----Original Message-----
From: pdxpug-owner(at)postgresql(dot)org [mailto:pdxpug-owner(at)postgresql(dot)org]
On Behalf Of Jeff Davis
Sent: Thursday, January 03, 2008 5:27 PM
To: Selena Deckelmann
Cc: Postgresql PDX_Users
Subject: Re: [pdxpug] Call for meeting topics! Next meeting: January 17

On Thu, 2008-01-03 at 14:04 -0800, Selena Deckelmann wrote:
> Happy new year!!
> 
> We have a meeting in exactly two weeks.
> 
> Any projects you're working on that you'd like to share? Updates on 
> projects you were working on last year? Some interesting topic from a 
> class you can share?  Please, send a meeting topic proposal.
> 
> I'd love to create a list of presentations for the next several
months.
> 
> I can offer:  PostgreSQL Version 8.3: 10 new things you can use right 
> now

I'd be interested to do a talk on the Relational Model (Note: not the
same as the Relational Algebra talk by James and Rafael, but related).

Is there any interest in that?

Regards,
	Jeff Davis


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

In response to

pdxpug by date

Next:From: Rich ShepardDate: 2008-01-04 14:51:23
Subject: Aliases for Field Names in SELECT statements
Previous:From: Jeff DavisDate: 2008-01-04 01:48:51
Subject: Re: Call for meeting topics! Next meeting: January 17

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group