Re: [PERFORM] Changing the random_page_cost default (was: cpu_tuple_cost)

2005-03-15 Thread Jeff Hoffmann
to PostgreSQL. A couple of questions like that can go a long way to coming up with better ballpark figures. -- Jeff Hoffmann [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [PERFORM] Simple query, 10 million records...MySQL ten times faster

2007-04-26 Thread Jeff Hoffmann
btree (lat_radians); CREATE INDEX long_radians ON test_zip_assoc USING btree (long_radians); Maybe I'm missing something, but wouldn't it be easier to just use PostGIS? Or failing that, using the vanilla built-in point type and an r-tree index? That's what r-tree indexes are made for. -- Jeff