[COMMITTERS] pgsql: Fix double shared memory allocation.

2017-07-21 Thread Teodor Sigaev
Fix double shared memory allocation. SLRU buffer lwlocks are allocated twice by oversight in commit fe702a7b3f9f2bc5bf6d173166d7d55226af82c8 where that locks were moved to separate tranche. The bug doesn't have user-visible effects except small overspending of shared memory. Backpatch to 9.6

[COMMITTERS] pgsql: Fix double shared memory allocation.

2017-07-21 Thread Teodor Sigaev
Fix double shared memory allocation. SLRU buffer lwlocks are allocated twice by oversight in commit fe702a7b3f9f2bc5bf6d173166d7d55226af82c8 where that locks were moved to separate tranche. The bug doesn't have user-visible effects except small overspending of shared memory. Backpatch to 9.6

[COMMITTERS] pgsql: Fix potential data corruption during freeze

2017-07-06 Thread Teodor Sigaev
Fix potential data corruption during freeze Fix oversight in 3b97e6823b94 bug fix. Bitwise AND is used instead of OR and it cleans all bits in t_infomask heap tuple field. Backpatch to 9.3 Branch -- REL9_3_STABLE Details ---

[COMMITTERS] pgsql: Fix potential data corruption during freeze

2017-07-06 Thread Teodor Sigaev
Fix potential data corruption during freeze Fix oversight in 3b97e6823b94 bug fix. Bitwise AND is used instead of OR and it cleans all bits in t_infomask heap tuple field. Backpatch to 9.3 Branch -- REL9_4_STABLE Details ---

[COMMITTERS] pgsql: Fix potential data corruption during freeze

2017-07-06 Thread Teodor Sigaev
Fix potential data corruption during freeze Fix oversight in 3b97e6823b94 bug fix. Bitwise AND is used instead of OR and it cleans all bits in t_infomask heap tuple field. Backpatch to 9.3 Branch -- REL9_5_STABLE Details ---

[COMMITTERS] pgsql: Fix potential data corruption during freeze

2017-07-06 Thread Teodor Sigaev
Fix potential data corruption during freeze Fix oversight in 3b97e6823b94 bug fix. Bitwise AND is used instead of OR and it cleans all bits in t_infomask heap tuple field. Backpatch to 9.3 Branch -- REL9_6_STABLE Details ---

[COMMITTERS] pgsql: Fix potential data corruption during freeze

2017-07-06 Thread Teodor Sigaev
Fix potential data corruption during freeze Fix oversight in 3b97e6823b94 bug fix. Bitwise AND is used instead of OR and it cleans all bits in t_infomask heap tuple field. Backpatch to 9.3 Branch -- master Details ---

[COMMITTERS] pgsql: Implement SortSupport for macaddr data type

2017-03-29 Thread Teodor Sigaev
Implement SortSupport for macaddr data type Introduces a scheme to produce abbreviated keys for the macaddr type. Bump catalog version. Author: Brandur Leach Reviewed-by: Julien Rouhaud, Peter Geoghegan https://commitfest.postgresql.org/13/743/ Branch -- master Details ---

[COMMITTERS] pgsql: Altering default privileges on schemas

2017-03-28 Thread Teodor Sigaev
Altering default privileges on schemas Extend ALTER DEFAULT PRIVILEGES command to schemas. Author: Matheus Oliveira Reviewed-by: Petr JelĂ­nek, Ashutosh Sharma https://commitfest.postgresql.org/13/887/ Branch -- master Details ---

[COMMITTERS] pgsql: Fsync directory after creating or unlinking file.

2017-03-27 Thread Teodor Sigaev
Fsync directory after creating or unlinking file. If file was created/deleted just before powerloss it's possible that file system will miss that. To prevent it, call fsync() where creating/ unlinkg file is critical. Author: Michael Paquier Reviewed-by: Ashutosh Bapat, Takayuki Tsunakawa, me

[COMMITTERS] pgsql: Improve performance of find_all_inheritors()

2017-03-27 Thread Teodor Sigaev
Improve performance of find_all_inheritors() Previous coding uses three nested loops which obviously were a pain for large number of table's children. Patch replaces inner loop with a hashmap. Author: Aleksander Alekseev Reviewed-by: me https://commitfest.postgresql.org/13/1058/ Branch --

[COMMITTERS] pgsql: Improve performance of find_tabstat_entry()/get_tabstat_entry()

2017-03-27 Thread Teodor Sigaev
Improve performance of find_tabstat_entry()/get_tabstat_entry() Patch introduces a hash map reloid -> PgStat_TableStatus which improves performance in case of large number of tables/partitions. Author: Aleksander Alekseev Reviewed-by: Andres Freund, Anastasia Lubennikova, Tels, me

