| From: | Vitalii Tymchyshyn <tivv00(at)gmail(dot)com> |
|---|---|
| To: | Greg Smith <greg(at)2ndQuadrant(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: [PERFORMANCE] expanding to SAN: which portion best to move |
| Date: | 2011-05-25 08:51:57 |
| Message-ID: | 4DDCC32D.2000901@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
24.05.11 21:48, Greg Smith написав(ла):
>
> Bitmap heap scan: Here, the exact list of blocks to fetch is known in
> advance, they're random, and it's quite possible for the kernel to
> schedule them more efficiently than serial access of them can do. This
> was added as the effective_io_concurrency feature (it's the only thing
> that feature impacts), which so far is only proven to work on Linux.
> Any OS implementing the POSIX API used will also get this however;
> FreeBSD was the next likely candidate that might benefit when I last
> looked around.
FreeBSD unfortunately do not have the support :(
It has AIO, but does not have the call needed to enable this settings.
Best regards, Vitalii Tymchyshyn
| From | Date | Subject | |
|---|---|---|---|
| Next Message | MarkB | 2011-05-25 09:47:06 | How to store and load images in PostgreSQL db? |
| Previous Message | Greg Smith | 2011-05-25 02:25:04 | Re: Postgresql CBT |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2011-05-25 14:00:49 | Re: serveRAID M5014 SAS |
| Previous Message | Grzegorz Jaśkiewicz | 2011-05-25 07:33:52 | serveRAID M5014 SAS |