| From: | Tobias Brox <tobias(at)nordicbet(dot)com> |
|---|---|
| To: | Junaili Lie <junaili(at)gmail(dot)com> |
| Cc: | Bruno Wolff III <bruno(at)wolff(dot)to>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Help with rewriting query |
| Date: | 2005-06-10 08:49:25 |
| Message-ID: | 20050610084925.GA8451@tobias.nordicbet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
[Junaili Lie - Thu at 06:26:09PM -0700]
> Hi Bruno,
> I followed your suggestion.
> The query plan shows that it uses the index (id, person_id). However,
> the execution time is still slow. I have to do ctl-C to stop it.
What is the estimate planner cost?
> Maybe something is wrong with my postgresql config.
> It's running Solaris on dual Opteron, 4GB.
> I allocated around 128MB for sorting and more than 80% for
> effective_cache_size and shared_buffers = 32768.
> Any further ideas is much appreciated.
Sounds a bit excessive. Compare with the vanilla configuration, and see
what is faster.
--
Tobias Brox, +47-91700050
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michal Taborsky | 2005-06-10 09:05:45 | Cleaning bloated pg_attribute |
| Previous Message | Richard Huxton | 2005-06-10 07:17:37 | Re: postgresql.conf runtime statistics default |