[COMMITTERS] pgsql: Fix pgbench options -C and -R together

2017-03-24 Thread Teodor Sigaev
Fix pgbench options -C and -R together The bug is that prior to --rate doCustom was always disconnect/reconnect without exiting, but with rate it returns if it has to wait. However threadRun test whether there is a connection before recalling doCustom, so it was never called. Bug is not existed

[COMMITTERS] pgsql: Fix backup canceling

2017-03-24 Thread Teodor Sigaev
Fix backup canceling Assert-enabled build crashes but without asserts it works by wrong way: it may not reset forcing full page write and preventing from starting exclusive backup with the same name as cancelled. Patch replaces pair of booleans nonexclusive_backup_running/exclusive_backup_running

[COMMITTERS] pgsql: Fix backup canceling

2017-03-24 Thread Teodor Sigaev
Fix backup canceling Assert-enabled build crashes but without asserts it works by wrong way: it may not reset forcing full page write and preventing from starting exclusive backup with the same name as cancelled. Patch replaces pair of booleans nonexclusive_backup_running/exclusive_backup_running

[COMMITTERS] pgsql: Reduce page locking in GIN vacuum

2017-03-23 Thread Teodor Sigaev
Reduce page locking in GIN vacuum GIN vacuum during cleaning posting tree can lock this whole tree for a long time with by holding LockBufferForCleanup() on root. Patch changes it with two ways: first, cleanup lock will be taken only if there is an empty page (which should be deleted) and,

[COMMITTERS] pgsql: Fix support for some operators (&<, &>, $<|, |&>) in box operato

2017-03-21 Thread Teodor Sigaev
Fix support for some operators (&<, &>, $<|, |&>) in box operator class of SP-GiST. Bug exists since initial commit of box opclass for SP-GiST, so backpath to 9.6 Author: Nikita Glukhov with minor editorization of tests by me Reviewed-by: Kyotaro Horiguchi, Anastasia Lubennikova

[COMMITTERS] pgsql: Fix support for some operators (&<, &>, $<|, |&>) in box operato

2017-03-21 Thread Teodor Sigaev
Fix support for some operators (&<, &>, $<|, |&>) in box operator class of SP-GiST. Bug exists since initial commit of box opclass for SP-GiST, so backpath to 9.6 Author: Nikita Glukhov with minor editorization of tests by me Reviewed-by: Kyotaro Horiguchi, Anastasia Lubennikova

[COMMITTERS] pgsql: Revert unintentional change in increasing usage count during pin

2017-03-20 Thread Teodor Sigaev
Revert unintentional change in increasing usage count during pin of buffers, this makes buffer access strategy have no effect. Change was a part of commit 48354581a49c30f5757c203415aa8412d85b0f70 during 9.6 release cycle, so backpath to 9.6 Reported-by: Jim Nasby Author: Alexander Korotkov

[COMMITTERS] pgsql: Revert unintentional change in increasing usage count during pin

2017-03-20 Thread Teodor Sigaev
Revert unintentional change in increasing usage count during pin of buffers, this makes buffer access strategy have no effect. Change was a part of commit 48354581a49c30f5757c203415aa8412d85b0f70 during 9.6 release cycle, so backpath to 9.6 Reported-by: Jim Nasby Author: Alexander Korotkov

[COMMITTERS] pgsql: Fix parsing NOT sequence in tsquery

2016-07-15 Thread Teodor Sigaev
Fix parsing NOT sequence in tsquery Digging around bug #14245 I found that commit 6734a1cacd44f5b731933cbc93182b135b167d0c missed that NOT operation is right associative in opposite to all other. This miss is resposible for tsquery parser fail on sequence of NOT operations Branch -- master

[COMMITTERS] pgsql: Fix nested NOT operation cleanup in tsquery.

2016-07-15 Thread Teodor Sigaev
Fix nested NOT operation cleanup in tsquery. During normalization of tsquery tree it tries to simplify nested NOT operations but there it's obvioulsy missed that subsequent node could be a leaf node (value node) Bug #14245: Segfault on weird to_tsquery Reported by David Kellum. Branch --

[COMMITTERS] pgsql: Document precedence of FTS operators in tsquery

2016-06-29 Thread Teodor Sigaev
Document precedence of FTS operators in tsquery Oleg Bartunov Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/73e6bea603548810769fd8ac8b19342f759ef07d Modified Files -- doc/src/sgml/textsearch.sgml | 10 +++--- 1 file changed, 7 insertions(+), 3

[COMMITTERS] pgsql: Change predecence of phrase operator.

