Howdy.
I have an Ubuntu 14.04 LTS, configured with huge pages (4x1GB, disabled
transparent) and a later kernel than what ships with 14.04.
root@ff2:~# uname -a
Linux ff2 3.16.7-ckt11-061515+ #1 SMP Mon Jun 15 18:47:13 CDT 2015 x86_64
x86_64 x86_64 GNU/Linux
It had postgresql-9.3 on it and I inst
st
10 ?S 0:00 /usr/lib/postgresql/9.5/bin/postgres -D
/var/lib/postgresql/9.5/main -c
config_file=/etc/postgresql/9.5/main/postgresql.conf
Cheers,
Chris
On Mon, Oct 10, 2016 at 5:21 PM, Tom Lane wrote:
> Chris Richards writes:
> > Setting up postgresql-9.5 (9.5.4-1.
:1048576 kB
DirectMap4k: 83776 kB
DirectMap2M: 4110336 kB
DirectMap1G: 6291456 kB
On Mon, Oct 10, 2016 at 5:21 PM, Tom Lane wrote:
> Chris Richards writes:
> > Setting up postgresql-9.5 (9.5.4-1.pgdg14.04+2) ...
> > Creating new cluster 9.5/main ...
> > config /et
]@[unknown] LOG: incomplete
startup packet
On Mon, Oct 10, 2016 at 5:21 PM, Tom Lane wrote:
> Chris Richards writes:
> > Setting up postgresql-9.5 (9.5.4-1.pgdg14.04+2) ...
> > Creating new cluster 9.5/main ...
> > config /etc/postgresql/9.5/main
> > data /
I have another application that consumes all of the huge pages; they aren't
for pgsql. :) I've modified the configuration file from "try" to "off" and
munmap is no more. Mischief managed.
Thanks for your help.
On Tue, Oct 11, 2016 at 6:15 PM, Tom Lane wrote:
&g
Howdy. I was noticing a significant problem with a query on one of my
tables. I tried recreating the problem and wasn't able to do so on a
different install, and so a few days later I ran the same query on the
problem table. Lo' and behold, there wasn't a problem anymore. I'm at a
loss to why. The
Howdy. I have two tables that I'm joining together and using the result to
create a temporary table. Performing the join operation works fine; it
produces 0 rows (as expected). If I prepend "CREATE TEMP tmp_policyqueue
AS" to the SELECT then it generates this error:
ERROR: could not read block 39
and capture data
immediately, and the suggested REINDEX since both appear to be indices.
Thanks for the help. It's appreciated.
Chris
On Fri, Nov 20, 2015 at 8:28 AM, Adrian Klaver
wrote:
> On 11/20/2015 06:18 AM, Albe Laurenz wrote:
>
>> Chris Richards wrote:
>>
>
ere not disabled during the bulk import.
Chris
On Mon, Nov 23, 2015 at 2:59 AM, Albe Laurenz
wrote:
> Chris Richards wrote:
> > Adrian is correct. This worked by itself whereas using it in the
> creation of the temporary table
> > failed.
> > mdb-> SELECT pq.* FROM pol