On Sun, Feb 26, 2017 at 4:28 PM, Sven R. Kunze wrote:
> Hello everyone,
>
> I am currently evaluating the possibility of using PostgreSQL for storing
> and querying jsonb+tsvector queries. Let's consider this setup:
>
> create table docs (id serial primary key, meta jsonb);
> # generate 10M entri
On Sat, Mar 19, 2016 at 5:44 AM, Jeff Janes wrote:
> On Wed, Mar 16, 2016 at 6:53 AM, Andreas Joseph Krogh
> wrote:
>
>> På onsdag 16. mars 2016 kl. 14:37:27, skrev Tom Lane :
>>
>> Andreas Joseph Krogh writes:
>> > 1. Why isnt' folder_id part of the index-cond?
>>
>> Because a GIN index is use
On Mon, Mar 21, 2016 at 5:41 PM, Andreas Joseph Krogh
wrote:
> På lørdag 19. mars 2016 kl. 03:44:55, skrev Jeff Janes <
> jeff.ja...@gmail.com>:
>
> On Wed, Mar 16, 2016 at 6:53 AM, Andreas Joseph Krogh
> wrote:
>>
>> På onsdag 16. mars 2016 kl. 14:37:27, skrev Tom Lane :
>>
>> Andreas Joseph Kr
On Tue, Apr 22, 2014 at 10:28 AM, Heikki Linnakangas
wrote:
> On 04/20/2014 07:46 AM, Oleg Bartunov wrote:
>>
>> btw, 9.4 should be wiser in case of rare+common terms, thanks to GIN
>> fast scan feature.
>
>
> Indeed, although we didn't actually do anything to
btw, 9.4 should be wiser in case of rare+common terms, thanks to GIN
fast scan feature.
On Sun, Apr 20, 2014 at 8:30 AM, Laurence Parry wrote:
> As mentioned here and elsewhere (most recently in "How can I get the query
> planner to use a bitmap index scap instead of an index scan ?" - 8 Mar
> 20
large numbers of matches."""
(last paragraph of)
http://www.postgresql.org/docs/current/static/textsearch-controls.html#TEXTSEARCH-RANKING
Hope that helps!
Fran?ois Beausoleil
Regards,
Oleg
_
Oleg Bartu
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
--
Sent via
; Index Scan using zipcodes_knn on zipcodes (cost=0.00..5365.93
rows=41483 width=22) (actual time=0.440..1.407 rows=100 loops=1)
Order By: (lon_lat <-> '(-118.412426,34.096629)'::point)
Total runtime: 2.198 ms
Regards,
Oleg
e easy to implement, but perhaps there is a better
way. To those who have covered this area already, what's the best way
to put multiple cores to use when running repeated SELECTs with PostgreSQL?
Thanks!
Mark
Regards,
Oleg
______
nd error message.
On Mon, Nov 29, 2010 at 6:37 PM, Oleg Bartunov wrote:
What does replace(' Dhaka University of Bangladesh:*', ' ',':* & ') means ?
I see it produces something wrong for to_tsquery:
test=# select replace(' Dhaka
odifiers
--++---
activityid | integer | not null default 0
subject | character varying(250) | not null
semodule | character varying(20) |
activitytype | character varying(200) | not null
date_start | date | not null
due_date
9..11.169 rows=8449 loops=1)
Index Cond: (_fts_ @@ '''fer'''::tsquery)
Total runtime: 192.686 ms
(9 rows)
Any ideas on how to verify this?
Regards,
Oleg
_
Oleg Bartunov, Rese
st
one row.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(
why the difference between the dumb queries is large
(but I don't see how this can influence tsearch2 since it pre-builds the
tsvector data with lowercase lexemes)
2) My tsearch2 lexer is somewhat slow (but I don't see how it can
influence these read-only queries on a pre-built, lexed and
x27;::text))
-> Index Scan using post_ordinal on post
(cost=0.00..6.41 rows=1 width=436) (never executed)
Index Cond: (public.post.ordinal = public.post.ordinal)
Total runtime: 1.600 ms
(13 rows)
Why is the planner "taking into consideration" the LIMIT (I know
tty quick, as it should do two index
scans (not bitmap index scans) to fetch 100 rows for each, then append
the results, sort them, and then limit again.
...Robert
--=20
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.po
mailing list
(pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astr
On Sun, 15 Nov 2009, Pavel Stehule wrote:
2009/11/15 Oleg Bartunov :
Yes, as stated original author use polish ispell dictionary.
Ispell dictionary is slow to load first time. In real life it should be no
problem.
it is a problem. People who needs fast access uses english without
czech. It
http://www.postgresql.org/mailpref/pgsql-performance
>
--=20
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Regards,
Oleg
_
rds,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
--
Sent via pgsql-perfor
you for all the help.
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera
ence and in the worst case you should expected time for the 1st query
about 53*10^4 ms.
Is there really no way to have efficient full text search results ordered by
a separate field? I'm really open to all possibilities, at this point.
Thanks.
Regards,
Ol
gh cpu load on my database server and my current theory is
that some of the triggers may be causing it.
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astron
? From our experience we learned there
are can be various corner cases.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russi
On Thu, 19 Mar 2009, Oleg Bartunov wrote:
On Thu, 19 Mar 2009, Tom Lane wrote:
Oleg Bartunov writes:
We usually say about 200 unique values as a limit for
gist_int_ops.
That seems awfully small ... should we make gist_intbig_ops the default,
or more likely, raise the signature size of
On Thu, 19 Mar 2009, Tom Lane wrote:
Oleg Bartunov writes:
We usually say about 200 unique values as a limit for
gist_int_ops.
That seems awfully small ... should we make gist_intbig_ops the default,
or more likely, raise the signature size of both opclasses? Even at a
crossover point of
We usually say about 200 unique values as a limit for
gist_int_ops.
On Wed, 18 Mar 2009, Tom Lane wrote:
Ron Mayer writes:
Oleg Bartunov wrote:
OB:> it's not about short or long arrays, it's about small or big
OB:> cardinality of the whole set (the number of unique ele
of the work of rereading and rechecking the text of all the matched
entries. Is this indeed what's going on here? Is there any way to make
postgres not do that recheck?
Thanks!
-hal
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of Astro
On Thu, 29 Jan 2009, Hari, Balaji wrote:
Is there a patch to make Wildspeed work with postgresql version 8.3.1?
unfortunately, no.
P.S
My bad, the version number was incorrect in my previous mail.
-Original Message-
From: Oleg Bartunov [mailto:o...@sai.msu.su]
Sent: Wednesday
?
Balaji
P.S The event database has 700k records.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: o...@sai.msu.su, htt
kennygorman.com/wordpress/?p=246 for some details.
I wrote a perl script, which simplifies estimation of OS buffers, but
it's not yet ready for public.
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of Astro
eSQL that it sorted the values to make
index scan more sequential, but this expectation already conflicts with
the bug described above :)
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of Ast
On Tue, 8 Apr 2008, Mark Stosberg wrote:
Oleg Bartunov wrote:
Mark,
do you know about our sky segmentation code Q3C,
see details http://www.sai.msu.su/~megera/wiki/SkyPixelization
We use it for billions objects in database and quite happy.
Oleg,
Thanks for the response. That sounds
the performance,
features and stability of PostgreSQL.
Mark
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
I
On Fri, 14 Mar 2008, Kynn Jones wrote:
On Fri, Mar 14, 2008 at 2:59 PM, Oleg Bartunov <[EMAIL PROTECTED]> wrote:
have you seen contrib/hstore ? You can have one table with common
attributes
and hide others in hstore
That's interesting. I'll check it out. Thanks!
actu
stematic profiling of
various possible scenarios, but as a first approximation what's your
rule-of-thumb?
TIA!
Kynn
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru
Island|Vic") gets a higher position?
you can read documentation and use document length normalization flag,
or write your own ranking function.
Thanks,
bw
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.21.4/1309 - Release Date: 3
help you.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +00
.
Sorry, I didn't follow your problem, but GIN should be certainly
logarithmic on the number of unique words. Also, it'd be much clear
if you show us your queries and explain analyze.
Regards,
Oleg
_
Ole
at this is theoretically not possible?
---(end of broadcast)---
TIP 6: explain analyze is your friend
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head o
-
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Instit
eally slow?
can you try rank_cd() instead ?
regards, tom lane
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Regards,
Oleg
___
http://www.postgresql.org/about/donate
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL P
appreciated.
Carlo
---(end of broadcast)---
TIP 6: explain analyze is your friend
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.ast
ey tables total about 700MB.
Primary keys are CHAR(32) GUIDs
Thanks,
Bryan
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow Universit
ql.org
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera
/wiki/GinTest
Thank you in advance,
Valentine
On 5/9/07, Oleg Bartunov <[EMAIL PROTECTED]> wrote:
Do you have both indexes (GiST, GIN) on the same table ?
On Wed, 9 May 2007, Valentine Gogichashvili wrote:
> Hello all,
>
> I am trying to move from GiST intarray index to GIN
here the problem can be with _int4 GIN index in this constellation?
by now the enable_seqscan is set to off in the configuration.
With best regards,
-- Valentine Gogichashvili
Regards,
Oleg
_____
Oleg Bartunov, Re
--(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
Regards,
Oleg
_
Oleg B
t doesn't supports
concurrency and recovery
Alexander.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Regards,
Oleg
____
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
-
ibly fast ! If we find a way to store an additional
information in index and workout visibility issue, full text search will
be damn fast.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (w
On Mon, 26 Feb 2007, Guillaume Smet wrote:
On 2/26/07, Oleg Bartunov wrote:
Did you rewrite query manually or use rewrite feature of tsearch2 ?
Currently, it's manual. I perform a pg_trgm query for each word of the
search words (a few stop words excluded) and I generate the ts_query
n't 'kill -9' the postmaster
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone:
datatypes do not
match
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-1
is HP rx1620, dual Itanium2, MSA 20, currently
4.5 Tb.
regards, tom lane
---(end of broadcast)---
TIP 6: explain analyze is your friend
Regards,
Oleg
___
confused :) What if you consider you prefix as
1.2.3.4.5.6, then you could try our contrib/ltree module.
Oleg
Regards
Alex
- Original Message - From: "Oleg Bartunov"
To: "Alexandru Coseru" <[EMAIL PROTECTED]>
Cc: "Dave Dutcher" <[EMAIL PROTECTE
x27;t selective enough, or is Postgres not able to use an index with Posix
regular expressions? The docs seem to say that it can, but I'd be curious
to see what happens if you use LIKE instead of ~.
Dave
Regards,
Oleg
___
crease your free space map settings
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007
roducts/spatial/index.html
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~m
or the headline() function? Or, does anyone know
what the problem is and how to overcome it?
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Regards,
O
gevel is available from
http://www.sai.msu.su/~megera/postgres/gist/
Oleg
On Sat, 21 Jan 2006, Martijn van Oosterhout wrote:
On Sat, Jan 21, 2006 at 04:29:13PM +0300, Oleg Bartunov wrote:
Martijn, you're right! We want not only to split page to very
different parts, but n
On Sat, 21 Jan 2006, Martijn van Oosterhout wrote:
On Sat, Jan 21, 2006 at 04:29:13PM +0300, Oleg Bartunov wrote:
Martijn, you're right! We want not only to split page to very
different parts, but not to increase the number of sets bits in
resulted signatures, which are union (OR'
signatures
without breaking search performance.
At 08:34 AM 1/21/2006, Oleg Bartunov wrote:
On Sat, 21 Jan 2006, Ron wrote:
At 07:23 PM 1/20/2006, Tom Lane wrote:
"Steinar H. Gunderson" <[EMAIL PROTECTED]> writes:
> On Fri, Jan 20, 2006 at 06:52:37PM -0500, Tom Lane wrote:
&
signatures in the page
as much 'sparse' as can.
some information available here
http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch_V2_internals
Unfortunately, we're rather busy right now and couldn't be very useful.
Ron
---(end of broadcast)
ome up with an algorithm yet
Don't ask how hard we thought :)
Regards,
Oleg
_____
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow Unive
On Tue, 20 Dec 2005, Tom Lane wrote:
Oleg Bartunov writes:
I see a very low performance and high context switches on our
dual itanium2 slackware box (Linux ptah 2.6.14 #1 SMP)
with 8Gb of RAM, running 8.1_STABLE. Any tips here ?
[EMAIL PROTECTED]:~/cvs/8.1/pgsql/contrib/pgbench$ time
---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Regards,
Oleg
__
Filter: (idx_fti @@ '''linux'' & ''kernel'''::tsquery)
-> Bitmap Index Scan on idx_fti_idx (cost=0.00..3.83
rows=237 width=0) (actual time=4.675..4.675 rows=10 loops=1)
Index Cond: (idx_fti @@ '''linux'&#
---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Regards,
Oleg
_____
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow
ing I might look at that would help
improve performance (like, do I need more memory? More shared memory?
Different config parameters?)
Thanks,
Craig
Regards,
Oleg
_____
Oleg Bartunov, sci.researcher, hostmaster
.2 release.
Unfortunately, I didn't find spare time to package tsearchd for you,
it should certainly help you.
Regards,
Oleg
_
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http:
ery to this table, I think the query will
be very slow to get a result.
oh guy, you certainly need to read documentation
http://www.postgresql.org/docs/8.0/static/sql-cluster.html
Regards,
ahmad fajar
Regards,
Oleg
though reiserfs is fast enough for
postgresql. And must I down grade my postgresql from version 8.0.3 to 7.4.8?
I'm not experienced with filesystems :)
Regards,
ahmad fajar
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Oleg Bartunov
Sent: Satu
0
the server I configure just only for postgresql, no other service is running
like: www, samba, ftp, email, firewall
hardware configuration:
Motherboard ASUS P5GD1
Processor P4 3,2 GHz
Memory 2 GB DDR 400,
2x200 GB Serial ATA 7200 RPM UltraATA/133, configure as RAID0 for pos
of your queries, so we can't help you.
How big is your database, tsearch2 index size ?
Regards,
ahmad fajar
-Original Message-
From: Oleg Bartunov [mailto:[EMAIL PROTECTED]
Sent: Jumat, 23 September 2005 14:36
To: Ahmad Fajar
Cc: pgsql-performance@postgresql.org
Subject: Re: [PER
d configure as
RAID0 (just for postgres data), my sistem run at EIDE 80GB 7200 RPM.
Please.help.help.
Regards,
Oleg
_____
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical I
content
or example chapters
or what ever else.
Does anybody have an idea where I can find a database like this or does
even have something like this?
Regards,
Oleg
_
Oleg Bartunov, sci.researcher, hostmaster of
ose an index scan if your joining column's datatypes do not
match
Regards,
Oleg
_
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http:
u can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Regards,
Oleg
_
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
S
oining column's datatypes do not match
Met vriendelijke groeten,
Bien ? vous,
Kind regards,
Yves Vindevogel
Implements
Regards,
Oleg
_
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg
Oleg
_____
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
---
On Thu, 24 Mar 2005, Rick Jansen wrote:
Oleg Bartunov wrote:
from my notes
http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch_V2_Notes
It's usefull to see words statistics, for example, to check how good
your dictionaries work or how did you configure pg_ts_cfgmap. Also, you
may n
On Wed, 23 Mar 2005, Rick Jansen wrote:
Oleg Bartunov wrote:
On Tue, 22 Mar 2005, Rick Jansen wrote:
Hmm, default configuration is too eager, you index every lexem using simple
dictionary) ! Probably, it's too much. Here is what I have for my russian
configuration in dictionary dat
On Tue, 22 Mar 2005, Rick Jansen wrote:
Oleg Bartunov wrote:
Mike,
no comments before Rick post tsearch configs and increased buffers !
Union shouldn't be faster than (term1|term2).
tsearch2 internals description might help you understanding tsearch2
limitations.
See http://www.sai.m
are, howmuch memory you have and such?
16G of RAM on a dedicated machine.
shared_buffers = 15000 # min 16, at least max_connections*2, 8KB
each
work_mem = 10240# min 64, size in KB
maintenance_work_mem = 100 # min 1024, size in KB
# big m_w_m for loading data...
ra
important. I've seen a lot of
mistakes in configs !
Regards,
Oleg
_____
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.
te much more
memory.
Regards,
Oleg
_____
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +0
t's possible to combine search results.
This is rather easy to implement using table inheritance, but I'd like
to do this with partitioning
Regards,
Oleg
_____
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
_
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
---(end of broadcast
On Wed, 9 Mar 2005, Werner Bohl wrote:
On Wed, 2005-03-09 at 20:41 +0300, Oleg Bartunov wrote:
What's your tsearch2 configuration ? Do you use dictionaries ?
I wrote a brief explanation of tsearch2 internals
http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch_V2_internals
Tsearch2 is
anation of tsearch2 internals
http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch_V2_internals
Hope, it could help you.
TIA,
Regards,
Oleg
_____
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Ast
regards, tom lane
Regards,
Oleg
_____
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
---
Marinos,
what if you construct "apachebench & Co" free script and see if
the issue still exists. There are could be many issues doesn't
connected to postgresql and tsearch2.
Oleg
On Thu, 3 Feb 2005, Marinos J. Yannikos wrote:
Oleg Bartunov wrote:
On Thu, 3 Feb 2005, Marino
espite
an apachebench with concurrency 10 stressing the php script that uses
tsearch2, with practically no disk accesses)
I'm willing to see some details: version, query, explain analyze.
Regards,
Marinos
Regards,
Oleg
___
ntime: 0.391 ms
---
Note that the meaning is different ; the IN removes duplicates in the array
but the join does not.
Regards,
Oleg
_
Oleg Bartunov, sci.researche
OPERATIONS and EXAMPLE USAGE:
SELECT * FROM table WHERE id && int[]
Thanks.
Regards,
Oleg
_
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University
Regards,
Oleg
_
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095
1;2c1;2c1;2cBlin !
what's happenning with my terminal when I read messagess from this guy ?
I don't even know how to call him - I see just Herv?
Oleg
1;2c1;2c1;2c1;2c
1;2cOn Thu, 18 Nov 2004, [iso-8859-15] Herv? Piedvache wrote:
Le Jeudi 18 Novembre 2004 10:37, Oleg Bartunov a ?c
1 - 100 of 105 matches
Mail list logo
