Hello
I have pg_autovacuum running with the arguments:
pg_autovacuum -D -s 120 -v 1
the database is postgresql 8.0.0
Sometimes load average on server raises to 20 and it is almost impossible to
login via SSH
When I'm logging in finally, I see there is cpu usage: 6% and iowait 95%
ps ax |
On Tue, Aug 01, 2006 at 11:15:11PM -0400, Tom Lane wrote:
> Eugeny N Dzhurinsky <[EMAIL PROTECTED]> writes:
> > [slow query]
> The bulk of your time seems to be going into this indexscan:
> > -> Index Scan using
> > task_schedul
Hello, I have a query:
explain analyze select tu.url_id, tu.url, coalesce(sd.recurse, 100), case when
COALESCE(get_option('use_banner')::integer,0) = 0 then 0 else ts.use_banner
end as use_banner, ts.use_cookies, ts.use_robots, ts.includes, ts.excludes,
ts.track_domain, ts.task_id,get_available_p
On Thu, Jul 06, 2006 at 09:28:39AM -0500, Scott Marlowe wrote:
> On Thu, 2006-07-06 at 01:40, Eugeny N Dzhurinsky wrote:
> Do you add / remove tables a lot? Could be you've got system catalog
> bloat.
Yes, almost each table is dropped and re-created in 3-5 days.
> do you have a
Hello!
I have a postgresql server serving thousands of tables. Sometime there are
queries which involves several tables.
In postgresql.conf I have these settings:
shared_buffers = 4
work_mem = 8192
maintenance_work_mem = 16384
max_stack_depth = 2048
all other settings are left by default (e
On Wed, Jul 05, 2006 at 09:39:31AM -0400, Tom Lane wrote:
> Eugeny N Dzhurinsky <[EMAIL PROTECTED]> writes:
> > but it seems pg_autovacuum does not do vacuuming on system tables.
>
> There was a bug awhile back whereby autovac failed to notice temp table
> cleanup at conn
Hello!
I facing some strange problems with PostgreSQL 8.0 performance.
I have application which handles a lot of tasks, each task is keps in separate
table. Those tables are dropped and created again periodically (precisely -
when new task results came back from remote server). Also each table can