Show HN: PostgreSQL index advisor
399 by kiwicopple | 95 comments on Hacker News.
This is a Postgres extension that can determine if a query should have an index. For example, for this table: create table book( id int primary key, title text not null ); You can run `index_advisor()` to see if there should be an index on a select statement: select * from index_advisor('select book.id from book where title = $1'); And it will return (summarized): {"CREATE INDEX ON public.book USING btree (title)"} It works particularly well with pg_stat_statements[0] which tracks execution statistics of all SQL statements executed on your Postgres database. It leans heavily on HypoPG[1], an excellent extension to determine if PostgreSQL will use a given index without spending resources to create them. [0] pg_stat_statements: https://ift.tt/Sz1mBA9... [1] https://ift.tt/YIer6Tj
New best story on Hacker News: The Worst Website in the Entire World
The Worst Website in the Entire World 386 by speckx | 187 comments on Hacker News.
-
рдмोрд░्рдбा рдпेрдеीрд▓ рдорд╣िрд▓ा рд╕рд░рдкंрдЪाрд╡рд░ рдЕрд╡िрд╢्рд╡ाрд╕ рдард░ाрд╡ рдоंрдЬूрд░ рд╡рд░ोрд░ा рд╢рд╣рд░ा рд▓рдЧрдд рдЕрд╕рд▓ेрд▓ी рдмोрд░्рдбा рдЧ्рд░ाрдордкंрдЪाрдпрдд рд╣ी рд╡िрдХрд╕िрдд рдЖрдгि рдЕрдзिрдХ рдорд╣рд╕ूрд▓ рдЕрд╕рд▓ेрд▓ी рдЧ्рд░ाрдордк...
-
рдЯ्рд░ॅрдХ्рдЯрд░рдЪ्рдпा рдЕрдкрдШाрддाрдд рдЪाрд▓рдХाрдЪा рдоृрдд्рдпू рдкाрд╡рдиा рдЧाрд╡ाрдЬрд╡рд│ीрд▓ рдШрдЯрдиा рд╕ंрдкाрджрдХ / рддुрд▓рд╕ीрджाрд╕ рдЕрд▓ाрдо рднрдж्рд░ाрд╡рддी - рдЯ्рд░ॅрдХ्рдЯрд░рдЪे рд╕рдоोрд░рдЪे рдПрдХ рдЪाрдХ рдЕрдЪाрдирдХ рдиि...
-
рд╕рд░рдкंрдЪा рд╡िрд░ोрдзाрдд рдЕрд╡िрд╢्рд╡ाрд╕ рдард░ाрд╡ рдоांрдбрд▓ा рддрд╕ीрд▓рджाрд░ांрдиी рд╕рд░рдкंрдЪाрд▓ा рдХेрд▓े рдЕрдкाрдд्рд░ рдШोрд╖िрдд рд╕рднेрддूрди рдмाрд╣ेрд░ рдиिрдШाрд▓्рдпाрдиंрддрд░ рдЙрдкрд╕рд░рдкंрдЪाрдиी рдХेрд▓ी рдЕрдкाрдд्рд░ рд╕рд░рдкंрдЪाрд▓ा рд╢िрд╡ी...