Re: [PERFORM] SeqScan with full text search

2012-04-16 Thread Merlin Moncure
On Mon, Apr 16, 2012 at 9:02 AM, Tomek Walkuski wrote: > Hello group! > > I have query like this: > > SELECT >  employments.candidate_id AS candidate_id, >  SUM(TS_RANK(employers.search_vector, TO_TSQUERY('simple', 'One:* | > Two:* | Three:* | Four:*'), 2)) AS ts_rank > FROM >  employments > INNER

Re: [PERFORM] SeqScan with full text search

2012-04-16 Thread Tomas Vondra
On 16.4.2012 16:02, Tomek Walkuski wrote: > Hello group! > > I have query like this: > > SELECT > employments.candidate_id AS candidate_id, > SUM(TS_RANK(employers.search_vector, TO_TSQUERY('simple', 'One:* | > Two:* | Three:* | Four:*'), 2)) AS ts_rank > FROM > employments > INNER JOIN >

Re: [PERFORM] H800 + md1200 Performance problem

2012-04-16 Thread Merlin Moncure
On Mon, Apr 16, 2012 at 10:45 AM, Scott Marlowe wrote: > On Mon, Apr 16, 2012 at 8:13 AM, Cesar Martin wrote: >> Hi, >> >> Finally the problem was BIOS configuration. DBPM had was set to "Active >> Power Controller" I changed this to "Max >> Performance". http://en.community.dell.com/techcenter/p

Re: [PERFORM] scale up (postgresql vs mssql)

2012-04-16 Thread Richard Huxton
On 15/04/12 13:43, Eyal Wilde wrote: "version";"PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-46), 64-bit" You've probably checked this, but if not it's worth making sure your disk I/O is roughly equivalent for the two operating-systems. It

Re: [PERFORM] H800 + md1200 Performance problem

2012-04-16 Thread Scott Marlowe
On Mon, Apr 16, 2012 at 8:13 AM, Cesar Martin wrote: > Hi, > > Finally the problem was BIOS configuration. DBPM had was set to "Active > Power Controller" I changed this to "Max > Performance". http://en.community.dell.com/techcenter/power-cooling/w/wiki/best-practices-in-power-management.aspx > N

Re: [PERFORM] scale up (postgresql vs mssql)

2012-04-16 Thread Andy Colson
On 4/15/2012 7:43 AM, Eyal Wilde wrote: hi, thanks a lot to all of you for your help. (i'm sorry i did not know how to reply to a certain message) i found that the best number of active connections is indeed 8-10. with 8-10 active connections postgresql did ~170 "account-id"s. this is still on

[PERFORM] SeqScan with full text search

2012-04-16 Thread Tomek Walkuski
Hello group! I have query like this: SELECT employments.candidate_id AS candidate_id, SUM(TS_RANK(employers.search_vector, TO_TSQUERY('simple', 'One:* | Two:* | Three:* | Four:*'), 2)) AS ts_rank FROM employments INNER JOIN employers ON employments.employer_id = employers.id AND employe

Re: [PERFORM] scale up (postgresql vs mssql)

2012-04-16 Thread Eyal Wilde
hi, thanks a lot to all of you for your help. (i'm sorry i did not know how to reply to a certain message) i found that the best number of active connections is indeed 8-10. with 8-10 active connections postgresql did ~170 "account-id"s. this is still only half of what mssql did, but it now make

Re: [PERFORM] H800 + md1200 Performance problem

2012-04-16 Thread Cesar Martin
Hi, Finally the problem was BIOS configuration. DBPM had was set to "Active Power Controller" I changed this to "Max Performance". http://en.community.dell.com/techcenter/power-cooling/w/wiki/best-practices-in-power-management.aspx Now wirite speed are 550MB/s and read 1,1GB/s. Thank you all for

Re: [PERFORM] Slow fulltext query plan

2012-04-16 Thread Florent Guillaume
Tom Lane wrote: > Benoit Delbosc  writes: >>  On 13/04/2012 00:25, Tom Lane wrote: >>>  Is there a reason why you're writing the query in such a >>>  non-straightforward way, rather than just >>> >>>  EXPLAIN ANALYZE SELECT hierarchy.id >>>  FROM hierarchy >>>  JOIN fulltext ON fulltext.id = hierar

Re: [PERFORM] scale up (postgresql vs mssql)

2012-04-16 Thread Merlin Moncure
On Wed, Apr 11, 2012 at 5:11 PM, Eyal Wilde wrote: > hi, > > i had a stored procedure in ms-sql server. this stored procedure gets a > parameter (account-id), dose about 20 queries, fills some temporary tables, > and finally, returns a few result-sets. this stored procedure converted to > stored f