Re: [PERFORM] Speeding up JSON + TSQUERY + GIN

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); > #

Re: [PERFORM] Searching GIN-index (FTS) and sort by timestamp-column

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:

Re: [PERFORM] Searching GIN-index (FTS) and sort by timestamp-column

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,

Re: [PERFORM] Workaround: Planner preference for tsquery filter vs. GIN index in fast text search

On Tue, Apr 22, 2014 at 10:28 AM, Heikki Linnakangas hlinnakan...@vmware.com 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 the planner to make

Re: [PERFORM] Workaround: Planner preference for tsquery filter vs. GIN index in fast text search

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 greenrea...@hotmail.com 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

Re: [PERFORM] Ways to speed up ts_rank

://www.postgresql.org/docs/current/static/textsearch-controls.html#TEXTSEARCH-RANKING Hope that helps! Fran?ois Beausoleil Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg

Re: [PERFORM] Performance issues

_ 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

Re: [PERFORM] application of KNN code to US zipcode searches?

, 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

Re: [PERFORM] Full Text index is not using during OR operation

_ 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-performance mailing list (pgsql

Re: [PERFORM] Full Text index is not using during OR operation

29, 2010 at 6:37 PM, Oleg Bartunov o...@sai.msu.su wrote: What does replace(' Dhaka University of Bangladesh:*', ' ',':* ') means ? I see it produces something wrong for to_tsquery: test=# select replace(' Dhaka University of Bangladesh:*', ' ',':* '); replace

Re: [PERFORM] Understanding tsearch2 performance

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 indexed data) Any ideas? Regards, Oleg _ Oleg Bartunov

Re: [PERFORM] Understanding tsearch2 performance

. 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(495)939-16

Re: [PERFORM] Understanding tsearch2 performance

_ 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-performance mailing

Re: [PERFORM] Ugh - bad plan with LIMIT in a complex SELECT, any way to fix this?

_ 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-performance mailing list (pgsql

Re: [PERFORM] Digesting explain analyze

/mailpref/pgsql-performance Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http

Re: [PERFORM] FTS performance with the Polish config

On Sun, 15 Nov 2009, Pavel Stehule wrote: 2009/11/15 Oleg Bartunov o...@sai.msu.su: 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

Re: [PERFORM] FTS performance with the Polish config

-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.astronet.ru), Sternberg

Re: [PERFORM] FTS performance with the Polish config

) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute

Re: [PERFORM] Full text search with ORDER BY performance issue

, 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

Re: [PERFORM] Atomic access to large arrays

