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

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

Re: [PERFORM] sequential scan performance

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

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

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:

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

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

Re: [PERFORM] tsearch2 seem very slow

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

Re: [PERFORM] tsearch2 seem very slow

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

Re: [PERFORM] tsearch2 seem very slow

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

Re: [PERFORM] tsearch2 seem very slow

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

Re: [PERFORM] tsearch2 seem very slow

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

Re: [PERFORM] tsearch2/GIST performance factors?

.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:

Re: [PERFORM] tsearch2/GIST performance factors?

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

Re: [PERFORM] TSearch2 vs. Apache Lucene

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

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

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'&#

Re: [PERFORM] High context switches occurring

--- 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 __

Re: [PERFORM] High context switches occurring

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

Re: [PERFORM] Regex performance issue

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 ___

Re: [PERFORM] Regex performance issue

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

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

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 ___

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

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

Re: [PERFORM] pg_trgm performance

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:

Re: [PERFORM] pg_trgm performance

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

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

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

Re: [PERFORM] Array indexes, GIN?

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 -

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

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 ____

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

--(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

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

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

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

/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

Re: [PERFORM] Slow indexscan

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

Re: [PERFORM] startup caching suggestions

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

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

appreciated. Carlo ---(end of broadcast)--- TIP 6: explain analyze is your friend Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.ast

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

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

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

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 ___

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

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

Re: [PERFORM] Understanding tsearch2 performance

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

Re: [PERFORM] Understanding tsearch2 performance

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(

Re: [PERFORM] Understanding tsearch2 performance

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

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

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

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

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

Re: [PERFORM] getting the most of out multi-core systems for repeated complex SELECT statements

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 ______

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

; 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

Re: [PERFORM] Performance issues

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

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

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

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

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)

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

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: &

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'

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, but n

Re: [PERFORM] tsearch2 headline and postgresql.conf

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

Re: [PERFORM] Help optimizing a slow index scan

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

Re: [PERFORM] Help optimizing a slow index scan

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

Re: [PERFORM] Tsearch2 really slower than ilike ?

t than few words ?? sorry ... Regards, Regards, Oleg _____ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~meger

Re: [PERFORM] Tsearch2 really slower than ilike ?

gards, 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-

Re: [PERFORM] Tsearch2 really slower than ilike ?

II 933 Mhz and 1 Gb of RAM. Any idea ... ? For the moment I'm going back to use the ilike solution ... but I was really thinking that Tsearch2 could be a better solution ... Regards, Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of

Re: [PERFORM] Tsearch2 really slower than ilike ?

queries at all ? I mean your first message 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

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

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

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

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

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

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

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

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

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

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 ___

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, Marino

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

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

Re: [PERFORM] How to speed up tsearch2 indexing

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

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

Re: [PERFORM] Statistics not working??

_ 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] What needs to be done for real Partitioning?

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,

Re: [PERFORM] Tsearch2 performance on big database

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

Re: [PERFORM] Tsearch2 performance on big database

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.

Re: [PERFORM] Tsearch2 performance on big database

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

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.m

Re: [PERFORM] Tsearch2 performance on big database

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

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 n

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

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] TB-sized databases

- 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

Re: [PERFORM] Search for fixed set of keywords

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

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

Re: [PERFORM] index usage on arrays

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

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

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(

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

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

Re: [PERFORM] The "many nulls" problem

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

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! actu

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

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

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] IN() statement values order makes 2x performance hit

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

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

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

Re: [PERFORM] LIKE Query performance

? 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

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] 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 Bartunov, Research Scientist, Head of Astro

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

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

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

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

Re: [PERFORM] GiST index performance

? 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

Re: [PERFORM] tsvector_update_trigger performance?

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

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

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

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

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

Re: [PERFORM] Atomic access to large arrays

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

Re: [PERFORM] FTS performance with the Polish config

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 _

Re: [PERFORM] FTS performance with the Polish config

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

Re: [PERFORM] FTS performance with the Polish config

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

Re: [PERFORM] Digesting explain analyze

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

Re: [PERFORM] Ways to speed up ts_rank

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

  1   2   >