2016-06-27 Thread Teodor Sigaev
Change predecence of phrase operator. <-> operator now have higher predecence than & (AND) operator. This change was motivated by unexpected difference of similar queries: 'a & b <-> c'::tsquery and 'b <-> c & a'. Before first query means (a & b) <-> c and second one - '(b <-> c) & a', now phrase

[COMMITTERS] pgsql: Do not fallback to AND for FTS phrase operator.

2016-06-27 Thread Teodor Sigaev
Do not fallback to AND for FTS phrase operator. If there is no positional information of lexemes then phrase operator will not fallback to AND operator. This change makes needing to modify TS_execute() interface, because somewhere (in indexes, for example) positional information is unaccesible

[COMMITTERS] pgsql: Make exact distance match for FTS phrase operator

2016-06-27 Thread Teodor Sigaev
Make exact distance match for FTS phrase operator Phrase operator now requires exact distance betweens lexems instead of less-or-equal. Per discussion c19fcfec308e6ccd952cdde9e648b...@mail.gmail.com Branch -- master Details ---

[COMMITTERS] pgsql: Fix typo in docs

2016-05-24 Thread Teodor Sigaev
Fix typo in docs Add missing USING BLOOM in example of contrib/bloom Nikolay Shaplov Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/6ee7fb8244560b7a3f224784b8ad2351107fa55d Modified Files -- doc/src/sgml/bloom.sgml | 2 +- 1 file changed, 1

Re: [COMMITTERS] pgsql: Allocate all page images at once in generic wal interface

2016-05-17 Thread Teodor Sigaev
i-bin/show_log.pl?nm=curculio=2016-05-17+19%3A30%3A09 -- Teodor Sigaev E-mail: teo...@sigaev.ru WWW: http://www.sigaev.ru/ -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes

[COMMITTERS] pgsql: Allocate all page images at once in generic wal interface

2016-05-17 Thread Teodor Sigaev
Allocate all page images at once in generic wal interface That reduces number of allocation. Per gripe from Michael Paquier and Tom Lane suggestion. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/7c979c95a3700d0bd34c2831f49a9260d505b0f9 Modified Files

[COMMITTERS] pgsql: Correctly align page's images in generic wal API

2016-05-16 Thread Teodor Sigaev
Correctly align page's images in generic wal API Page image should be MAXALIGN'ed because existing code could directly align pointers in page instead of align offset from beginning of page. Found during play with indexes as extenstion, Alexander Korotkov and me Branch -- master Details

[COMMITTERS] pgsql: Fix crash of filter(tsvector)

2016-05-04 Thread Teodor Sigaev
Fix crash of filter(tsvector) Variable storing a position of lexeme, had a wrong type: char, it's obviously not enough to store 2^14 possible positions. Stas Kelvich Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/4bbc1a7ea351f235eb9a4475ceb17d7e37a36473 Modified

Re: [COMMITTERS] pgsql: Fix support of digits in email/hostnames.

2016-04-29 Thread Teodor Sigaev
-0008ct...@wrigleys.postgresql.org -- Teodor Sigaev E-mail: teo...@sigaev.ru WWW: http://www.sigaev.ru/ -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your

[COMMITTERS] pgsql: Prevent to use magic constants

2016-04-28 Thread Teodor Sigaev
Prevent to use magic constants Use macroses for definition amstrategies/amsupport fields instead of hardcoded values. Author: Nikolay Shaplov with addition for contrib/bloom Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/f8467f7da8685dbc47187864e5afe130d9c63fff

[COMMITTERS] pgsql: Prevent multiple cleanup process for pending list in GIN.

2016-04-28 Thread Teodor Sigaev
Prevent multiple cleanup process for pending list in GIN. Previously, ginInsertCleanup could exit early if it detects that someone else is cleaning up the pending list, without waiting for that someone else to finish the job. But in this case vacuum could miss tuples to be deleted. Cleanup

[COMMITTERS] pgsql: Fix tsearch docs

2016-04-26 Thread Teodor Sigaev
Fix tsearch docs Remove mention of setweight(tsquery) which wasn't included in 9.6. Also replace old forgotten phrase operator to new one. Dmitry Ivanov Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/f1e3c76066f0066a8a9bb09b80cd97f11e4b2dc4 Modified Files

[COMMITTERS] pgsql: Add page id to bloom index

2016-04-12 Thread Teodor Sigaev
Add page id to bloom index Added to ensure that bloom index pages can be distinguished from other pages by pg_filedump. Because there wasn't any public/production versions before, it doesn't pay attention to any compatibility issues. Per notice from Tom Lane Branch -- master Details

[COMMITTERS] pgsql: Revert CREATE INDEX ... INCLUDING ...

