Verify your knowledge
- If
myfieldis avarchar(200)field of amytabletable, will the statementcreate index on mytable(myfield)improve the query with awherecondition likefoo%?No, the statement above will not improve the query with a
wherecondition like ‘foo%'; to make it possible, we have to usecreate 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
likeandilikequeries?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...
