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
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
]@[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 /
: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
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.
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
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
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:
>>
>
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