+1 On Thursday, August 28, 2014 9:20:54 PM UTC-4, Gisborne wrote: > > I was thinking of doing a talk about optimal indexing. This talk would be > useful if any of these things are unclear to you: > > - why an index on a Boolean field is very likely useless; > - why many or most of your indexes should be compound indexes; > - why the order of the field in your compound indexes is very important; > - why you might want compound indexes that include fields you never search > on; > - what the different types of indexes are (the one that most people are > unaware of is the difference between GIST and GIN indexes in Postgres) > > Is this a talk that would interest a reasonable proportion of our number? > I could probably have this talk ready for the next meeting if that worked > out, otherwise I guess this would be for October. > > I am also between clients right now. I was thinking of offering a > short-term consultancy service where I come look at your queries and your > logs and I try to improve the efficiency of particularly database-bound > parts of your application. Is that a thing anyone would be interested in? > It might just be a few hours at a time is all it takes. > > Regards, > > Guyren G Howe > Relevant Logic LLC > > guyren-at-relevantlogic.com ~ http://relevantlogic.com ~ +1 512 784 3178 > > Ruby/Rails, Xojo, PHP programming > PostgreSQL, MySQL database design and consulting > Technical writing and training >
-- -- SD Ruby mailing list [email protected] http://groups.google.com/group/sdruby --- You received this message because you are subscribed to the Google Groups "SD Ruby" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