2016-04-08 Thread Teodor Sigaev
Revert CREATE INDEX ... INCLUDING ... It's not ready yet, revert two commits 690c543550b0d2852060c18d270cdb534d339d9a - unstable test output 386e3d7609c49505e079c40c65919d99feb82505 - patch itself Branch -- master Details ---

Re: [COMMITTERS] pgsql: CREATE INDEX ... INCLUDING (column[, ...])

2016-04-08 Thread Teodor Sigaev
Given those concerns, this *clearly* was not ready to commit. Please revert, Teodor. Will do, sorry. I was a bit confused with quiet discussion -- Teodor Sigaev E-mail: teo...@sigaev.ru WWW: http

[COMMITTERS] pgsql: Fix possible use of uninitialised value in ts_headline()

2016-04-08 Thread Teodor Sigaev
Fix possible use of uninitialised value in ts_headline() Found during investigation of failure of skink buildfarm member and its valgrind report. Backpatch to all supported branches Branch -- REL9_5_STABLE Details ---

[COMMITTERS] pgsql: Fix possible use of uninitialised value in ts_headline()

2016-04-08 Thread Teodor Sigaev
Fix possible use of uninitialised value in ts_headline() Found during investigation of failure of skink buildfarm member and its valgrind report. Backpatch to all supported branches Branch -- REL9_1_STABLE Details ---

[COMMITTERS] pgsql: Fix possible use of uninitialised value in ts_headline()

2016-04-08 Thread Teodor Sigaev
Fix possible use of uninitialised value in ts_headline() Found during investigation of failure of skink buildfarm member and its valgrind report. Backpatch to all supported branches Branch -- REL9_3_STABLE Details ---

[COMMITTERS] pgsql: Fix possible use of uninitialised value in ts_headline()

2016-04-08 Thread Teodor Sigaev
Fix possible use of uninitialised value in ts_headline() Found during investigation of failure of skink buildfarm member and its valgrind report. Backpatch to all supported branches Branch -- REL9_2_STABLE Details ---

[COMMITTERS] pgsql: Fix possible use of uninitialised value in ts_headline()

2016-04-08 Thread Teodor Sigaev
Fix possible use of uninitialised value in ts_headline() Found during investigation of failure of skink buildfarm member and its valgrind report. Backpatch to all supported branches Branch -- REL9_4_STABLE Details ---

[COMMITTERS] pgsql: Fix possible use of uninitialised value in ts_headline()

2016-04-08 Thread Teodor Sigaev
Fix possible use of uninitialised value in ts_headline() Found during investigation of failure of skink buildfarm member and its valgrind report. Backpatch to all supported branches Branch -- master Details ---

[COMMITTERS] pgsql: Fix output of regression test of contrib/tsearch2

2016-04-08 Thread Teodor Sigaev
Fix output of regression test of contrib/tsearch2 Just forget to add in 1ec4c7c055ca045c5df6352a4cdacd9aa778e598 Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/38627f687823eae57e932c3b234656342403e909 Modified Files --

[COMMITTERS] pgsql: Restore original tsquery operation numbering.

2016-04-08 Thread Teodor Sigaev
Restore original tsquery operation numbering. As noticed by Tom Lane changing operation's number in commit bb140506df605fab58f48926ee1db1f80bdafb59 causes on-disk format incompatibility. Revert to previous numbering, that is reason to add special array to store priorities of operation. Also it

[COMMITTERS] pgsql: CREATE INDEX ... INCLUDING (column[, ...])

2016-04-08 Thread Teodor Sigaev
CREATE INDEX ... INCLUDING (column[, ...]) Now indexes (but only B-tree for now) can contain "extra" column(s) which doesn't participate in index structure, they are just stored in leaf tuples. It allows to use index only scan by using single index instead of two or more indexes. Author:

[COMMITTERS] pgsql: Enhanced custom error in PLPythonu

2016-04-08 Thread Teodor Sigaev
Enhanced custom error in PLPythonu Patch adds a new, more rich, way to emit error message or exception from PL/Pythonu code. Author: Pavel Stehule Reviewers: Catalin Iacob, Peter Eisentraut, Jim Nasby Branch -- master Details ---

Re: [COMMITTERS] pgsql: Phrase full text search.

2016-04-08 Thread Teodor Sigaev
tsquery expansion anyway. I'd suggest a static const array mapping the OP values into their syntactic priorities. Oh, I see. Will fix. -- Teodor Sigaev E-mail: teo...@sigaev.ru WWW: http://www.sigaev.ru

[COMMITTERS] pgsql: Rename comparePos() to compareWordEntryPos()

2016-04-08 Thread Teodor Sigaev
Rename comparePos() to compareWordEntryPos() Rename comparePos() to compareWordEntryPos() to prevent export of too generic name. Per gripe from Tom Lane. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/4e55b3f0335c2aa658cd9d1fda4dea2a1f9ab80d Modified Files

