| From: | "Luke Lonergan" <llonergan(at)greenplum(dot)com> |
|---|---|
| To: | "Dave Cramer" <pg(at)fastcrypt(dot)com> |
| Cc: | "Greg Stark" <gsstark(at)mit(dot)edu>, "Joshua Marsh" <icub3d(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Hardware/OS recommendations for large databases ( |
| Date: | 2005-11-18 15:30:31 |
| Message-ID: | BFA33397.1403A%llonergan@greenplum.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Dave,
On 11/18/05 7:25 AM, "Dave Cramer" <pg(at)fastcrypt(dot)com> wrote:
> Luke,
>
> Interesting numbers. I'm a little concerned about the use of blockdev setra
> 16384. If I understand this correctly it assumes that the table is contiguous
> on the disk does it not ?
For optimum performance, yes it does. Remember that the poster is asking
about a 5TB warehouse. Decision support applications deal with large tables
and sequential scans a lot, and the data is generally contiguous on disk.
If delete gaps are there, they will generally vacuum them away.
- Luke
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill McGonigle | 2005-11-18 15:55:19 | Re: Hardware/OS recommendations for large databases ( |
| Previous Message | Luke Lonergan | 2005-11-18 15:27:42 | Re: Hardware/OS recommendations for large databases ( |