OSDN Git Service
summary |
shortlog | log |
commit |
commitdiff |
tree
first ⋅ prev ⋅ next
Masahiko Sawada [Tue, 8 Sep 2015 12:27:22 +0000 (21:27 +0900)]
Add the news about the release of 1.0-
20150910.
Backpatch to all branches.
Masahiko Sawada [Tue, 8 Sep 2015 12:07:30 +0000 (21:07 +0900)]
Update BIGM_LAST_UPDATE.
Update to '2015.09.10'.
Masahiko Sawada [Tue, 8 Sep 2015 11:57:26 +0000 (20:57 +0900)]
Fix the link on top page.
MasaoFujii [Wed, 2 Sep 2015 02:17:05 +0000 (11:17 +0900)]
Improve document about the setting to preload pg_bigm shared library to server.
This commit adds the description explaining that, in PostgreSQL 9.4 or later,
session_preload_libraries parameter instead of shared_preload_libraries can
be used to specify the pg_bigm shared library to preload to the server, into
the document.
Backpatch to 1.1 where 9.4 is supported.
Reviewed by Amit Langote
MasaoFujii [Thu, 27 Aug 2015 19:20:58 +0000 (04:20 +0900)]
First-draft release notes for new minor version of 1.1.
MasaoFujii [Wed, 26 Aug 2015 17:53:01 +0000 (02:53 +0900)]
Improve the comparison table of pg_trgm and pg_bigm in the document.
This patch adds the information about the difference of available
text search operators in pg_trgm and pg_bigm into the comparison
table.
Back-patch to all supported versions.
Reviewed by Masahiko Sawada.
MasaoFujii [Tue, 25 Aug 2015 22:20:22 +0000 (07:20 +0900)]
Minor improvement to English version of pg_gin_pending_stats documentation.
MasaoFujii [Fri, 14 Aug 2015 10:09:05 +0000 (19:09 +0900)]
Make pg_gin_pending_stats() check whether given relation is a GIN index.
Previously pg_gin_pending_stats() didn't do such a check, so it could
return an improper and irrelevant result when non-GIN index was specified.
This is a bug. This patch changes pg_gin_pending_stats() so that it exits
with an error when the given relation is not a GIN index.
Also this patch prevents pg_gin_pending_stats() from reading non-local
temporary relations.
Back-patch to all supported versions.
MasaoFujii [Tue, 28 Jul 2015 13:27:51 +0000 (22:27 +0900)]
Update URLs that pointed to sourceforge.jp.
The URL of site in which pg_bigm project is hosted was changed from
sourceforge.jp to osdn.jp. This patch applies this change to HTML files.
MasaoFujii [Tue, 7 Apr 2015 15:28:36 +0000 (00:28 +0900)]
Remove unnecessary leading white space from .gitignore.
MasaoFujii [Fri, 3 Apr 2015 04:51:23 +0000 (13:51 +0900)]
Use more proper formula to calculate the number of bigram entries.
Previously we used the formula that we just borrowed from pg_trgm code,
to calculate the number of bigram entries. Based on the result of that
calculation we allocated the memory to store the bigram entries.
That borrowed formula was not incorrect, but not precise. It caused us to
allocate too much memory than necessary, and which limited the maximum
allowed size of column indexed by pg_bigm to smaller number.
This commit makes the formula more proper, and increases the column
limitation size to about 102MB. Also this installs some checks that the input
string length is not so large as to cause overflow in the calculations of
palloc request sizes. The addition of these checks was inspired by
the pg_trgm related commit
c3ccc9e.
This change is simple and useful to alleviate the column size limitation.
So back-patch to all supported versions.
Beena Emerson, reviewed by me.
MasaoFujii [Thu, 19 Mar 2015 03:29:11 +0000 (12:29 +0900)]
Add missing <p> HTML tag to Japanese version of document.
Back-patch to all supported versions.
MasaoFujii [Wed, 18 Mar 2015 20:47:52 +0000 (05:47 +0900)]
Update the document about the column size limitation.
The commit
5a63dd82c954dcead2616d04ac81d46947a8f6ea increased the maximum
allowed size of column indexed by pg_bigm to about 68MB.
Back-patch to all supported versions.
MasaoFujii [Wed, 18 Mar 2015 20:24:10 +0000 (05:24 +0900)]
Use INT8 to store the byte length of bi-gram string in "bigm" struct.
"bigm" struct has the field "bytelen" which indicates the byte length of
bi-gram string. Previously the data type of that field was INT. This commit
changes the data type to INT8 because the byte length of bi-gram string is
eight bytes at most and INT8 is enough large to indicate that length.
This change is useful to increase the maximum allowed size of the column
indexed by pg_bigm.
This change is cost-effective, i.e., simple but can alleviate the limitation of
the column size very much. So per discussion we decided to back-patch this to
all supported versions.
Beena Emerson, original idea from Sawada Masahiko.
MasaoFujii [Fri, 13 Mar 2015 21:52:26 +0000 (06:52 +0900)]
Fix compiler warning with -Wmissing-variable-declarations.
Back-patch to all supported versions.
MasaoFujii [Fri, 13 Mar 2015 21:41:27 +0000 (06:41 +0900)]
Fix compilation failure on Apple LLVM 6.0.
This commit adds missing "extern" declaration.
Back-patch to all supported versions.
Masahiko Sawada [Mon, 9 Mar 2015 10:56:18 +0000 (19:56 +0900)]
Add the limitations section into document of pg_bigm 1.1.
Also add the news into top page.
Backpatch to 1.1.
Beena Emerson
Masahiko Sawada [Fri, 6 Feb 2015 05:21:28 +0000 (14:21 +0900)]
Add PGFILEDESC description to Makefiles.
Prominent binaries already had this metadata.
This commit is inspried by the change of pg_trgm:
0ffc201a51395ca71fe429ef86c872850a5850ee
Backpatch to all branches.
Beena Emerson
Masahiko Sawada [Fri, 6 Feb 2015 05:08:39 +0000 (14:08 +0900)]
Adjust blank lines around PG_MODULE_MAGIC defines, for consistency.
The architecture of pg_bigm is similar to pg_trgm.
This change is quite small but it need to be applied for
consistency of changing.
This commit is inspried by the change of pg_trgm:
6a605cd6bd9f689b35676623add0de9b90978bf1
Backpatch to all branches.
Beena Emerson
Masahiko Sawada [Fri, 6 Feb 2015 04:41:34 +0000 (13:41 +0900)]
pgindent run.
This commit is inspried by the change of pg_trgm:
0a7832005792fa6dad171f9cadb8d587fe0dd800
Backpatch to all branches.
Beena Emerson
MasaoFujii [Thu, 5 Feb 2015 10:24:14 +0000 (19:24 +0900)]
Avoid the redundant declaration of the function prototypes.
When the server version is 9.4 or later, PG_FUNCTION_INFO_V1 macro
always creates the prototype of its given function, so we avoid
declaring the prototypes of all the global functions for pg_bigm.
IOW, the function prototypes are there only when the server version
is 9.3 or before.
This commit is inspired by the change of pg_trgm:
e7128e8dbb305059c30ec085461297e619bcbff4
Back-patch to 1.1 where 9.4 is supported.
Beena Emerson
Masahiko Sawada [Thu, 5 Feb 2015 04:23:39 +0000 (13:23 +0900)]
Fix URL link in index_en.html.
Patched to REL1_1_STABLE branch.
Masahiko Sawada [Thu, 5 Feb 2015 03:24:09 +0000 (12:24 +0900)]
Add the news about the release of RPM files.
The RPM of pg_bigm-1.1-
20131122 for PostgreSQL9.4 is released.
Patched to REL1_1_STABLE branch.
Masahiko Sawada [Thu, 5 Feb 2015 03:17:04 +0000 (12:17 +0900)]
Add .gitignore file.
Add file to head and call back branches.
Masahiko Sawada [Thu, 5 Feb 2015 02:17:04 +0000 (11:17 +0900)]
Add copyright to 2013 to 2015.
Add all files in head and call back branches.
Masahiko Sawada [Wed, 4 Feb 2015 16:30:39 +0000 (01:30 +0900)]
Update copyright for 2015.
Update all files in head and all back branches.
MasaoFujii [Fri, 19 Dec 2014 09:58:21 +0000 (18:58 +0900)]
Document that pg_bigm 1.1 was confirmed to work with PostgreSQL9.4.
MasaoFujii [Thu, 22 May 2014 18:41:29 +0000 (03:41 +0900)]
Fix possible overflow in calculations of palloc request sizes.
This commit is inspired by the change of pg_trgm:
c3ccc9ee584b9b015dd9c1931e261e21f3961e5f
Back-patch to all supported versions.
MasaoFujii [Wed, 21 May 2014 03:29:15 +0000 (12:29 +0900)]
Avoid unnecessary elimination of duplicated bigrams.
When the number of bigrams is only one, obviously there is
no duplicated bigrams and its elimination is not needed.
This commit comes from the change of PostgreSQL:
c3ccc9ee584b9b015dd9c1931e261e21f3961e5f
The issue which this commit has addressed is basically
harmless, but there is no strong reason not to back-patch
this. So back-patch to all supported versions.
Beena Emerson
MasaoFujii [Tue, 20 May 2014 16:47:02 +0000 (01:47 +0900)]
Update copyright for 2014.
Update all files in head and all back branches.
Beena Emerson
MasaoFujii [Fri, 20 Dec 2013 12:06:04 +0000 (21:06 +0900)]
Add the news about the release of RPM files.
MasaoFujii [Fri, 6 Dec 2013 16:40:25 +0000 (01:40 +0900)]
Cosmetic change.
MasaoFujii [Thu, 5 Dec 2013 08:56:13 +0000 (17:56 +0900)]
Change the URL of the download page of pg_bigm.
MasaoFujii [Thu, 5 Dec 2013 08:50:38 +0000 (17:50 +0900)]
Add the news about the release of the latest versions.
MasaoFujii [Thu, 5 Dec 2013 07:07:20 +0000 (16:07 +0900)]
Change the URL of the download page of pg_bigm.
MasaoFujii [Fri, 22 Nov 2013 13:27:15 +0000 (22:27 +0900)]
Update the release date.
MasaoFujii [Fri, 22 Nov 2013 13:12:21 +0000 (22:12 +0900)]
Update the release note of the version 1.0.
MasaoFujii [Fri, 22 Nov 2013 13:05:02 +0000 (22:05 +0900)]
Fix typo in docs.
MasaoFujii [Fri, 22 Nov 2013 12:57:57 +0000 (21:57 +0900)]
Change the naming rule of the source archive file.
This makes the name of the source archive file contain
the version number of pg_bigm.
MasaoFujii [Fri, 22 Nov 2013 10:09:26 +0000 (19:09 +0900)]
Add note about pg_gin_pending_stats function.
Amit Langote
MasaoFujii [Thu, 21 Nov 2013 13:01:54 +0000 (22:01 +0900)]
Add note about bigm_similarity function.
Original patch by Beena Emerson, modified by me.
MasaoFujii [Wed, 30 Oct 2013 13:41:42 +0000 (22:41 +0900)]
Get rid of the restriction of available database locale.
Beena Emerson, Amit Langote, Fujii Masao
MasaoFujii [Mon, 28 Oct 2013 13:37:53 +0000 (22:37 +0900)]
Update the release notes of version 1.1.
Beena Emerson
MasaoFujii [Wed, 23 Oct 2013 13:35:32 +0000 (22:35 +0900)]
Get rid of the restriction of available database encoding.
Beena Emerson
MasaoFujii [Wed, 23 Oct 2013 13:26:55 +0000 (22:26 +0900)]
Add the descriptions of similarity search into the document.
MasaoFujii [Wed, 23 Oct 2013 11:34:32 +0000 (20:34 +0900)]
Fix typo in document.
MasaoFujii [Tue, 22 Oct 2013 18:13:12 +0000 (03:13 +0900)]
Add the release number into the document title.
MasaoFujii [Tue, 22 Oct 2013 18:10:11 +0000 (03:10 +0900)]
Add the description of bigm_similarity function into the document.
MasaoFujii [Tue, 22 Oct 2013 17:42:42 +0000 (02:42 +0900)]
Don't change the name of documents for version 1.0.
MasaoFujii [Tue, 22 Oct 2013 17:37:58 +0000 (02:37 +0900)]
Add links to documents of multiple versions into index.html.
MasaoFujii [Tue, 22 Oct 2013 17:08:44 +0000 (02:08 +0900)]
Update the release notes for version 1.0.
MasaoFujii [Mon, 21 Oct 2013 23:51:49 +0000 (08:51 +0900)]
Add the regression test of text similarity search.
MasaoFujii [Mon, 21 Oct 2013 18:27:35 +0000 (03:27 +0900)]
Add Mac OS X as the supported platform.
MasaoFujii [Mon, 21 Oct 2013 18:18:37 +0000 (03:18 +0900)]
Update Japanese-version of release note for 1.1.
MasaoFujii [Mon, 21 Oct 2013 14:18:12 +0000 (23:18 +0900)]
Update English-version of release note for 1.1.
Beena Emerson, with some cosmetic changes by me.
MasaoFujii [Fri, 11 Oct 2013 04:59:55 +0000 (13:59 +0900)]
Add the news about Sawada's pg_bigm talk into index.html.
MasaoFujii [Wed, 9 Oct 2013 16:48:57 +0000 (01:48 +0900)]
Fix crash in text similarity search with blank characters keyword.
MasaoFujii [Sun, 6 Oct 2013 17:27:31 +0000 (02:27 +0900)]
Separate regression test into English and Japanese parts.
MasaoFujii [Sun, 6 Oct 2013 17:25:45 +0000 (02:25 +0900)]
Fix typo in document.
MasaoFujii [Sun, 6 Oct 2013 16:56:35 +0000 (01:56 +0900)]
Remove incorrect assertion.
MasaoFujii [Fri, 4 Oct 2013 18:02:21 +0000 (03:02 +0900)]
Cosmetic change of regression test.
MasaoFujii [Fri, 4 Oct 2013 04:32:56 +0000 (13:32 +0900)]
Fix typo in document.
MasaoFujii [Fri, 4 Oct 2013 03:41:22 +0000 (12:41 +0900)]
Support text similarity search.
Amit Langote, reviewed by Beena Emerson, and further edited by me.
MasaoFujii [Thu, 3 Oct 2013 14:37:06 +0000 (23:37 +0900)]
Add bigm_similarity function.
This function returns a number that indicates how similar
the two arguments are.
Amit Langote, reviewed by Beena Emerson, and further edited by me.
MasaoFujii [Tue, 1 Oct 2013 17:29:46 +0000 (02:29 +0900)]
Add 'extern' declarations to functions in bigm.h.
MasaoFujii [Tue, 1 Oct 2013 10:46:35 +0000 (19:46 +0900)]
Improve comments on regression test.
Updates the comments on regression tests for full text search
with multi-column index so that the purpose of the tests
become clearer.
Beena Emerson
MasaoFujii [Mon, 30 Sep 2013 17:18:13 +0000 (02:18 +0900)]
Add the regression test of co-existence of pg_bigm and pg_trgm.
This patch allows us to run "make installcheck-trgm" command
which checks whether pg_bigm and pg_trgm can co-exist in the
same database.
Beena Emerson, modified by me
MasaoFujii [Sat, 28 Sep 2013 00:24:46 +0000 (09:24 +0900)]
Fix bug in enable_recheck with gin_key_limit = 1.
Beena Emerson, slightly modified by me
MasaoFujii [Tue, 24 Sep 2013 14:16:19 +0000 (23:16 +0900)]
Add the regression test of full-text search with multi-column index.
Beena Emerson, modified by me.
MasaoFujii [Tue, 24 Sep 2013 14:04:32 +0000 (23:04 +0900)]
Add the regression test of gin_key_limit parameter.
Beena Emerson
MasaoFujii [Tue, 24 Sep 2013 13:51:54 +0000 (22:51 +0900)]
Add the regression test of enable_recheck parameter.
Beena Emerson, modified by me.
MasaoFujii [Tue, 24 Sep 2013 13:43:45 +0000 (22:43 +0900)]
Add the regression test of pg_gin_pending_stats function.
Beena Emerson, modified by me.
MasaoFujii [Tue, 24 Sep 2013 13:35:48 +0000 (22:35 +0900)]
Add the regression test of pg_bigm with standard_conforming_strings disabled.
Beena Emerson
MasaoFujii [Tue, 24 Sep 2013 13:26:54 +0000 (22:26 +0900)]
Add the regression test of DROP EXTENSION pg_bigm.
Beena Emerson
MasaoFujii [Tue, 24 Sep 2013 13:23:20 +0000 (22:23 +0900)]
Add the regression test of full-text search using pg_bigm.
Beena Emerson, modified by me.
MasaoFujii [Tue, 24 Sep 2013 12:35:01 +0000 (21:35 +0900)]
Add the regression test of show_bigm function.
Beena Emerson
MasaoFujii [Tue, 24 Sep 2013 12:28:54 +0000 (21:28 +0900)]
Enable standard_conforming_strings before starting the tests.
This is required to prevent the regression test with the backslash
character from failing when standard_conforming_strings is disabled.
Beena Emerson
MasaoFujii [Tue, 24 Sep 2013 12:17:39 +0000 (21:17 +0900)]
Add the regression test of last_update parameter.
Beena Emerson
MasaoFujii [Thu, 22 Aug 2013 08:51:52 +0000 (17:51 +0900)]
Get rid of USE_WIDE_UPPER_LOWER dependency in bigram construction.
This is due to the commit in pg_trgm on Apr 7, 2013 by Tom Lane
7844608e54a3a2e3dee461b00fd6ef028a845d7c.
Beena Emerson
MasaoFujii [Thu, 22 Aug 2013 01:36:58 +0000 (10:36 +0900)]
Add the regression test of likequery function.
MasaoFujii [Fri, 9 Aug 2013 14:29:09 +0000 (23:29 +0900)]
Correct URL of pg_bigm sourceforge.jp site in English version of document.
MasaoFujii [Thu, 8 Aug 2013 13:43:48 +0000 (22:43 +0900)]
Add English version of document.
Beena Emerson, reviewed by Fujii Masao
MasaoFujii [Wed, 24 Jul 2013 16:30:55 +0000 (01:30 +0900)]
Add "inline" keyword into the declaration of "bigmstrcmp" function.
This silences compiler warning.
MasaoFujii [Tue, 23 Jul 2013 19:24:53 +0000 (04:24 +0900)]
Remove gin_trgm_ops.
We could not install pg_bigm and pg_trgm in the same database so far
because both have been declaring the same operator class gin_trgm_ops.
This patch removes gin_trgm_ops from pg_bigm and allows us to use
both full text search modules together.
On the other hand, we keep supporting gin_trgm_ops in pg_bigm 1.0
because there are already some users who use gin_trgm_ops with pg_bigm.
Beena Emerson, reviewed by Fujii Masao
MasaoFujii [Tue, 11 Jun 2013 15:00:42 +0000 (00:00 +0900)]
Confirmed that pg_bigm can work properly with PostgreSQL9.2.
MasaoFujii [Tue, 11 Jun 2013 14:58:26 +0000 (23:58 +0900)]
Fix the typos.
MasaoFujii [Tue, 11 Jun 2013 14:56:47 +0000 (23:56 +0900)]
Add the news that Sawada-san gave the talk about pg_bigm
in PostgreSQL Shikumi and Application study meetup, into index.html.
MasaoFujii [Fri, 7 Jun 2013 16:36:40 +0000 (01:36 +0900)]
Cosmetic change of the module name.
MasaoFujii [Thu, 4 Apr 2013 19:45:31 +0000 (04:45 +0900)]
Add the link to the download page of the latest released module,
into index.html.
MasaoFujii [Thu, 4 Apr 2013 18:59:11 +0000 (03:59 +0900)]
Update the last release date of pg_bigm.
MasaoFujii [Thu, 4 Apr 2013 18:55:51 +0000 (03:55 +0900)]
Add the document and the homepage of pg_bigm project.
MasaoFujii [Fri, 29 Mar 2013 13:35:13 +0000 (22:35 +0900)]
Initial commit of pg_bigm.