Postgres Pro
Downloads
Home   >   mailing lists

RE: Performance (was: The New Slashdot Setup (includes MySql server)) - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject RE: Performance (was: The New Slashdot Setup (includes MySql server))
Date
Msg-id 000701bfc180$357073c0$2801007e@tpf.co.jp
Whole thread Raw
In response to Re: Performance (was: The New Slashdot Setup (includes MySql server))  ("Matthias Urlichs" <smurf@noris.net>)
Responses Re: Performance (was: The New Slashdot Setup (includes MySql server))
List pgsql-hackers
Tree view 
> -----Original Message-----
> From: pgsql-hackers-owner@hub.org [mailto:pgsql-hackers-owner@hub.org]On
> Behalf Of Matthias Urlichs
> 
> Why they do that is another question entirely. (a) these tables should
> have indices, and (b) whatever postgres wants to know should have been
> cached someplace. Oh yes, (c) what's in pg_index that needs to be 4
> MBytes big?
>

What does 'vacuum pg_index' show ?

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp

pgsql-hackers by date:

Previous
From: Karel Zak
Date:
Subject: Re: query cache (was: Re: caching query results)
Next
From: Peter Vazsonyi
Date:
Subject: -devel-7.0-1.rpm: Still missing a lots of headers