12 ms·
To the article's author: I think you could go much deeper, and get into the discussion of what can be indexed and what can't, eg timestamp with or without timez
by gbog 13y ago
To the article's author: I think you could go much deeper, and get into the discussion of what can be indexed and what can't, eg timestamp with or without timezone, and how indexability of a column or a function affect the design of the schema itself.
One solution I found after many struggles was to require all event tables to have a timestamp with timezone column, index its date() and require all queries attacking these tables to be selective on the date.
- craigkerstiens 13y agoThere's definitely a lot deeper I can go on this, this is largely a test of a series which could go quite deep. My initial post yesterday simply highlighted one method of indexing and out of that came many of the questions in here. In general Postgres is pretty flexible with what you can index with not many limitations, its impact on the rest of the schema aren't always so simple so would love to hear what you have in mind as impact. Please feel free to drop me a line and would love to turn more of that into a deeper post.