Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitf737ba6

Browse files
author
Nikita Malakhov
committed
Contrib module implements toaster for non-compressed bytea columns, which allows fast appending to existing bytea value. Appended tail stored directly in toaster pointer, if there is enough place to do it.
Note: patch modifies byteacat() to support contrib toaster.Added varlena changes for bytea_appendable_toaster and added bytea toaster to makefile0005_bytea_appendable_toaster patch
1 parentf9968b2 commitf737ba6

File tree

9 files changed

+802
-2
lines changed

9 files changed

+802
-2
lines changed

‎contrib/Makefile‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -14,6 +14,7 @@ SUBDIRS = \
1414
bloom\
1515
btree_gin\
1616
btree_gist\
17+
bytea_toaster\
1718
citext\
1819
cube\
1920
dblink\

‎contrib/bytea_toaster/Makefile‎

Lines changed: 23 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,23 @@
1+
# contrib/bytea_toaster/Makefile
2+
3+
MODULE_big = bytea_toaster
4+
OBJS =\
5+
$(WIN32RES)\
6+
bytea_toaster.o
7+
8+
EXTENSION = bytea_toaster
9+
DATA = bytea_toaster--1.0.sql
10+
PGFILEDESC = "bytea_toaster - appendable bytea toaster"
11+
12+
REGRESS = bytea_toaster
13+
14+
ifdefUSE_PGXS
15+
PG_CONFIG = pg_config
16+
PGXS :=$(shell$(PG_CONFIG) --pgxs)
17+
include$(PGXS)
18+
else
19+
subdir = contrib/bytea_toaster
20+
top_builddir = ../..
21+
include$(top_builddir)/src/Makefile.global
22+
include$(top_srcdir)/contrib/contrib-global.mk
23+
endif
Lines changed: 13 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,13 @@
1+
/* contrib/bytea_toaster/bytea_toaster--1.0.sql*/
2+
3+
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
4+
\echo Use"CREATE EXTENSION bytea_toaster" to load this file. \quit
5+
6+
CREATEFUNCTIONbytea_toaster_handler(internal)
7+
RETURNS toaster_handler
8+
AS'MODULE_PATHNAME'
9+
LANGUAGE C;
10+
11+
CREATE TOASTER bytea_toaster HANDLER bytea_toaster_handler;
12+
13+
COMMENTON TOASTER bytea_toaster IS'bytea_toaster is a appendable bytea toaster';

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp