Re: [PERFORM] PostgreSQL Configuration Tool for Dummies

2007-06-20 Thread Kevin Hunter
At 4:35p -0400 on 19 Jun 2007, Lance Campbell wrote: The parameters I would think we should calculate are: max_connections shared_buffers work_mem maintenance_work_mem effective_cache_size random_page_cost From an educational/newb standpoint, I notice that the page currently spews out a confi

Re: [PERFORM] Feature Request --- was: PostgreSQL Performance Tuning

2007-04-30 Thread Kevin Hunter
At 12:18p -0400 on 30 Apr 2007, Craig A. James wrote: 1. Generating a resonable starting configuration for neophyte users who have installed Postgres for the first time. I recognize that PostgreSQL and MySQL try to address different problem-areas, but is this one reason why a lot of people w

Re: [PERFORM] Feature Request --- was: PostgreSQL Performance Tuning

2007-04-27 Thread Kevin Hunter
At 10:36a -0400 on 27 Apr 2007, Tom Lane wrote: That's been proposed and rejected before, too; the main problem being that initdb is frequently a layer or two down from the user (eg, executed by initscripts that can't pass extra arguments through, even assuming they're being invoked by hand in th

Re: [PERFORM] DB benchmark and pg config file help

2007-01-19 Thread Kevin Hunter
On 19 Jan 2007 at 10:56a -0600, Bruno Wolff III wrote: On Fri, Jan 19, 2007 at 09:05:35 -0500, Kevin Hunter <[EMAIL PROTECTED]> wrote: Seriously though, that would have bitten me. Thank you, I did not know that. Does that mean that I can't publish the results outside of my wo

Re: [PERFORM] DB benchmark and pg config file help

2007-01-19 Thread Kevin Hunter
On 19 Jan 2007 at 8:45a -0500, Merlin Moncure wrote: On 1/17/07, Kevin Hunter [hunteke∈earlham.edu] wrote: I am in the process of learning some of the art/science of benchmarking. Given novnov's recent post about the comparison of MS SQL vs PostgresQL, I felt it time to do a benc

[PERFORM] DB benchmark and pg config file help

2007-01-17 Thread Kevin Hunter
Hello List, Not sure to which list I should post (gray lines, and all that), so point me in the right direction if'n it's a problem. I am in the process of learning some of the art/science of benchmarking. Given novnov's recent post about the comparison of MS SQL vs PostgresQL, I felt it ti

Re: [PERFORM] [NOVICE] Partitioning

2006-12-26 Thread Kevin Hunter
On 26 Dec 2006 at 2:55p -0500, Tom Lane wrote: Kevin Hunter <[EMAIL PROTECTED]> writes: A friend has asked me about creating a unique table for individual users that sign up for his site. (In essence, each user who signs up would essentially get a set of CREATE TABLE {users,friends,