- Mensagem original -
| André Volpato wrote:
| |
| | If it is being spent in the bitmap index scan, try setting
| | effective_io_concurrency to 0 for Linux, and see what effect that
| | has.
|
| I disabled effective_io_concurrency at AIX but it made no changes on
| bitmap index
On 10-10-26 05:04 PM, André Volpato wrote:
- Mensagem original -
| On 10-10-25 03:26 PM, André Volpato wrote:
| | On Mon, Oct 25, 2010 at 2:21 PM, André Volpato
| |andre.volp...@ecomtecnologia.com.br wrote:
(...)
| | These times keep repeating after the second run, and I can
| |
André Volpato wrote:
|
| If it is being spent in the bitmap index scan, try setting
| effective_io_concurrency to 0 for Linux, and see what effect that has.
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
Greg Smith g...@2ndquadrant.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
- Mensagem original -
| André Volpato wrote:
| |
| | If it is being spent in the bitmap index scan, try setting
| | effective_io_concurrency to 0 for Linux, and see what effect that
| | has.
|
| I disabled effective_io_concurrency at AIX but it made no changes on
| bitmap index
On 10/27/2010 4:10 PM, Tom Lane wrote:
Greg Smithg...@2ndquadrant.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
Brad Nicholson bnich...@ca.afilias.info writes:
On 10/27/2010 4:10 PM, Tom Lane wrote:
AFAICT from googling, AIX does have posix_fadvise, though maybe it
doesn't do anything useful ...
If there is an easy way to check if it does do anything useful? If so,
I can check it out.
If you don't
On 10-10-25 03:26 PM, André Volpato wrote:
| On Mon, Oct 25, 2010 at 2:21 PM, André Volpato
|andre.volp...@ecomtecnologia.com.br wrote:
| Hi all,
|
| We are tuning a PostgreSQL box with AIX 5.3 and got stucked in a
| very odd situation.
| When a query got ran for the second time, the system
- Mensagem original -
| On 10-10-25 03:26 PM, André Volpato wrote:
| | On Mon, Oct 25, 2010 at 2:21 PM, André Volpato
| |andre.volp...@ecomtecnologia.com.br wrote:
(...)
| | These times keep repeating after the second run, and I can
| | ensure AIX isn´t touching the disks anymore.
| On Mon, Oct 25, 2010 at 2:21 PM, André Volpato
| andre.volp...@ecomtecnologia.com.br wrote:
| Hi all,
|
| We are tuning a PostgreSQL box with AIX 5.3 and got stucked in a
| very odd situation.
| When a query got ran for the second time, the system seems to
| deliver the results to slow.
|
10 matches
Mail list logo