Re: [COMMITTERS] pgsql: Phrase full text search.

2016-04-08 Thread Teodor Sigaev
to the end without growning size of QueryItem. -- Teodor Sigaev E-mail: teo...@sigaev.ru WWW: http://www.sigaev.ru/ -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes

[COMMITTERS] pgsql: Zeroing unused parts ducring tsquery construction.

2016-04-07 Thread Teodor Sigaev
Zeroing unused parts ducring tsquery construction. Per investigation failure skink buildfarm member and RANDOMIZE_ALLOCATED_MEMORY help Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/3308467905aa157139d24375850cfe49ee90a0cf Modified Files --

[COMMITTERS] pgsql: Make testing of phraseto_tsquery independ from value of

2016-04-07 Thread Teodor Sigaev
Make testing of phraseto_tsquery independ from value of default_text_search_config variable. Per skink buldfarm member Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/a7ace3b6d96c7a1539ed0700865d320258a12f73 Modified Files --

[COMMITTERS] pgsql: Phrase full text search.

2016-04-07 Thread Teodor Sigaev
number of parenthesis in tsquery output, and tsquery becomes more readable Authors: Teodor Sigaev, Oleg Bartunov, Dmitry Ivanov Reviewers: Alexander Korotkov, Artur Zakirov Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/bb140506df605fab58f48926ee1db1f80bdafb59 Modified

[COMMITTERS] pgsql: Add jsonb_insert

2016-04-06 Thread Teodor Sigaev
Add jsonb_insert It inserts a new value into an jsonb array at arbitrary position or a new key to jsonb object. Author: Dmitry Dolgov Reviewers: Petr Jelinek, Vitaly Burovoy, Andrew Dunstan Branch -- master Details ---

[COMMITTERS] pgsql: Fix typo

2016-04-04 Thread Teodor Sigaev
Fix typo Michael Paquier Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/eb7308d29875df773b5b52b06ed3d8b60f1b8242 Modified Files -- contrib/bloom/blutils.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) -- Sent via pgsql-committers mailing list

[COMMITTERS] pgsql: fix typo

2016-04-04 Thread Teodor Sigaev
fix typo Andreas Ulbrich Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/9b27aebe7124210c1b0dbacac657edfefa16a006 Modified Files -- doc/src/sgml/generic-wal.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) -- Sent via pgsql-committers

[COMMITTERS] pgsql: Fix condition in e9e441c9fac6cbc0510cded6abb9d0e6b646ecaf

2016-04-02 Thread Teodor Sigaev
Fix condition in e9e441c9fac6cbc0510cded6abb9d0e6b646ecaf Comment is right, but if - not. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/9c50372d20aabdb23963f8d28651728d546acefb Modified Files -- contrib/bloom/blvacuum.c | 2 +- 1 file changed, 1

[COMMITTERS] pgsql: Prevent mark as deleted and as 'has free space' page in bloom mo

2016-04-02 Thread Teodor Sigaev
Prevent mark as deleted and as 'has free space' page in bloom module Vacuum might put page into list of pages with some free space and mark as deleted at the same time. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/e9e441c9fac6cbc0510cded6abb9d0e6b646ecaf

[COMMITTERS] pgsql: Fixes in bloom contrib module

2016-04-02 Thread Teodor Sigaev
Fixes in bloom contrib module Looking at result of buildfarm member jaguarundi it seems to me that BloomOptions isn't inited sometime, but I don't see yet how it's possible. Nevertheless, check of signature length's is missed, so, add a limit of it. Also add missed GenericXLogAbort() in case of

[COMMITTERS] pgsql: Fixes in bloom contrib module missed during review

2016-04-01 Thread Teodor Sigaev
Fixes in bloom contrib module missed during review - macroses llike (var & FLAG) are changed to ((var & FLAG) != 0) - do not copy uninitialized part of notFullPage array to page Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/27f3bbfad46e694fcbf2fa39cb621110d46ec95c

[COMMITTERS] pgsql: Fix English in bloom module documentation

2016-04-01 Thread Teodor Sigaev
Fix English in bloom module documentation Author: Erik Rijkers Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/a361c22ebfa8c87683f07f83f55a8456e7892e6d Modified Files -- doc/src/sgml/bloom.sgml | 72 ++--- 1

Re: [COMMITTERS] pgsql: Bloom index contrib module

2016-04-01 Thread Teodor Sigaev
Several non-x86 members of pgbuildfarm aren't happy with it, we are investigating the problem Teodor Sigaev wrote: Bloom index contrib module Module provides new access method. It is actually a simple Bloom filter implemented as pgsql's index. It could give some benefits on search with large

