Re: query plan question

From: "David Parker" <dparker(at)tazznetworks(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Jeff" <threshar(at)torgo(dot)978(dot)org>, "Russell Smith" <mr-russ(at)pws(dot)com(dot)au>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: query plan question
Date: 2004-11-17 15:59:44
Message-ID: 07FDEE0ED7455A48AC42AC2070EDFF7C26B9D5@corpsrv2.tazznetworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

We're using postgresql 7.4.5. I've only recently put pg_autovacuum in
place as part of our installation, and I'm basically taking the
defaults. I doubt it's a problem with autovacuum itself, but rather with
my configuration of it. I have some reading to do, so any pointers to
existing autovacuum threads would be greatly appreciated!

Thanks.

- DAP

>-----Original Message-----
>From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
>Sent: Wednesday, November 17, 2004 10:46 AM
>To: David Parker
>Cc: Jeff; Russell Smith; pgsql-performance(at)postgresql(dot)org
>Subject: Re: [PERFORM] query plan question
>
>"David Parker" <dparker(at)tazznetworks(dot)com> writes:
>> So I guess I need to figure out why pg_autovacuum isn't analyzing
>> those tables.
>
>Which autovacuum version are you using? The early releases
>had some nasty bugs that would allow it to skip tables
>sometimes. I think all the known problems are fixed as of
>recent 7.4.x updates.
>
> regards, tom lane
>

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mike Rylander 2004-11-17 16:18:02 Re: memcached and PostgreSQL
Previous Message Tom Lane 2004-11-17 15:46:26 Re: query plan question