I suspect that my manualy vacuum every 10 days or so really wasn't nearly enough ;)AlexOn 6/9/06, Jim C. Nasby <
[EMAIL PROTECTED]> wrote:This tells me that you need to be vacuuming more. Autovac is your
friend.On Thu, Jun 08, 2006 at 07:14:01PM -0400, Alex Turner wrote:> Yeah - I just did a reinde
This tells me that you need to be vacuuming more. Autovac is your
friend.
On Thu, Jun 08, 2006 at 07:14:01PM -0400, Alex Turner wrote:
> Yeah - I just did a reindex, that fixed the indexes at least.
>
> Alex
>
> On 6/8/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> >
> >On Thu, Jun 08, 2006 at 06
Yeah - I just did a reindex, that fixed the indexes at least.AlexOn 6/8/06, Jim C. Nasby <[EMAIL PROTECTED]
> wrote:On Thu, Jun 08, 2006 at 06:03:23PM -0400, Alex Turner wrote:> I hope I'm reading this query wrong:
>> trend=# select relname, relpages*8192/reltuples from pg_class where> reltuples>0
On Thu, Jun 08, 2006 at 06:03:23PM -0400, Alex Turner wrote:
> I hope I'm reading this query wrong:
>
> trend=# select relname, relpages*8192/reltuples from pg_class where
> reltuples>0 order by relpages desc limit 10;
>relname| ?column?
> --
I hope I'm reading this query wrong:trend=# select relname, relpages*8192/reltuples from pg_class where reltuples>0 order by relpages desc limit 10; relname | ?column?---+--
property | 19935.4468376195 resul
