Verify your knowledge

• If myfield is a varchar(200) field of a mytable table, will the statement create index on mytable(myfield) improve the query with a where condition like foo%?

  No, the statement above will not improve the query with a where condition like ‘foo%'; to make it possible, we have to use create index on mytable using btree(my field varchar_pattern_ops);. See the Exploring the pg_trgm extension section for more details.

• Is it possible to use indexes and all kinds of like and ilike queries?

  Yes, it’s possible using pg_trgm. See the Exploring the pg_trgm extension section for more details.

• What is point-in-time recovery (PITR)?

  Given retention, point-in-time recovery is the ability to restore to any point in the past. See the Disaster recovery with pgbackrest section for more details.

• Does PostgreSQL have a tool that can help us to manage continuous backups and point-in-time...