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
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
>
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
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
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
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
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
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
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
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
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
11 matches
Mail list logo