Hi pgsql-performance!
So I have a Postgresql database -- version "PostgreSQL 9.4.8 on
x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 64-bit",
specifically.
In it, I have essentially two categories of tables:
- small tables that are updated frequently, and tend to be often queri
On Tue, Mar 21, 2017 at 4:24 PM, James Parks wrote:
> ... and here's how long it takes to read all of the rows:
> database=> select max(an unindexed bigint column) from a;
> -[ RECORD 1 ]
> max |
> Time: 10624.368 ms
>
> Running this another time immediately afterward (to show the cached
On Tue, Mar 21, 2017 at 10:56 PM, Claudio Freire wrote:
> On Tue, Mar 21, 2017 at 4:24 PM, James Parks wrote:
>> ... and here's how long it takes to read all of the rows:
>> database=> select max(an unindexed bigint column) from a;
>> -[ RECORD 1 ]
>> max |
>> Time: 10624.368 ms
>>
>> Ru
