Re: [GENERAL] Best practice to get performance

2010-11-19 Thread Ivan Voras
On 11/19/10 23:14, Andy Colson wrote: On 11/19/2010 4:04 PM, Ivan Voras wrote: On 11/19/10 15:49, Andy Colson wrote: unlogged will only help insert/update performance. Lookup tables sound readonly for a majority of time. (I'm assuming lots of reads and every once and a while updates). I doubt

Re: [GENERAL] Best practice to get performance

2010-11-19 Thread Andy Colson
On 11/19/2010 4:04 PM, Ivan Voras wrote: On 11/19/10 15:49, Andy Colson wrote: unlogged will only help insert/update performance. Lookup tables sound readonly for a majority of time. (I'm assuming lots of reads and every once and a while updates). I doubt that unlogged tables would speed up loo

Re: [GENERAL] Best practice to get performance

2010-11-19 Thread Ivan Voras
On 11/19/10 15:49, Andy Colson wrote: unlogged will only help insert/update performance. Lookup tables sound readonly for a majority of time. (I'm assuming lots of reads and every once and a while updates). I doubt that unlogged tables would speed up lookup tables. Are FreeBSD's temp tables st

Re: [GENERAL] Best practice to get performance

2010-11-19 Thread Andy Colson
On 11/18/2010 4:56 PM, Fredric Fredricson wrote: Hi, I have designed a handful databases but is absolutely no SQL-expert. Nor have I had any formal database training and have never worked with someone who had. What I know about SQL I have read in the documentation, found with google, and learned

Re: [GENERAL] Best practice to get performance

2010-11-18 Thread John R Pierce
On 11/18/10 2:56 PM, Fredric Fredricson wrote: What puzzle me though is that this use is never mentioned in the discussions, at least as far as I can see. Am I doing something "strange"? Is this something you should not have to do if you have "proper" database design? in certain other enter

[GENERAL] Best practice to get performance

2010-11-18 Thread Fredric Fredricson
Hi, I have designed a handful databases but is absolutely no SQL-expert. Nor have I had any formal database training and have never worked with someone who had. What I know about SQL I have read in the documentation, found with google, and learned from my numerous mistakes. This question I ha