Commit graph

22 commits

Author SHA1 Message Date
Julien Rouhaud
6e1a46d4cc Update copyright year. 2024-04-28 09:19:06 +08:00
Julien Rouhaud
0e5de14589 Always use the sphinx_rtd_theme theme 2023-12-06 14:29:47 +01:00
Wen-Ching Wei
460502943d Fix typos in docs and readme 2023-08-23 13:31:51 +08:00
Julien Rouhaud
9385d5e25e Fixup for index hiding patch.
Fix compatibility for pg12- servers, and while at it remove some uncessary
trailing whitespaces.
2023-03-23 17:09:35 +08:00
nutvii
351f14a79d Add support for hypothetically hide existing index on explain.
Add new list hideIndexes and develop new function by hypo_get_relation_info_hook.
User can hide or unhide existing index and hypothetical indexes.
When user set hide existing index and execute EXPLAIN, it will scan the same oid in hideIndexes and remove it to make query-plan can't use it.
Add regression tests for hiding existing indexes.
Update to version hypopg--1.4.0.
Provide simple examples of using the hide series functions in README.md.
Update doc about hypothetically hide existing indexes.
2023-03-23 09:49:53 +01:00
Julien Rouhaud
9605ba4580 Update copyright year. 2023-01-08 22:59:49 +08:00
Krzysztof Szularz
4fc6a7eadf Amend formatting in usage documentation
One output in `Manipulate hypothetical indexes` section was not indented properly.
2022-08-26 15:09:27 +02:00
Julien Rouhaud
8005133cd4 Update copyright year. 2022-01-16 12:57:30 +08:00
Julien Rouhaud
b97cb0ce45 Fix typo in the documentation. 2021-11-25 13:49:17 +08:00
Julien Rouhaud
99a0d0c4bf Document that debian/ubuntu have official hypopg packages.
Also fix the install documentation to mention Rocky Linux, as the community is
not supporting centos anymore.
2021-11-25 13:47:25 +08:00
Julien Rouhaud
6e2d7bfca1 Fix documentation to reflect that hypopg_list_indexes is now a view.
Thanks to Duc Hoang for the report.
2021-11-25 13:41:42 +08:00
Julien Rouhaud
29a669d864 Release 1.3.0 2021-06-04 15:39:12 +08:00
Julien Rouhaud
7e072c1f94 Release 1.2.0 2021-02-26 14:59:55 +08:00
Julien Rouhaud
119686936e Document which access methods are supported. 2021-01-22 21:02:38 +08:00
Julien Rouhaud
2bd376d6bd Change the Oid generator.
To avoid locking on pg_class (required to safely call GetNewOidWithIndex or
similar) and to be usable on a standby node, use the oids unused in the
FirstBootstrapObjectId / FirstNormalObjectId range rather than real oids.  For
performance, always start with the biggest oid lesser than FirstNormalObjectId.
This way the loop to find an unused oid will only happens once a single backend
has created more than ~2.5k hypothetical indexes.

For people needing to have thousands of hypothetical indexes at the same time,
we also allow to use the initial implementation that relies on real oids, which
comes with all the limitations mentioned above, with the new
hypopg.use_real_oids GUC.
2021-01-22 19:56:06 +08:00
Julien Rouhaud
5da0519a03 Update copyright year 2021-01-22 18:41:53 +08:00
Julien Rouhaud
d63c0634b8 Fix column name in documentation, thanks to Extortioner01 for the report. 2020-05-07 13:41:23 +02:00
Christoph Matthies
818441c584 Fix typos in hypothetical_indexes.rst 2020-02-23 17:08:05 +01:00
Julien Rouhaud
0a6d64a8e7 [doc] Emphasize hypopg extension on \dx output 2018-03-18 00:04:27 +01:00
Julien Rouhaud
e362adb953 Document basic usage 2018-03-17 23:28:59 +01:00
Julien Rouhaud
96a49c3804 Document installation 2018-03-17 22:30:46 +01:00
Julien Rouhaud
0de9755a68 Start the documentation 2018-03-17 00:10:06 +01:00