_ 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-performance mailing list (pgsql

Re: [PERFORM] Full text search with ORDER BY performance issue

. 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, Oleg _ Oleg Bartunov, Research Scientist, Head

Re: [PERFORM] GiST index performance

data ? 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

Re: [PERFORM] Extremely slow intarray index creation and inserts.

We usually say about 200 unique values as a limit for gist_int_ops. On Wed, 18 Mar 2009, Tom Lane wrote: Ron Mayer rm...@cheapcomplexdevices.com 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

Re: [PERFORM] Extremely slow intarray index creation and inserts.

On Thu, 19 Mar 2009, Tom Lane wrote: Oleg Bartunov o...@sai.msu.su 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

Re: [PERFORM] Extremely slow intarray index creation and inserts.

On Thu, 19 Mar 2009, Oleg Bartunov wrote: On Thu, 19 Mar 2009, Tom Lane wrote: Oleg Bartunov o...@sai.msu.su 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

Re: [PERFORM] bitmap heap scan recheck on full text search with gin index

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

Re: [PERFORM] LIKE Query performance

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

Re: [PERFORM] LIKE Query performance

_ 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-performance

Re: [PERFORM] how to estimate shared_buffers...

/?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 AstroNet (www.astronet.ru

Re: [PERFORM] IN() statement values order makes 2x performance hit

above :) 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

Re: [PERFORM] Re: what worked: performance improvements for geo-spatial searching on FreeBSD

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

Re: [PERFORM] what worked: performance improvements for geo-spatial searching on FreeBSD

and stability of PostgreSQL. Mark Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: [EMAIL PROTECTED

Re: [PERFORM] The many nulls problem

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), Sternberg Astronomical Institute, Moscow

Re: [PERFORM] The many nulls problem

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! actually, hstore

Re: [PERFORM] Improve Full text rank in a query

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/03/2008 6:50 PM Regards, Oleg _ Oleg Bartunov, Research Scientist, Head

Re: [PERFORM] t1.col like '%t2.col%'

, 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, +007(495)939-23

Re: [PERFORM] index usage on arrays

_ 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, +007(495)939-23-83

Re: [PERFORM] Search for fixed set of keywords

. 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 _ Oleg Bartunov

Re: [PERFORM] Search for fixed set of keywords

not possible? ---(end of broadcast)--- TIP 6: explain analyze is your friend Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet

Re: [PERFORM] TB-sized databases

our list archives? http://archives.postgresql.org Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia

Re: [PERFORM] [GENERAL] Slow TSearch2 performance for table with 1 million documents.

? regards, tom lane ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings Regards, Oleg _ Oleg Bartunov, Research

Re: [PERFORM] Fast tsearch2, trigram matching on short phrases

---(end of broadcast)--- TIP 6: explain analyze is your friend Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg

Re: [PERFORM] Fast tsearch2, trigram matching on short phrases

://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 PROTECTED], http

Re: [PERFORM] startup caching suggestions

Thanks, Bryan 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

Re: [PERFORM] Slow indexscan

_ 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, +007(495)939-23-83 ---(end

Re: [PERFORM] Cannot make GIN intarray index be used by the planner

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, Research Scientist, Head

Re: [PERFORM] index structure for 114-dimension vector

. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet

Re: [PERFORM] Simple query, 10 million records...MySQL ten times faster

the PostgreSQL project by donating at http://www.postgresql.org/about/donate Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute

Re: [PERFORM] Array indexes, GIN?

_ 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 ---(end of broadcast

Re: [PERFORM] Writting a search engine for a pgsql DB

! 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 (www.astronet.ru

Re: [PERFORM] pg_trgm performance

_ 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 ---(end of broadcast

Re: [PERFORM] pg_trgm performance

On Mon, 26 Feb 2007, Guillaume Smet wrote: On 2/26/07, Oleg Bartunov oleg@sai.msu.su 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

Re: [PERFORM] optimizing a geo_distance() proximity query

_ 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 ---(end of broadcast

Re: [pgsql-advocacy] [PERFORM] Postgres and really huge tables

, currently 4.5 Tb. regards, tom lane ---(end of broadcast)--- TIP 6: explain analyze is your friend Regards, Oleg _ Oleg Bartunov

Re: [PERFORM] Regex performance issue

to say that it can, but I'd be curious to see what happens if you use LIKE instead of ~. Dave Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical

Re: [PERFORM] Regex performance issue

was 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 oleg@sai.msu.su To: Alexandru Coseru [EMAIL PROTECTED] Cc: Dave Dutcher [EMAIL PROTECTED]; pgsql-performance

Re: [PERFORM] Help optimizing a slow index scan

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

Re: [PERFORM] Help optimizing a slow index scan

_ 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 ---(end of broadcast

Re: [PERFORM] tsearch2 headline and postgresql.conf

is and how to overcome it? ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq Regards, Oleg _ Oleg

Re: [PERFORM] [GENERAL] Creation of tsearch2 index is very slow

how hard we thought :) Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@sai.msu.su, http

Re: [PERFORM] [GENERAL] Creation of tsearch2 index is very

be very useful. Ron ---(end of broadcast)--- TIP 6: explain analyze is your friend Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet

Re: [PERFORM] [GENERAL] Creation of tsearch2 index is very

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: It's also worth considering

Re: [PERFORM] [GENERAL] Creation of tsearch2 index is very slow

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'ed) of all

Re: [PERFORM] [GENERAL] Creation of tsearch2 index is very slow

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

Re: [PERFORM] High context switches occurring

to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute

Re: [PERFORM] First query is slow, subsequent queries fast

)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg

Re: [PERFORM] TSearch2 vs. Apache Lucene

extensive FAQ? http://www.postgresql.org/docs/faq Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg

Re: [PERFORM] tsearch2/GIST performance factors?

/oddmuse/index.cgi/todo and hope to find sponsorhips for fts project for 8.2 release. Unfortunately, I didn't find spare time to package tsearchd for you, it should certainly help you. Regards, Oleg _ Oleg Bartunov

Re: [PERFORM] tsearch2 seem very slow

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oleg Bartunov Sent: Saturday, September 24, 2005 1:08 PM To: Ahmad Fajar Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] tsearch2 seem very slow Ahmad, what's about the number of unique words ? I

Re: [PERFORM] tsearch2 seem very slow

, 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

Re: [PERFORM] tsearch2 seem very slow

ATA 7200 RPM UltraATA/133, configure as RAID0 for postgresql data and the partition is EXT3 1x80 GB EIDE 7200 RPM configure for system and home directory and the partiton is EXT3 Did I miss something? Regards, ahmad fajar -Original Message- From: Oleg Bartunov [mailto:[EMAIL PROTECTED

Re: [PERFORM] tsearch2 seem very slow

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: [PERFORM] tsearch2 seem very slow Ahmad, how fast is repeated runs ? First time system

Re: [PERFORM] Looking for a large database for testing

of 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

Re: [PERFORM] Forums tsearch2 - best practices reg. concurrency

_ 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

Re: [PERFORM] Fwd: Index on table when using DESC clause

not match Met vriendelijke groeten, Bien ? vous, Kind regards, Yves Vindevogel Implements Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow

Re: [PERFORM] Tsearch2 performance on big database

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 notice

Re: [PERFORM] Delete query takes exorbitant amount of time

_ 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)--- TIP

Re: [PERFORM] Tsearch2 performance on big database

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.su, http://www.sai.msu.su

Re: [PERFORM] Tsearch2 performance on big database

... random_page_cost = 2.5 # units are one sequential page fetch cost # fast drives, and tons of RAM Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow

Re: [PERFORM] Tsearch2 performance on big database

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.msu.su

Re: [PERFORM] What needs to be done for real Partitioning?

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, Sternberg Astronomical Institute, Moscow

Re: [PERFORM] How to speed up tsearch2 indexing

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 using

Re: [PERFORM] GiST indexes and concurrency (tsearch2)

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 _ Oleg

Re: [PERFORM] GiST indexes and concurrency (tsearch2)

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, Marinos J. Yannikos wrote

Re: [PERFORM] GiST indexes and concurrency (tsearch2)

semtimedo ^ What's the platform exactly (hardware and OS)? it should be 'semtimedop' regards, tom lane Regards, Oleg _ Oleg

Re: [PERFORM] [SQL] OFFSET impact on Performance???

, 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

Re: [PERFORM] Tsearch2 really slower than ilike ?

Have you run 'vacuum analyze' ? 1;2c1;2c1;2c 1;2c1;2c1;2cmy desktop is very simple PIII, 512 Mb RAM. 1;2c1;2c1;2cOleg 1;2c1;2c1;2c 1;2c1;2c1;2cOn Thu, 18 Nov 2004, [iso-8859-15] Herv? Piedvache wrote: Oleg, Le Mercredi 17 Novembre 2004 18:23, Oleg Bartunov a ?crit : Sorry but when I do your

Re: [PERFORM] Tsearch2 really slower than ilike ?

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 ?crit : Have

Re: [PERFORM] Tsearch2 really slower than ilike ?

about poor tsearch2 performance. 1;2c1;2c1;2c What is this ? (private: I don't know what happend with my mail, but I do nothing special to disturb the contains when I'm writting to you ...) Le Mardi 16 Novembre 2004 22:13, Oleg Bartunov a ?crit : ok, I downloaded dump of table and here is what I

Re: [PERFORM] Tsearch2 really slower than ilike ?

... Regards, Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16

Re: [PERFORM] Tsearch2 really slower than ilike ?

, Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83

Re: [PERFORM] Tsearch2 really slower than ilike ?

_ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast