Re: [PERFORM] WAL in RAM

2011-10-29 Thread Scott Marlowe
On Sat, Oct 29, 2011 at 11:54 AM, Marcus Engene wrote: > The problem I have with battery backed raid controllers is the battery part. > They're simply not reliable and requires testing etc which I as a rather > insignificant customer at a generic datacenter cannot have done properly. I > have how

Re: [PERFORM] WAL in RAM

2011-10-29 Thread Marcus Engene
On 10/28/11 5:45 , Kevin Grittner wrote: Marcus Engene wrote: Every now and then I have write peaks which causes annoying delay on my website Does anyone here have any recommendations here? For our largest machines we put WAL on a RAID1 drive pair dedicated to that tas

Re: [PERFORM] application of KNN code to US zipcode searches?

2011-10-29 Thread Mark Stosberg
Hello, I want to report that I have now solved the challenges I ran into using KNN for US zipcode searching. I've found the new approach to not only be viable, but to benchmark about 3x faster for our own real-world application than the previous approach we used, involving cube_distance() and ear

Re: [PERFORM] Bad plan by Planner (Already resolved?)

2011-10-29 Thread Robins Tharakan
Thanks Tom! Regret the delay in reply, but two of the three guesses were spot-on and resolved the doubt. 8.4.9 does take care of this case very well. On 10/27/2011 01:27 AM, Tom Lane wrote: I suspect that you're just fooling yourself here, and the "optimized" query is no such thing. :) I act

Re: [PERFORM] SSL encryption makes bytea transfer slow

2011-10-29 Thread Heikki Linnakangas
On 28.10.2011 14:02, Albe Laurenz wrote: We selected a 30MB bytea with psql connected with "-h localhost" and found that it makes a huge difference whether we have SSL encryption on or off. Without SSL the SELECT finished in about a second, with SSL it took over 23 seconds (measured with \timing