Postgres Pro
Downloads
Home   >   mailing lists

RE: Slow query on a one-tuple table - Mailing list pgsql-performance

From Igor Neyman
Subject RE: Slow query on a one-tuple table
Date
Msg-id BN6PR1701MB1890A207FBF02BBC5E3C9F01DA890@BN6PR1701MB1890.namprd17.prod.outlook.com
Whole thread Raw
In response to Re: Slow query on a one-tuple table  (Luís Roberto Weck <luisroberto@siscobra.com.br>)
Responses Re: Slow query on a one-tuple table  (Luís Roberto Weck <luisroberto@siscobra.com.br>)
List pgsql-performance
Tree view 
With LIMIT 1, I get 3 shared buffers hit, pretty much always.

____________________________________________________________________________________

Check if assessoria_pkey index is bloated.

Regards,
Igor Neyman

pgsql-performance by date:

Previous
From: Luís Roberto Weck
Date:
Subject: Re: Slow query on a one-tuple table
Next
From: Luís Roberto Weck
Date:
Subject: Re: Slow query on a one-tuple table