test_data -f
index_problem.dump
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast)---
TIP 3: Have you checked our
: could not access file /usr/local/pgsql/lib/pg_sphere: No such file or
directory
If not - 8.1 use 8.0 .so
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http
I fixed path in pg_sphere (and done some more clean up).
BTW, I usially install contrib modules before restoring database (of course, it
need to dump db without content of modules)...
--
Teodor Sigaev E-mail: [EMAIL PROTECTED
, intarray was first our module for PgSQL. I'll remove usage of
ArrayType-flags soon.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast
Look at HEAD branch.
Kaare Rasmussen wrote:
David Fetter writes in PostgreSQL Weekly News - November 13 2005:
Teodor Sigaev has been making lots of improvements to tsearch2, a
full-text search engine.
I can't find them. Am I blind? Can someone help?
---(end
split it place one
key on one page and all other keys on another page. So you have a huge number of
page with single value.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru
\\'' WHERE \id\='66.20815';\n)
at postgres.c:1014
#12 0x081aa230 in PostgresMain (argc=1, argv=0x8307248, username=0x83094a8
postgres) at postgres.c:3168
#13 0x08148fb4 in main (argc=6, argv=0x8307248) at main.c:322
--
Teodor Sigaev E-mail: [EMAIL PROTECTED
initdb -E KOI8-R --locale ru_RU.KOI8-R -D $DIR
In HEAD I get
HEAD and REL8_1STABLE works fine, 8.1 release not (I don't test REL8_1_0, just
take a source package)
--
Teodor Sigaev E-mail: [EMAIL PROTECTED
a error for
btree_time on some architectures for this reason, but the same changes for
timestamp doesn't produce ones.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru
change it in 8.0 or before.
So, will we do it? I can do, but I don't know: Is there a place which contains
storage version (except file PG_VERSION)?
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http
with default_with_oids = false? (When the schema
is initialised.)
All pg_ts_* tables are created with 'with oids' option.
Chris
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
--
Teodor Sigaev E-mail: [EMAIL
. I'll check it.
It probably is then - although I do use a persistent connection pool,
but I wouldn't have thought that'd use more than a new connection every
once in a while?
Chris
--
Teodor Sigaev E-mail: [EMAIL PROTECTED
7.4 production server?
Chris
Teodor Sigaev wrote:
I found several unpleasant blot in comparing functions and commit
changes to 7.4, 8.0 and head. Pls check (it need just to recompile .so
file)
Christopher Kings-Lynne wrote:
It's cached. This select should run only one time per connection
)
return 0;
return ( ((DictInfo *) a)-dict_id ((DictInfo *) b)-dict_id ) ? -1 :
1;
}
It works for small dict_id ( dict_id has type Oid ), but it was errnous for
dict_id2^31.
Christopher Kings-Lynne wrote:
Hi Teodor,
What exactly did you fix here?
Chris
Teodor Sigaev wrote:
I found
unlike, for
example, btree which supported only five: , =, =, =, .
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast
modules needs 32. Will be
correct to use only half-value? I am afraid number of collisions will be more...
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end
is it possible to reproduce
desired behaviour?
I tried to kill(getpid(), SIGKILL) in a middle of insertion (inside gist.c), but
postgres doesn't try ro restore aborted transaction
Thank you.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED
performance
degradation after crash recovery. In other hand, it's possible to add recreation
such tuples to vacuum code (in gistbulkdelete).
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru
offset on inner pages (on leaf pages, ItemPointerData points to
heap tuple), it always equal FirstOffsetNumber. So I can use offset to indicate
correctness of tuple's key...
--
Teodor Sigaev E-mail: [EMAIL PROTECTED
kl;amsdf
(1 row)
Length of '' string is different. This difference is a reason for
installcheck failture of tsearch2 on UTF8 inited db.
Is it supposed behaviour of psql?
--
Teodor Sigaev E-mail: [EMAIL PROTECTED
the bottom half might be messed up too. So we are failing to exploit
the full intended sign space, which presumably is costing something
in index efficiency.
You are absolutly right. My fault.
It looks to me like the values calculated by this routine end up on
disk, and therefore we
Oh, good, that makes it easy. Do you want to apply the fix or shall I?
I will have normal access to Internet only on Monday. It can easy wait
for me :)
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your
! \x09document.write(15);
/script
/body
/html
\x09 is a '\t'. Is it now prohibited(non-printable) symbol?
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end
, File: mcxt.c, Line: 612)
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast)---
TIP 3: Have you checked our extensive
the index with REINDEX.
TODO
Nearest future:
* add tsearch2 opclass
* create full scale test suite
Distant future:
* Replace entry btree to something like to GiST
* Add multicolumn support
* Optimize insert operation (use background index insertion)
Authors:
Teodor Sigaev
of the catalog).
Distant future:
* Replace entry btree to something like the GiST
* Add multicolumn support
* Optimize insert operation (background index insertion)
Authors: All work was done by Teodor Sigaev ([EMAIL PROTECTED]) and Oleg
Bartunov (oleg@sai.msu.su).
--
Teodor Sigaev
==
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http
to date...
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
during build/insert,
and during bulkdelete we count number of deleted and leaved itempointers. So,
N[before bulkdelete] == N[after bulkdelete] + N[deleted]
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http
The ideal thing would be for GIN to return a count of the number of
distinct heap tuples referenced by the entries in the index, but I
suppose that would be impractical for VACUUM to compute.
Of course, in this case we should collect heap pointers in memory..
--
Teodor Sigaev
be, it will be cleaner to add indclustered
column to pg_am.
3) Return to WAL problem with GiST
4) work on gincostesimate and, possibly, GIN's opclasses costestimate tweak...
Including num_tuples issue
--
Teodor Sigaev E-mail: [EMAIL PROTECTED
structure
* R-tree - contains operation
In any case, clustering can prevent from chaotic seeks on disk.
So, two columns about clustering?
amclustered
amclusterable
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http
into
consideration for query planning.
We can use only amclustered, but in this case we can't forbid to cluster table
on any index. Just current situation.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW
Takes clustering into account means nothing. We don't need that. Any
such consideration would be handled by the AM-specific amcostestimate
function.
Ok, I see. Sorry for misunderstanding. I thought that planner use that.
--
Teodor Sigaev E-mail: [EMAIL
yours.
Fernando Esparza
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http
(). May be, it will be better choice to use mergesort.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast)---
TIP 9
.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
servidor foi perdida. Tentando reiniciar: Falhou.
! \q
Regards,
Rodrigo Hjort
http://icewall.org/~hjort
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end
Teodor Sigaev wrote:
Sorry, it isn't mentioned on page, but this example of code working only
with before 8.1 versions. In 8.1 interface to dictionary was changed.
Try attached dict_tmpl.c
2Oleg: place file on site, pls
--
Teodor Sigaev E-mail: [EMAIL
in context that does not accept a set result
I know that is not right way to call setof functions, but how in this case?
Or give more simple way, pls...
Thank you.
Note, I'm working on tsearch V2, which isn't in CVS yet, only on our GiST page:
http://www.sai.msu.su/~megera/postgres/gist/
--
Teodor
Types) from C-Language
Functions) there are only two ways to get TupleDesc: for a named relation and
based on type OID. That ways are useless in my case.
Is it possibly?
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
---(end of broadcast
. But is there way not to point 'as c(qq int4, qq1 int4)'? Notice:
qqn isn't real, it's test only.
Thank you.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet
);
}
As I understand, this code makes full description of returning value, including
types and column's names.
Is this info used anywhere?
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
---(end of broadcast
()). With
this arguments it should return TupleDesc.
As I see, the place to such call is addRangeTableEntryForFunction at
src/parser/parse_relation.c near lines N921-964. In this place we have all that
we need.
Am I wrong?
--
Teodor Sigaev E-mail: [EMAIL
off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: the planner will ignore your
to a Postgres
upgrade for a change where I didn't have to edit the dump :(
Chris
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
---(end of broadcast
settings
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
of query is boolean expression. Look at 'The tsearch2 Guide'
(http://rhodesmill.org/brandon/projects/tsearch2-guide.html).
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
basic reason: not all compilers support the -o
option.
I added sub-Makefiles. Christopher, try now, pls.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once
Since we are on the topic, is there a timeline/plans for openfts being
brought into core? If not, I'll continue my work on bringing it into
Gentoo Portage.
OpenFTS never, but tsearch2 is possible. But it requires enough work to do, so I
have doubt that it will be done in 8.2...
--
Teodor
and
right keys.
Also, I plan to split GIST_SPLITVEC to 2 structures: one of its will be argument
for pickSplit() and another will use internally in GiST core. Now GIST_SPLITVEC
contains a lot of field that's needed only for core.
Thoughts, suggestions, objections?
--
Teodor Sigaev
with compression. I am
afraid that is too big size...
What are opinions?
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast
800kb, each ispell dictionaries will takes about 0.5-2M. All sizes are
Sorry, withOUT compression...
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end
configuration.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast)---
TIP 6: explain analyze is your friend
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http
I'll place contrib module which will make all Snowball stemmers. Right
now I'm working on supporting OpenOffice's dictionaries in tsearch2, so
it will be simple to add it to packaging system.
done, http://archives.postgresql.org/pgsql-committers/2006-06/msg00112.php
--
Teodor Sigaev
is suspiciously small.
Can you test on smaller table, for example with 10 records and if results
are repeat, pls, send to me test suite...
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru
.
That's why 7 minutes is very suspicious result.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast)---
TIP 4: Have you
:)
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
entry if entry is popular enough. So fillfactor may be used
as usual.
Small advertising :) : http://www.sigaev.ru/gin/GinStructure.pdf
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru
' the postmaster
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
tsearch2 is functionality that definitely should be in core eventually,
but even Oleg still says it's not done. Aside from the documentation
issue, it's not clear that we've got a stable API for it.
Issues/TODO to move tsearch2 into core (by fast look)
* memory management. Dictionaries and
RenameRewriteRule, and I defer to Teodor about the gist and gin
functions. The others range somewhere between no and hell no.
I think that gistcentryinit() and extractEntriesS() should not be a
static.
---(end of broadcast)---
TIP 9: In
: select text[] '{asd}';
Is it desired effect?
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast)---
TIP 3: Have you checked
);
ERROR: syntax error at or near (
LINE 1: select 'as'::pg_catalog.char(2);
2)
postgres=# select char(2) 'as';
bpchar
as
(1 row)
postgres=# select pg_catalog.char(2) 'as';
ERROR: syntax error at or near 'as'
LINE 1: select pg_catalog.char(2) 'as';
--
Teodor Sigaev
of expressions. It was done for simplify far future :)
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
user_defined_typmod.gz
Description: Unix tar archive
---(end
to commit this patch to 8.2?
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Quad-CPU system (Xeon, 2
physical CPU's, 2 hyperthreading), one node running the database, the other one
the webserver.
Any ideas?
Oops, wait a bit: problem is founded in gist_between() call.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED
Oops, wait a bit: problem is founded in gist_between() call.
Fixed in 7.3 - HEAD versions. Thank you for feedback: those bugs can be found
only on high-loaded boxes.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED
by', postgres uses index but plan becomes the same as
before, with seqscan=off.
Can I tweak something in 8.1 or it's a bug?
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru
| ''6 \\'' !|'')))');
# insert into tt values ( NULL, E'1(''2''('' 4''(\\|5 | ''6 \\'' !|'')))');
and try dump table and restore:
ERROR: syntax error
CONTEXT: COPY tt, line 5, column tq: '1 ''2'
PS I'm not subscribed to -patches, so I post to -hackers
--
Teodor Sigaev
/msg01412.php
And several questions in private mail...
Now hstore is stable module.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast
Patch isn't full, simple test (values are took from regression.diffs):
and try dump table and restore:
ERROR: syntax error
CONTEXT: COPY tt, line 5, column tq: '1 ''2'
Attached cumulative patch fixes problem, but I have some doubts, is it really
needed?
--
Teodor Sigaev
devel=# select 'blah foo bar'::tsvector = 'blah foo bar'::tsvector;
?column?
--
f
(1 row)
Fixed in 8.1 and HEAD. Thank you
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru
why it's needed :)
The reason of bug was: some internal parts of tsvector should be shortaligned,
so there was an unused bytes. Previous comparing function compares they too...
--
Teodor Sigaev E-mail: [EMAIL PROTECTED
Oops. Fixed.
Tom Lane wrote:
Teodor Sigaev [EMAIL PROTECTED] writes:
Fixed in 8.1 and HEAD. Thank you
This appears to have created a regression test failure:
*** ./expected/tsearch2.out Sun Jun 18 12:55:28 2006
--- ./results/tsearch2.out Thu Aug 24 14:30:02 2006
is
important. I don't understand the data structure well enough to know
which one to believe, but something's not consistent here.
You are right: Pos really means position of lexeme itself in a tail of tsvector
structure. So, it's removed from comparison.
--
Teodor Sigaev
space map settings
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
cmp
SET SI = 1
OK
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast)---
TIP 6: explain analyze is your friend
Huh, it's a over-optimization by icc on Itanium. With -00 or -02 there
is no any problem, only -O2 produces such effect. The problem is in code
Sorry, right With -00 or -01 there is no any problem
--
Teodor Sigaev E-mail: [EMAIL PROTECTED
-O2 -nolib_inline -o 1 1.c ./1
CALL cmp
SET SI = 1
OK
PS Have anybody any thoughts about workaround?
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end
) -nolib_inline
IMHO, only -O1 is guarantee for other possible places... But I'm not familiar
enough with such kinds of bugs.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru
ereport(...errmsg(trouble at offset UINT64_FORMAT, bigintvar));
One more solution: add format code %D to expand_fmt_string() which should be
expanded to usual %d on 32-bit architecture and to UINT64_FORMAT on 64-bit.
--
Teodor Sigaev E-mail: [EMAIL
Patch adds GIN documentation and slightly improves GiST docs.
Somebody of native English speakers, pls, check the text... Thank you.
gindocs.gz
Description: application/gzip
---(end of broadcast)---
TIP 4: Have you searched our list archives?
on my email tomorrow, update the open items list for
8.2, and then return to the release notes for cleanup.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end
I see two entries:
* Improve subtransaction performance (Alvaro, Itagaki Takahiro, Tom)
* Improve sub-transaction performance (Itagaki Takahiro)
Aren't they the same?
Markup: New operators for array-subset comparisons (@, @, amp;amp;)
--
Teodor Sigaev
When we was talking about optimizing 'ORDER BY .. LIMIT' with Oleg and Alvaro at
conference, we was thinking to make new executor's node - Partial Sort. And
planner may choose which nodes to use: nodeSort and nodeLimit or nodePartialSort.
--
Teodor Sigaev E
* -Add fillfactor to control reserved free space during index creation
GIN doesn't use fillfactor yet...
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end
or half of total memory for shared
buffer, then effective_cache_size will have good approximation...
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end
if exists foo(int);' | psql wow
SET
NOTICE: function foo(%
Looks like uninitialized pointer...
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast
double and
triple-check the client-side stuff first ;-)
All characters in query are an ANSI. On freebsd encoding of client and server is
a KOI8-R, not an UTF.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW
=# drop function if exists foo(int);
NOTICE: function foo(
^^^ here psql is stopped..
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end
is a list of TypeName...
Andrew Dunstan wrote:
Teodor Sigaev wrote:
postgres=# drop type if exists foo;
NOTICE: type foo does not exist, skipping
DROP TYPE
postgres=# drop table if exists foo;
NOTICE: table foo does not exist, skipping
DROP TABLE
postgres=# drop function if exists foo();
NOTICE
...
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
| grep 't'
% echo 'SELECT count(*) FROM tst WHERE ROW(tst.*) IS NULL;' | psql wow
SET
count
---
0
(1 row)
What do I do wrong? Version of postgres - today's HEAD.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED
, IS NOT
NULL is true if all the row's fields are not null. The former coding got
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast
101 - 200 of 812 matches
Mail list logo