[Pgpool-general] performance sol10 zone

Josh Berkus josh at agliodbs.com
Tue Aug 3 20:40:18 UTC 2010


Heiko,

First, what does this have to do with pgPool?

>          Filter: (create_time < ((((timenow())::integer - 3000))::abstime)::time
> stamp with time zone)
>  Total runtime: 2019.371 ms

Looks like you don't have a usable index on create_time.


-- 
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com


More information about the Pgpool-general mailing list