Re: Slow query: bitmap scan troubles - Mailing list pgsql-performance

From
Subject Re: Slow query: bitmap scan troubles
Date
Msg-id 098601cdd250$ce2f85d0$6a8e9170$@foo.me.uk
Whole thread Raw
In response to Re: Slow query: bitmap scan troubles  (Claudio Freire <klaussfreire@gmail.com>)
List pgsql-performance
Ah, okay - my reasoning was there's a big fancy-pants raid array behind it
that makes disk operations faster relative to CPU ones.

I'll test it and see if it actually makes any difference.

-----Original Message-----
From: Claudio Freire [mailto:klaussfreire@gmail.com]
Sent: 04 December 2012 18:33
To: Philip Scott
Cc: postgresql@foo.me.uk; postgres performance list
Subject: Re: [PERFORM] Slow query: bitmap scan troubles

On Tue, Dec 4, 2012 at 3:31 PM, Philip Scott <pscott@foo.me.uk> wrote:
> r_p_c 2-> 1 (s_p_c 1->0.5):

Is this really necessary?

(looks like a no-op, unless your CPU is slow)




pgsql-performance by date:

Previous
From: Vitalii Tymchyshyn
Date:
Subject: Re: Slow query: bitmap scan troubles
Next
From:
Date:
Subject: Re: Slow query: bitmap scan troubles