| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | mallah(at)trade-india(dot)com |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Is dump-reload the only cure? |
| Date: | 2002-11-01 14:38:51 |
| Message-ID: | 1036161531.5794.18.camel@jester |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
> Does it Mean that clustered indexes are guarrented to be used for index scan?
> one more thing does clustering means that all future data addition will happen
> in the ordered manner only i mean consecutively in terms of source_id?
No, but clustering a table allows an index scan to visit less pages, and
make less disk seeks. This in turn makes it a better choice for some
queries due to the current layout of tuples on the disk. However, there
are new borderline cases -- just in different places than before.
--
Rod Taylor
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mallah | 2002-11-01 14:41:22 | Re: [pgsql-performance] Is dump-reload the only cure? |
| Previous Message | Greg Spiegelberg | 2002-11-01 14:33:47 | Linux system panic |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mallah | 2002-11-01 14:41:22 | Re: [pgsql-performance] Is dump-reload the only cure? |
| Previous Message | Rod Taylor | 2002-11-01 14:11:03 | Re: [pgsql-performance] Is dump-reload the only cure? |