On Wed, Aug 4, 2010 at 1:16 AM, Heiko L. wrote:
> Hallo,
>
> Im running pg-8,pgpoolII on sol10-zone.
I noticed late you mention 8.3.1. Two points, you're missing > 1 year
of updates, bug fixes, security patches etc. Assuming this version
was fast before, we'll assume it's not the cause of this
On Wed, Aug 4, 2010 at 3:16 AM, Heiko L. wrote:
> $ echo "EXPLAIN ANALYSE $sql2" | $cmd 2>&1
> Aggregate (cost=5236.53..5236.54 rows=1 width=0) (actual
> time=2018.985..2018.9
> 86 rows=1 loops=1)
> -> Seq Scan on blacklist (cost=0.00..4855.06 rows=152588 width=0) (actual
> t
> ime=0.329..
Hallo,
Im running pg-8,pgpoolII on sol10-zone.
After update sol10u7, queries on coltype timestamp are very slow.
System: sparc, 2GB RAM
This DB is a greylist-DB to fight spam.
500 connections should be easy.
But 16 connection consum 10sec/query.
On another system (sparc) only 1 sec.i
s. detai