Hi Scott,
Yes, we are logging connections and disconnections with duration as well.
We have process of rolling out at every 500MB and old log files are deleted
before a certain period of time.
Thanks a lot for your help !
Regards,
Venkat
On Fri, Sep 2, 2011 at 12:12 PM, Scott Marlowe
Order by ...upper(xyz), do you have functional index on these ?
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Jayadevan M wrote:
Here is the explain analyze
http://explain.depesz.com/s/MY1
PostgreSQL 9.0.4 on x86_64-pc-solaris2.10
work_mem = 96MB
Thanks for posting the query and related schema. I tried working
through it, but I keep coming back to this sort, and wondering how a
sort can have
Kevin Grittner kevin.gritt...@wicourts.gov writes:
Thanks for posting the query and related schema. I tried working
through it, but I keep coming back to this sort, and wondering how a
sort can have 1121 rows as input and 2673340321 rows as output. Does
anyone have any ideas on what could
I don't think I understood all that. Anyway, is there a way to fix this -
either by rewriting the query or by creating an index? The output does match
what I am expecting. It does take more than 10 times the time taken by
Oracle for the same result, with PostgreSQL taking more than 20 minutes. I
On 4 Září 2011, 20:06, Jayadevan wrote:
I don't think I understood all that. Anyway, is there a way to fix this -
either by rewriting the query or by creating an index? The output does
match
what I am expecting. It does take more than 10 times the time taken by
Oracle for the same result,
Mark Kirkwood mark.kirkw...@catalyst.net.nz writes:
While this is still fresh in your mind, a couple of additional anti join
queries are still managing to sneak past estimation:
Yeah, those are estimating that all the outer rows have join partners,
because there are more distinct values in the
Hello,
If that does not help, you'll have to change the query probably. The
problem is the explain analyze you've provided
(http://explain.depesz.com/s/MY1) does not match the query from your
yesterday's post so we can't really help with it.
Thanks for the pointers. I think I posted the same