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 <mariel.cherkas...@gmail.com>
> wrote:
>
> I'm trying to understand what postgresql doing in an issue that I'm
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
John,
And can you please include BUFFERS to ANALYZE?
Regards,
Roman Konoval
On Tue, May 28, 2013 at 9:48 AM, Evgeniy Shishkin itparan...@gmail.comwrote:
On 28.05.2013, at 2:17, John Mudd johnbm...@gmail.com 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 misa.si...@gmail.com 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 is not necessary. Between