| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Roman Fail <rfail(at)posportal(dot)com> |
| Cc: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: 7.3.1 New install, large queries are slow |
| Date: | 2003-01-15 19:44:01 |
| Message-ID: | 20030115113159.F91182-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, 15 Jan 2003, Roman Fail wrote:
> The disks are not reading at max speed during the query - when I ran a
> VACUUM ANALYZE (after data migration), sar -b was consistently 100,000
> block reads/sec. It does not seem like the hardware is holding back
> things here. I read something about 'fsync' recently, would changing
> that setting apply in this case?
You ran vacuum analyze, but some of the explain still looks suspiciously
like it's using default statistics (dr and cr for example, unless they
really do have 1000 rows).
What are the actual query and table definitions for the query?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod Taylor | 2003-01-15 19:53:11 | Re: 7.3.1 New install, large queries are slow |
| Previous Message | Tomasz Myrta | 2003-01-15 19:31:34 | Re: 7.3.1 New install, large queries are slow |