Hi:
I am using the wonderful lateral query feature like the following
select * from generate_series (1,10,5) T(t),
lateral (select * from P where t between t and t + 3)
P is a parent table of a hundred partitions
the idea is to for each t value from 1 to 10 with step of 5,
get row
Got it. Thanks very much
On Sun, Sep 6, 2015 at 11:25 PM, Michael Paquier
wrote:
> On Mon, Sep 7, 2015 at 12:12 PM, Tom Smith
> wrote:
> > Hi,
> >
> > Can setting be appended to the end of the postgresql.conf
> > so that it will override whatever is already in the previous version.
> > For exam
On Mon, Sep 7, 2015 at 12:12 PM, Tom Smith wrote:
> Hi,
>
> Can setting be appended to the end of the postgresql.conf
> so that it will override whatever is already in the previous version.
> For example
>
> the existing postgresql.conf already has setting
>
> max_connections = 100
>
> in the midd
Hi,
Can setting be appended to the end of the postgresql.conf
so that it will override whatever is already in the previous version.
For example
the existing postgresql.conf already has setting
max_connections = 100
in the middle of file.
Now I append a line as the end of the file, regardless w
On 7 September 2015 at 00:18, Giovanni Maruzzelli wrote:
> Hello,
>
> Typical HA situation.
>
> I have master-master, two only machines, one active and one passive
> (standby) with floating IP.
> I write to only one machine at time, the one with the floating IP.
This is a deployment that is bette
On 4 September 2015 at 21:46, Ray Stell wrote:
FATAL: role "postgresql" does not exist
>>>
>>> It works if I init with "-U postgresql"
>
> The demo works fine if
> I use the string "postgresql" as the admin role. It looks like you might
> want to build -U support into bdr at some point.
It
No worries.
I found a way.
Best Regards
Farjad
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
For data insertion purposes I need to identify "the lowest ranking tables"
(e.g. with least dependencies) to fill and work my way up.
I have looked a number of blogs but unfortunately these didn't work.
Is there a function or view to report dependencies of tables ? I have
Postgresql 9.4
Hello,
Typical HA situation.
I have master-master, two only machines, one active and one passive
(standby) with floating IP.
I write to only one machine at time, the one with the floating IP.
I have one column that is a serial from a global sequence in BDR.
When one machine is down I can no mor
> On Sep 6, 2015, at 4:07 AM, Andres Freund wrote:
>
> To me that sounds like the negative impact of transparent hugepages
> being mitigated to some degree by zone reclaim mode (which'll avoid some
> cross-node transfers).
FWIW:
$ cat /sys/kernel/mm/transparent_hugepage/enabled
always madvise
Andres Freund writes:
> On 2015-09-04 15:37:47 -0700, Ben Chobot wrote:
>> Our situation might not apply to you. But if it does, give zone_reclaim_mode
>> a chance. It's not (always) as bad as others have made it out to be.
> To me that sounds like the negative impact of transparent hugepages
>
Hi,
On 2015-09-04 15:37:47 -0700, Ben Chobot wrote:
> So our load would hover under 10 most of the time, then spike to over 100 for
> a minute or two. Connections would get refused, the system would freeze up...
> and then everything would go back to normal. The solution? Turning on
> zone_recl
12 matches
Mail list logo
