Hi,
Am I wrong or AGE() always gets directed to a sequential scan?
# BEGIN;
] SET enable_seqscan TO off;
] EXPLAIN ANALYZE
] SELECT count(1)
] FROM incomingmessageslog
] WHERE AGE(time) < '1 year';
] ROLLBACK;
BEGIN
SET
Hi John,
It has been a while since I played around with PgPool-II. In the tests
that I did, it did help with load balancing. For parallel query, it
helped for simple queries, such as when querying a single table. If that
is your typical use case, you may benefit. For other queries, it was not
as e
On Fri, Jun 6, 2008 at 12:30 AM, Greg Smith <[EMAIL PROTECTED]> wrote:
> vacuum_cost_delay = 750
> autovacuum = true
> autovacuum_naptime = 3600
> autovacuum_vacuum_threshold = 1000
> autovacuum_analyze_threshold = 500
> autovacuum_vacuum_scale_factor = 0.4
> autovacuum_analyze_scale_factor = 0.2
