RE: Slow query on a one-tuple table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: RE: Slow query on a one-tuple table
From: Igor Neyman <ineyman@xxxxxxxxxxxxxx>
Date: Thu, 19 Sep 2019 20:11:11 +0000
Accept-language: en-US
Cc: "pgsql-performance@xxxxxxxxxxxxxxxxxxxx" <pgsql-performance@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <bf03aedc-9201-f7c9-ef25-e795d4e1626a@siscobra.com.br>
References: <CA+t6e1kacbVHq69aihEVeBzH_nMY5eK7bZ-UXL_FuUquEgF_gg@mail.gmail.com> <24571.1568910502@sss.pgh.pa.us> <774d6080-d6d7-e9e7-7351-9a412c7d5956@siscobra.com.br> <CAHOFxGqMpUxn54jMLoU4-HcUata2yfLgjEbRHdJG3k0BBDPbog@mail.gmail.com> <ab6ea98e-6266-7665-40b7-151c5736c08d@siscobra.com.br> <BN6PR1701MB1890E31E15D486A85FEC8510DA890@BN6PR1701MB1890.namprd17.prod.outlook.com> <bf03aedc-9201-f7c9-ef25-e795d4e1626a@siscobra.com.br>

With LIMIT 1, I get 3 shared buffers hit, pretty much always.

____________________________________________________________________________________

Check if assessoria_pkey index is bloated.

Regards,
Igor Neyman

Follow-Ups:
- Re: Slow query on a one-tuple table
  - From: Luís Roberto Weck

References:
- comparing output of internal pg tables of referenced tables
  - From: Mariel Cherkassky
- Re: comparing output of internal pg tables of referenced tables
  - From: Tom Lane
- Slow query on a one-tuple table
  - From: Luís Roberto Weck
- Re: Slow query on a one-tuple table
  - From: Michael Lewis
- Re: Slow query on a one-tuple table
  - From: Luís Roberto Weck
- RE: Slow query on a one-tuple table
  - From: Igor Neyman
- Re: Slow query on a one-tuple table
  - From: Luís Roberto Weck

Prev by Date: Re: Slow query on a one-tuple table
Next by Date: Re: Slow query on a one-tuple table
Previous by thread: Re: Slow query on a one-tuple table
Next by thread: Re: Slow query on a one-tuple table
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]