| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Sam Mason <sam(at)samason(dot)me(dot)uk> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Speeding up query |
| Date: | 2008-11-05 20:29:41 |
| Message-ID: | 20081105202941.GV4114@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Sam Mason wrote:
> On Wed, Nov 05, 2008 at 09:52:29PM +0200, Andrus wrote:
> > after that I got
> >
> > 1 1214 pg_shdepend 440 MB
> > 2 1232 pg_shdepend_depender_index 285 MB
> > 3 1233 pg_shdepend_reference_index 155 MB
>
> these all still seem quite big, at least in my (somewhat limited)
> experience. If anyone else has experience of what would cause these to
> grow I'd be interested in finding out!
Lots of grants maybe?
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2008-11-05 21:04:44 | Re: Debugging infrequent pegged out CPU usage |
| Previous Message | Sam Mason | 2008-11-05 20:23:04 | Re: Speeding up query |