Reputation
201
Top tag
Next privilege 250 Rep.
View close votes
Badges
3 11
Newest
 Yearling
Impact
~11k people reached

Jun
9
awarded  Yearling
Jun
9
revised List MATERIALIZED VIEWs in PostgreSQL that do not have a UNIQUE index
Changed the code to only join UNIQUE indexes (as asked) by adding "and indisunique"
Jun
8
awarded  Commentator
Jun
8
comment List MATERIALIZED VIEWs in PostgreSQL that do not have a UNIQUE index
I eddited your code, adding a "and indisunique" to the WHERE. Hope thats OK. Now only UNIQUE indexes that can be used for REFRESH CONCURRENTLY wil be counted.
Jun
8
suggested approved edit on List MATERIALIZED VIEWs in PostgreSQL that do not have a UNIQUE index
Jun
8
comment List MATERIALIZED VIEWs in PostgreSQL that do not have a UNIQUE index
matviews_with_keys is listing all mat. views that have any index. For CONCURRENTLY to work, it must be UNIQUE indexes. (I will see if i get this improved...)
May
20
awarded  Curious
May
19
comment PostgreSQL operator uses index but underlying function does not
Dear jgm. Can you add a link and/or version number for the updated postgresql JDBC driver that allows escaping the ? please. I can't find a hint at jdbc.postgresql.org/documentation/changelog.html
May
19
comment List MATERIALIZED VIEWs in PostgreSQL that do not have a UNIQUE index
Very fast and very helpfull. Thanks for sharing!
May
19
accepted List MATERIALIZED VIEWs in PostgreSQL that do not have a UNIQUE index
May
19
awarded  Revival
May
19
awarded  Teacher
May
19
accepted Using Solr/Lucene for searching non-text tables?
May
19
answered Replace a materialized view in Postgres
May
19
revised Do I risk losing the benefits of indexing if I have an index on every column?
added 4 characters in body
May
19
asked List MATERIALIZED VIEWs in PostgreSQL that do not have a UNIQUE index
May
19
comment Materialized View PostgreSQL
It has been improved in 9.4, so you can REFRSH the view concurrently now, if it has any UNIQUE index. See depesz's article: depesz.com/2013/07/22/…
May
5
awarded  Notable Question
Jun
13
revised Why won't PostgreSQL 9.3 start on Ubuntu?
Added a link to PG 9.3 documentation
Jun
13
comment Why won't PostgreSQL 9.3 start on Ubuntu?
My PG9.3 did not start after reboot. Adding the line "unix_socket_directories='/var/run/postgresql'" to 9.3's postgresql.conf solved it. Thanks