Hi,
Apparently, the amount of free space on the partition makes a big
difference in performance. I went from about 30% free space to about
5% and this triggered the performance issues. As soon as freed up
the drive to about 30% free space again the performance issues went
away.
Benjam
Benjamin Arai wrote:
> Hi,
>
> I upgraded to 8.2.4 but there was no significant change in performance.
> I did notice that hte query appears to be executed incorrectly.
> I have pasted the EXPLAIN ANALYZE below to illustrate:
>
> =# explain analyze select s_content,textdir from (SELECT * from
>
Hi,
I upgraded to 8.2.4 but there was no significant change in
performance. I did notice that hte query appears to be executed
incorrectly. Specifically, it appears to perform each equality
operation then perform a bitwise AND. I think it should instead be
performing one of the equaliti
Benjamin Arai <[EMAIL PROTECTED]> writes:
> To follow up on my own email, by disabling BitmapScan in my
> postgresql.conf the performance seems to be better. Is something
> wrong with the query analyzer?
I just rewrote choose_bitmap_and() to fix some issues that might be
related to this; pleas
To follow up on my own email, by disabling BitmapScan in my
postgresql.conf the performance seems to be better. Is something
wrong with the query analyzer?
v=# explain select s_content,textdir from text_search where
path_id='1' AND tb_id='P2_TB1';
Can anybody explain to me why this query is executing so slow?
=# explain select s_content,textdir from text_search where
path_id='1' AND tb_id='P2_TB1';
QUERY PLAN