[COMMITTERS] pgsql: Bloom index contrib module

2016-04-01 Thread Teodor Sigaev
Bloom index contrib module Module provides new access method. It is actually a simple Bloom filter implemented as pgsql's index. It could give some benefits on search with large number of columns. Module is a single way to test generic WAL interface committed earlier. Author: Teodor Sigaev

[COMMITTERS] pgsql: Fix typo in generic wal docs

2016-04-01 Thread Teodor Sigaev
Fix typo in generic wal docs Markus Nullmeier Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/4e56e5a6de766a6983ce723b1945d68a4e098a06 Modified Files -- doc/src/sgml/generic-wal.sgml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) -- Sent

[COMMITTERS] pgsql: Add Generic WAL interface

2016-04-01 Thread Teodor Sigaev
generic way to describe changes on page with standart layout. Bump XLOG_PAGE_MAGIC because of new record type. Author: Alexander Korotkov with a help of Petr Jelinek, Markus Nullmeier and minor editorization by my Reviewers: Petr Jelinek, Alvaro Herrera, Teodor Sigaev, Jim Nasby

[COMMITTERS] pgsql: Bump catalog version, forget in acdf2a8b372aec1da09370fca77ff7dc

2016-03-30 Thread Teodor Sigaev
Bump catalog version, forget in acdf2a8b372aec1da09370fca77ff7dccac7646d Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/2d02a856e8331329121ac2fa2c0b5dab0d106ca0 Modified Files -- src/include/catalog/catversion.h | 2 +- 1 file changed, 1 insertion(+), 1

[COMMITTERS] pgsql: Introduce SP-GiST operator class over box.

2016-03-30 Thread Teodor Sigaev
Introduce SP-GiST operator class over box. Patch implements quad-tree over boxes, naive approach of 2D quad tree will not work for any non-point objects because splitting space on node is not efficient. The idea of pathc is treating 2D boxes as 4D points, so, object will not overlap (in 4D

[COMMITTERS] pgsql: Use traversalValue in SP-GiST range opclass.

2016-03-30 Thread Teodor Sigaev
Use traversalValue in SP-GiST range opclass. Author: Alexander Lebedev Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/87545f541278ffde4fa1ccf396affbc4e9d59a23 Modified Files -- src/backend/utils/adt/rangetypes_spgist.c | 34

[COMMITTERS] pgsql: Introduce traversalValue for SP-GiST scan

2016-03-30 Thread Teodor Sigaev
piece of memory in separate MemoryContext while reconstructedVale should have the same type as indexed column. Subsequent patches for range opclass and quad4d tree will use it. Author: Alexander Lebedev, Teodor Sigaev Branch -- master Details --- http://git.postgresql.org/pg/commitdiff

[COMMITTERS] pgsql: Fix support of digits in email/hostnames.

2016-03-29 Thread Teodor Sigaev
Fix support of digits in email/hostnames. When tsearch was implemented I did several mistakes in hostname/email definition rules: 1) allow underscore in hostname what prohibited by RFC 2) forget to allow leading digits separated by hyphen (like 123-x.com) in hostname 3) do no allow

[COMMITTERS] pgsql: psql tab-complete for CREATE/DROP ACCESS METHOD

2016-03-28 Thread Teodor Sigaev
psql tab-complete for CREATE/DROP ACCESS METHOD Alexander Korotkov Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/559e7a0a6d4450c09825055e3d255d30ee869c67 Modified Files -- src/bin/psql/tab-complete.c | 13 + 1 file changed, 13 insertions(+)

[COMMITTERS] pgsql: Fix comment in pg_dump.

2016-03-28 Thread Teodor Sigaev
Fix comment in pg_dump. It was missed in 473b93287040b20017cc25a157cffdc5b978c254, CREATE ACCESS METHOD Alexander Korotkov Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/dabd255d584785c61b1187f10b7bdbf99022ae2d Modified Files --

[COMMITTERS] pgsql: Improve docs of pg_trgm changes

2016-03-22 Thread Teodor Sigaev
Improve docs of pg_trgm changes Artur Zakirov, per gripe from Jeff Janes Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/f6bd0da63bf40bc324eec6fd47f3d3d301f44dab Modified Files -- doc/src/sgml/pgtrgm.sgml | 58

[COMMITTERS] pgsql: Improve script generating unaccent rules

2016-03-19 Thread Teodor Sigaev
Improve script generating unaccent rules Script now use the standard Unicode transliterator Latin-ASCII. Author: Leonard Benedetti Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/9a206d063c410df7cd5da01b169b23bff413fef5 Modified Files --

[COMMITTERS] pgsql: Introduce parse_ident()

