| From: | Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Greg Smith <greg(at)2ndquadrant(dot)com>, André Volpato <andre(dot)volpato(at)ecomtecnologia(dot)com(dot)br>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: AIX slow buffer reads |
| Date: | 2010-10-27 22:37:23 |
| Message-ID: | 4CC8A9A3.7060901@ca.afilias.info |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 10/27/2010 4:10 PM, Tom Lane wrote:
> Greg Smith<greg(at)2ndquadrant(dot)com> writes:
>> André Volpato wrote:
>>> I disabled effective_io_concurrency at AIX but it made no changes on bitmap index times.
>> Brad's point is that it probably doesn't do anything at all on AIX, and
>> is already disabled accordingly.
> AFAICT from googling, AIX does have posix_fadvise, though maybe it
> doesn't do anything useful ...
>
> regards, tom lane
If there is an easy way to check if it does do anything useful? If so,
I can check it out.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-10-27 22:44:59 | Re: AIX slow buffer reads |
| Previous Message | Tom Lane | 2010-10-27 22:36:35 | Re: temporary tables, indexes, and query plans |