What is your kernel SHMMAX? Usually somewhere under /etc/sysconfig. Depends on
your distro. This is telling you that your kernel does not have sufficient
resources.
Original message
From: Ryan King - NOAA Affiliate
Date: 07/13/2015 7:10 PM (GMT-06:00)
To: pgsql-gene...@postgre
Apologies ahead of time for not knowing which group to send to, but I
wanted to see if anyone has encountered and resolved this type of error.
I'm setting up postgresql 9.2 streaming replication on RH and after copying
the master data directory over to the slave, the psql service refuses start
and
On Mon, Jul 13, 2015 at 3:54 PM, Ben Hoyt wrote:
> Hi folks,
>
> I have a fairly simple three-table query (pasted below) with two LEFT JOINs
> and an OR in the WHERE clause that for some reason is doing sequential scans
> on all three tables (two of them large -- several million rows), even though
Hi folks,
I have a fairly simple three-table query (pasted below) with two LEFT JOINs
and an OR in the WHERE clause that for some reason is doing sequential
scans on all three tables (two of them large -- several million rows), even
though I have indexes on the relevant "filename" columns.
Note t
