"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> I'm wondering if there's any way I can tweak things so that the estimate
> for the query is more accurate (I have run analyze):
>-> Index Scan using alert__tick_tsz on alert
> (cost=0.00..2498.49 rows=7119 width=28) (actual time=0.006
opensims=#
I'd really like to avoid putting a 'set enable_seqscan=false' in my
code, especially since this query only has a problem if it's run on a
large date/time window, which normally doesn't happen.
Try increasing your statistics target for the column and then rerunning
analyze.
Sincerely
I'm wondering if there's any way I can tweak things so that the estimate
for the query is more accurate (I have run analyze):
QUERY PLAN
The real issue is this, we have THE SAME queries taking anywhere from
.001 -
90.0 seconds... the server is using 98% of the available RAM at all
times
(because of the persistant connections via php), and I don't know
what to
do.
Another possible line of attack is to use persistent (pooled)
conne
"Shane | SkinnyCorp" <[EMAIL PROTECTED]> writes:
> The real issue is this, we have THE SAME queries taking anywhere from .001 -
> 90.0 seconds... the server is using 98% of the available RAM at all times
> (because of the persistant connections via php), and I don't know what to
> do.
I have a
--- John Meinel <[EMAIL PROTECTED]> wrote:
> If you are trying to establish existence, we also had a whole thread on
> this. Basically what we found was that adding an ORDER BY clause, helped
> tremendously in getting the planner to switch to an Index scan. You
> might try something like:
>
>
Thanks in advance for anything you can do to help.
The real issue is this, we have THE SAME queries taking anywhere from .001 -
90.0 seconds... the server is using 98% of the available RAM at all times
(because of the persistant connections via php), and I don't know what to
do. Every time I ch
Dear Tom,
thanks for your information.
Where can I learn more about the explain and analyze??
One view that is giving a lot of problems is vkardex_3
which is used most of the time...
The explain analyze I sent is one of the views that
conform this one.
Thanks in advance.
Carlos Lopez Linares
---
