Karl,
> For reference, I was having SEVERE performance problems with the
> following comparison in an SQL statement where "mask" was an integer:
>
> "select ... from where .. and (permission & mask = permission)"
AFAIK, the only way to use an index on these queries is through
expression
"Scott Otis" wrote:
> So is there anything I can do in 8.3 to help this? I have tried
> setting 'track_activities', 'track_counts' and 'autovacuum' to 'off'
> (which has reduced CPU and I/O a bit)
You're going to regret that very soon, unless you are *very* sure you
have adequate manual vacuu
So is there anything I can do in 8.3 to help this? I have tried setting '
track_activities', 'track_counts' and 'autovacuum' to 'off' (which has reduced
CPU and I/O a bit) - but the stats collector process is still using up a good
deal of CPU and I/O - is there any way to turn stats collecting
Does the planner know how to use indices to optimize these queries?
For reference, I was having SEVERE performance problems with the
following comparison in an SQL statement where "mask" was an integer:
"select ... from where .. and (permission & mask = permission)"
This resulted in the
On Fri, Sep 4, 2009 at 08:54, Scott Otis wrote:
> Robert Haas :
>
>> Do you by any chance have a bazillion databases in this cluster? Can
>> you do these?
>
>> select sum(1) from pg_database;
>
> 1555
Note that there are two features in 8.4 specifically designed to deal
with the situation where y
