Re: [PERFORM] Federated Postgresql architecture ?

2008-06-27 Thread Chris Browne
[EMAIL PROTECTED] (Josh Berkus) writes: > Jonah, > >> Hmm, I didn't think the Skype tools could really provide federated >> database functionality without a good amount of custom work. Or, am I >> mistaken? > > Sure, what do you think pl/proxy is for? Ah, but the thing is, it changes the model fr

[PERFORM] Sources of information about sizing of hardwares to run PostgreSQL

2008-06-27 Thread Sérgio R F Oliveira
Hi all, I need to specify servers and storage to run PostgreSQL. Does anyone know any source of information (articles, presentations, books, etc.) which describes methods of hardware sizing for running a large PostgreSLQ installation? Thank you in advance. Sergio. -- Sent via pgsql-performance

Re: [PERFORM] A guide/tutorial to performance monitoring and tuning

2008-06-27 Thread Scott Marlowe
On Fri, Jun 27, 2008 at 8:23 AM, Nikhil G. Daddikar <[EMAIL PROTECTED]> wrote: > Hello, > > I have been searching on the net on how to tune and monitor performance of > my postgresql server but not met with success. A lot of information is vague > and most often then not the answer is "it depends".

Re: [PERFORM] A guide/tutorial to performance monitoring and tuning

2008-06-27 Thread Andreas Kretschmer
Nikhil G. Daddikar <[EMAIL PROTECTED]> schrieb: > Hello, > > I have been searching on the net on how to tune and monitor performance > of my postgresql server but not met with success. A lot of information > is vague and most often then not the answer is "it depends". Can anyone > of you ref

[PERFORM] A guide/tutorial to performance monitoring and tuning

2008-06-27 Thread Nikhil G. Daddikar
Hello, I have been searching on the net on how to tune and monitor performance of my postgresql server but not met with success. A lot of information is vague and most often then not the answer is "it depends". Can anyone of you refer me a nice guide or tutorial on this? Thanks. -- Sent vi

Re: [PERFORM] Hardware vs Software RAID

2008-06-27 Thread Merlin Moncure
On Fri, Jun 27, 2008 at 7:00 AM, Matthew Wakeling <[EMAIL PROTECTED]> wrote: > On Thu, 26 Jun 2008, Merlin Moncure wrote: >> >> In addition there are many different types of flash (MLC/SLC) and the >> flash cells themselves can be organized in particular ways involving various >> trade-offs. > > Ye

Re: [PERFORM] Hardware vs Software RAID

2008-06-27 Thread Matthew Wakeling
On Thu, 26 Jun 2008, Merlin Moncure wrote: In addition there are many different types of flash (MLC/SLC) and the flash cells themselves can be organized in particular ways involving various trade-offs. Yeah, I wouldn't go for MLC, given it has a tenth the lifespan of SLC. The main issue is lo