Re: [ADMIN] Postgresql performance and tuning questions

2006-02-16 Thread Ang Chin Han
On 2/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > SuSE always only do backports of fixes and never increase the version > number. They only appended a self made "build" number which increases. > So it is really possible that all the fixes are in while the version > stays the same. Not tr

Re: [ADMIN] Postgresql performance and tuning questions

2006-02-16 Thread Scott Marlowe
On Thu, 2006-02-16 at 10:39, Tomeh, Husam wrote: > I do understand your school of thinking. But let me say this, from just > a user point of view who had used 7.4.x, 8.0, and 8.1, I'd highly > recommend to start off with 8.1. I can comment on performance in > particular among other great stuff suc

Re: [ADMIN] Postgresql performance and tuning questions

2006-02-16 Thread Tomeh, Husam
before we begin to use, observe, and experience Postgres of our own? Thanks, Bob -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Friday, February 10, 2006 10:16 AM To: Given, Robert A Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Postgresql performance and tuning

Re: [ADMIN] Postgresql performance and tuning questions

2006-02-11 Thread Tom Lane
[EMAIL PROTECTED] writes: > Zitat von Scott Marlowe <[EMAIL PROTECTED]>: >> But you're not running the least buggy version of the 7.4 branch. The >> 7.4 branch is up to 7.4.9. If you are runing 7.4.2 then you haven't >> installed all the updates supplied by Suse for their distribution (or >> Suse

Re: [ADMIN] Postgresql performance and tuning questions

2006-02-11 Thread lst_hoe01
Zitat von Scott Marlowe <[EMAIL PROTECTED]>: But you're not running the least buggy version of the 7.4 branch. The 7.4 branch is up to 7.4.9. If you are runing 7.4.2 then you haven't installed all the updates supplied by Suse for their distribution (or Suse backports bug fixes from 7.4.9 to 7.4

Re: [ADMIN] Postgresql performance and tuning questions

2006-02-10 Thread Scott Marlowe
ilto:[EMAIL PROTECTED] > Sent: Friday, February 10, 2006 10:16 AM > To: Given, Robert A > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] Postgresql performance and tuning questions > > "Given, Robert A" <[EMAIL PROTECTED]> writes: > > We are beginning a

Re: [ADMIN] Postgresql performance and tuning questions

2006-02-10 Thread Tom Lane
"Given, Robert A" <[EMAIL PROTECTED]> writes: > Our philosophy is to use products that have been established, tested and > stable. We tend to not go with newer versions until they have time to > mature and have the bugs worked out. This is the version of the DB that > was packaged with the version

Re: [ADMIN] Postgresql performance and tuning questions

2006-02-10 Thread Given, Robert A
, and experience Postgres of our own? Thanks, Bob -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Friday, February 10, 2006 10:16 AM To: Given, Robert A Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Postgresql performance and tuning questions "Given, Robert

Re: [ADMIN] Postgresql performance and tuning questions

2006-02-10 Thread Tom Lane
"Given, Robert A" <[EMAIL PROTECTED]> writes: > We are beginning a project to use Postgresql 7.4.2 on zLinux SLES9 > The application of interest is uPortal 2.4.3. Why are you not starting with a reasonably up-to-date version of Postgres? regards, tom lane

[ADMIN] Postgresql performance and tuning questions

2006-02-10 Thread Given, Robert A
Title: Postgresql performance and tuning questions Greetings, We are beginning a project to use Postgresql 7.4.2 on zLinux SLES9 The application of interest is uPortal 2.4.3. I'm interested in learning about any changes you've made to your Postgresql DB to prepare it for uPortal? What s