2016-03-19 Thread Teodor Sigaev
Introduce parse_ident() SQL-layer function to split qualified identifier into array parts. Author: Pavel Stehule with minor editorization by me and Jim Nasby Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/3187d6de0e5a9e805b27c48437897e8c39071d45 Modified Files

Re: [COMMITTERS] pgsql: Introduce parse_ident()

2016-03-19 Thread Teodor Sigaev
Fixed a typo and added 'the' a few times. Thank you, committed -- Teodor Sigaev E-mail: teo...@sigaev.ru WWW: http://www.sigaev.ru/ -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org

[COMMITTERS] pgsql: Add word_similarity to pg_trgm contrib module.

2016-03-19 Thread Teodor Sigaev
Add word_similarity to pg_trgm contrib module. Patch introduces a concept of similarity over string and just a word from another string. Version of extension is not changed because 1.2 was already introduced in 9.6 release cycle, so, there wasn't a public version. Author: Alexander Korotkov,

[COMMITTERS] pgsql: GUC variable pg_trgm.similarity_threshold insead of set_limit()

2016-03-19 Thread Teodor Sigaev
GUC variable pg_trgm.similarity_threshold insead of set_limit() Use GUC variable pg_trgm.similarity_threshold insead of set_limit()/show_limit() which was introduced when defining GUC varuables by modules was absent. Author: Artur Zakirov Branch -- master Details ---

[COMMITTERS] pgsql: Add files forgotten in f576b17cd6ba653bdace1f0da9a3b57f4984e460

2016-03-19 Thread Teodor Sigaev
Add files forgotten in f576b17cd6ba653bdace1f0da9a3b57f4984e460 Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/e4b523e5b52a84010a34fc0796904ce39116e56c Modified Files -- contrib/pg_trgm/data/trgm2.data | 696 +++

[COMMITTERS] pgsql: pg_trgm's set_limit() now uses SetConfigOption()

2016-03-19 Thread Teodor Sigaev
pg_trgm's set_limit() now uses SetConfigOption() Deprecated set_limit() is modified to use SetConfigOption() to set similarity_threshold which is actually an instance of pg_trgm.similarity_threshold GUC variable. Previous coding directly sets similarity_threshold what could cause an inconsistency

Re: [COMMITTERS] pgsql: GUC variable pg_trgm.similarity_threshold insead of set_limit()

2016-03-19 Thread Teodor Sigaev
It should go through SetConfigOption(); compare for example tsa_set_curcfg_byname(). Which would also mean you could drop the Seems, also show_limit() should use GetConfigOption()? -- Teodor Sigaev E-mail: teo...@sigaev.ru

Re: [COMMITTERS] pgsql: GUC variable pg_trgm.similarity_threshold insead of set_limit()

2016-03-19 Thread Teodor Sigaev
would enforce it. will fix -- Teodor Sigaev E-mail: teo...@sigaev.ru WWW: http://www.sigaev.ru/ -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription

Re: [COMMITTERS] pgsql: Add word_similarity to pg_trgm contrib module.

2016-03-19 Thread Teodor Sigaev
. http://www.postgresql.org/message-id/25977.1452717...@sss.pgh.pa.us You had an opposite opinion three months ago. And I still agree with that. -- Teodor Sigaev E-mail: teo...@sigaev.ru WWW: http://www.sigaev.ru

[COMMITTERS] pgsql: Improve support of Hunspell

2016-03-19 Thread Teodor Sigaev
Improve support of Hunspell - allow to use non-ascii characters as affix flag. Non-numeric affix flags now are stored as string instead of numeric value of character. - allow to use 0 as affix flag in numeric encoded affixes That adds support for arabian, hungarian, turkish and brazilian

[COMMITTERS] pgsql: fix typo in comment

2016-03-18 Thread Teodor Sigaev
fix typo in comment Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/ce91b9209f221f9555d340b40e02aaf8cdc777e4 Modified Files -- contrib/unaccent/generate_unaccent_rules.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) -- Sent via

[COMMITTERS] pgsql: Fix a typo

2016-03-18 Thread Teodor Sigaev
Fix a typo Erik Rijkers Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/61d2ebdbf9155d80f83281d8c5729c8f8f0949bc Modified Files -- doc/src/sgml/func.sgml | 10 +- 1 file changed, 5 insertions(+), 5 deletions(-) -- Sent via pgsql-committers

[COMMITTERS] pgsql: Fix Windows build broken in 6943a946c7e5eb72d53c0ce71f08a81a1335

2016-03-11 Thread Teodor Sigaev
Fix Windows build broken in 6943a946c7e5eb72d53c0ce71f08a81a133503bd Also it fixes dynamic array allocation disallowed by ANSI-C. Author: Stas Kelvich Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/b1fdc727c37b23da947b4b0d440f723f31beb84d Modified Files

