| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | "Ken Egervari" <ken(at)upfactor(dot)com> |
| Cc: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Help with tuning this query (with explain analyze finally) |
| Date: | 2005-03-03 17:35:14 |
| Message-ID: | 200503030935.14537.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers-win32 pgsql-performance |
Ken,
Well, I'm a bit stumped on troubleshooting the actual query since Windows'
poor time resolution makes it impossible to trust the actual execution times.
Obviously this is something we need to look into for the Win32 port for
8.1 ..
> shared_buffers = 1000
This may be slowing up that merge join. Try resetting it to 6000. I'm not
sure what system settings you might have to do on Windows to get it to
support higher shared buffers; see the docs.
> #work_mem = 1024
Up this to 4096 for testing purposes; your production value will vary
depending on several factors; see link below.
> #effective_cache_size = 1000
Increase this to the actual amount of RAM you have available, about 750MB (you
do the math)
> #random_page_cost = 4
Leave this for now.
See www.powerpostgresql.com/PerfList for more information.
--
Josh Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2005-03-03 19:47:59 | unexpected and reproducable crash in pl/pgsql function |
| Previous Message | Ken Egervari | 2005-03-03 09:21:33 | Re: Help with tuning this query (with explain analyze finally) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2005-03-03 17:44:37 | Re: name search query speed |
| Previous Message | Jeremiah Jahn | 2005-03-03 17:23:37 | Re: name search query speed |