| From: | Alex Johnson <alex(at)aretesystems(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Slow performance with join on many fields |
| Date: | 2003-03-04 07:46:38 |
| Message-ID: | 6E7231D8-4E15-11D7-85B6-000502FCE08D@aretesystems.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Tom-
Thanks for the speedy reply.
> That's on the picayune side yet. 1000 buffers or so is where you want
> to be, I think. Also, have you run ANALYZE or VACUUM ANALYZE lately?
VACUUM ANALYSE did it.... (doh!...now I feel stupid). I had run VACUUM
and VACUUM ANALYZE from pgAdmin, yesterday. After running it from the
command line now, It's much improved (~ 2-3 secs). I'm now looking
into getting my kernel to increase the SHMAX parameter so I can bump up
the shared buffers some more.
Thanks again for the speedy help, and sorry for the obvious goof.
Alex Johnson
________________________________________________________________________
______
A r e t e S y s t e m s
Alexander Johnson, P.E.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul McKay | 2003-03-04 14:45:18 | Slow query performance on large table |
| Previous Message | Tom Lane | 2003-03-04 06:27:42 | Re: Slow performance with join on many fields |