[COMMITTERS] pgsql: Fix merge affixes for numeric ones

2016-03-11 Thread Teodor Sigaev
Fix merge affixes for numeric ones Some dictionaries have duplicated base words with different affix set, we just merge that sets into one set. But previously merging of sets of affixes was actually a concatenation of strings but it's wrong for numeric representation of affixes because such

[COMMITTERS] pgsql: Bump catalog version missed in 6943a946c7e5eb72d53c0ce71f08a81a1

2016-03-11 Thread Teodor Sigaev
Bump catalog version missed in 6943a946c7e5eb72d53c0ce71f08a81a133503bd Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/a9eb6c83efd258bb7a658fefa0074e0e65efd673 Modified Files -- src/include/catalog/catversion.h | 2 +- 1 file changed, 1 insertion(+), 1

[COMMITTERS] pgsql: Tsvector editing functions

2016-03-11 Thread Teodor Sigaev
Tsvector editing functions Adds several tsvector editting function: convert tsvector to/from text array, set weight for given lexemes, delete lexeme(s), unnest, filter lexemes with given weights Author: Stas Kelvich with some editorization by me Reviewers: Tomas Vondram, Teodor Sigaev Branch

Re: [COMMITTERS] pgsql: Improve support of Hunspell in ispell dictionary.

2016-03-04 Thread Teodor Sigaev
Thank you, pushed Artur Zakirov wrote: Thank you for commit. This commit did not pass regression tests in Windows Server in pgbuildfarm. Attached patch fix it. On 04.03.2016 20:08, Teodor Sigaev wrote: Improve support of Hunspell in ispell dictionary. Now it's possible to load recent

[COMMITTERS] pgsql: Fix Windows build broken by d78a7d9c7fa3e9cd494b906f065fe7b7fe9f

2016-03-04 Thread Teodor Sigaev
Fix Windows build broken by d78a7d9c7fa3e9cd494b906f065fe7b7fe9fb9a5 Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/0e7557dc8d5b2008b0b096cd730d16c8562690fc Modified Files -- src/tools/msvc/Install.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

[COMMITTERS] pgsql: Improve support of Hunspell in ispell dictionary.

2016-03-04 Thread Teodor Sigaev
Improve support of Hunspell in ispell dictionary. Now it's possible to load recent version of Hunspell for several languages. To handle these dictionaries Hunspell patch adds support for: * FLAG long - sets the double extended ASCII character flag type * FLAG num - sets the decimal number flag

[COMMITTERS] pgsql: Improve error reporting in format()

2016-02-11 Thread Teodor Sigaev
Improve error reporting in format() Clarify invalid format conversion type error message and add hint. Author: Jim Nasby Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/07d25a964b2fb78169a4a34c6f6893736f69903a Modified Files --

[COMMITTERS] pgsql: Fix lossy KNN GiST when ordering operator returns non-float8 val

2016-02-02 Thread Teodor Sigaev
Fix lossy KNN GiST when ordering operator returns non-float8 value. KNN GiST with recheck flag should return to executor the same type as ordering operator, GiST detects this type by looking to return type of function which implements ordering operator. But occasionally detecting code works after

[COMMITTERS] pgsql: Fix lossy KNN GiST when ordering operator returns non-float8 val

2016-02-02 Thread Teodor Sigaev
Fix lossy KNN GiST when ordering operator returns non-float8 value. KNN GiST with recheck flag should return to executor the same type as ordering operator, GiST detects this type by looking to return type of function which implements ordering operator. But occasionally detecting code works after

[COMMITTERS] pgsql: Improve the gin index scan performance in pg_trgm.

2015-12-25 Thread Teodor Sigaev
Improve the gin index scan performance in pg_trgm. Previous coding assumes too pessimistic upper bound of similarity in consistent method of GIN. Author: Fornaroli Christophe with comments by me. Branch -- master Details ---

[COMMITTERS] pgsql: Cube extension kNN support

2015-12-18 Thread Teodor Sigaev
Cube extension kNN support Introduce distance operators over cubes: <#> taxicab distance <-> euclidean distance <=> chebyshev distance Also add kNN support of those distances in GiST opclass. Author: Stas Kelvich Branch -- master Details ---

[COMMITTERS] pgsql: Allow to omit boundaries in array subscript

2015-12-18 Thread Teodor Sigaev
Allow to omit boundaries in array subscript Allow to omiy lower or upper or both boundaries in array subscript for selecting slice of array. Author: YUriy Zhuravlev Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/9246af6799819847faa33baf441251003acbb8fe Modified

  1   2   3   4   5   6   >