Can you show explain with analyze and buffers options for your query?
Regards,
Roman Konoval
rkono...@gmail.com
> On Aug 24, 2017, at 15:15, Mariel Cherkassky
> wrote:
>
> I'm trying to understand what postgresql doing in an issue that I'm having.
> Our app team w
Huan,
Residential memory is part of the process memory that is now swapped and is
in RAM. This includes also memory shared with other processes so sum of RES
for all processes may be greater that total physical memory.
I recommend this article
http://www.depesz.com/2012/06/09/how-much-ram-is-post
John,
And can you please include BUFFERS to ANALYZE?
Regards,
Roman Konoval
On Tue, May 28, 2013 at 9:48 AM, Evgeniy Shishkin wrote:
>
>
>
>
> On 28.05.2013, at 2:17, John Mudd wrote:
>
> Thanks again.
>
> Well, I have two problems with using the CLUSTER option.
)
Regards,
Roman Konoval
On Sun, Mar 24, 2013 at 12:27 AM, Misa Simic wrote:
> Hi Jeff,
>
> It seems my previous mail has not showed up in the list... copied/pasted
> again belloew
>
> However, you said something important:
>
> "The join to the "state" table
