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.
