Re: Configuration Recommendations

On Tue, May 15, 2012 at 11:53 AM, Greg Sabino Mullane <greg(at)turnstep(dot)com>wrote:

> >>> Is it established practice in the Postgres world to separate indexes
> >>> from tables? I would assume that the reasoning of Richard Foote -
> >>> albeit for Oracle databases - is also true for Postgres:
> >
> >> Yes, it's an established practice. I'd call it something just short of
> >> a best practice though, as it really depends on your situation.
> >
> > What are the benefits?
>
> Disk seeks, basically. Yes, there are a lot of complications regarding
> all the various hardware/OS/PG level cachings, but at the end of the
> day, it's less work to have each drive concentrate on a single area
> (especially as we always require a heap scan at the moment).
>

Thanks for sharing your experience, Greg. What would a PG test-case for
this look like?

Cheers,

Jan