On Sun, 18 Feb 2018, Tim Cross wrote:
This may not be relevant,
Tim,
Nope. Pat goes for stability, not cutting edge. No systemd in the
forthcoming 15.0, either.
Thanks,
Rich
I certainly wouldn't recommend using 1/2 of RAM right away. There's a
good chance it would be a waste of memory - for example due to double
buffering, which effectively reduces "total" cache hit ratio.
Double buffering is often mentioned in context of tuning shared buffers.
Is there a tool to
On Sun, 18 Feb 2018, Tim Cross wrote:
# ll /usr/bin/postgres
lrwxrwxrwx 1 root root 35 Feb 17 09:30 /usr/bin/postgres ->
../lib/postgresql/10.2/bin/postgres*
Try doing an 'll' on the second part of that output i.e.
ll /usr//lib/postgresql/10.2/bin/postgres*
See my message, repeated above
2018-02-18 14:41 GMT+01:00 Vitaliy Garnashevich :
>
> I certainly wouldn't recommend using 1/2 of RAM right away. There's a
>> good chance it would be a waste of memory - for example due to double
>> buffering, which effectively reduces "total" cache hit ratio.
>>
>
> Double buffering is often men
On 02/18/2018 02:41 PM, Vitaliy Garnashevich wrote:
>
>> I certainly wouldn't recommend using 1/2 of RAM right away. There's
>> a good chance it would be a waste of memory - for example due to
>> double buffering, which effectively reduces "total" cache hit
>> ratio.
>
> Double buffering is ofte
On 02/18/2018 06:37 AM, David Rowley wrote:
> On 18 February 2018 at 12:35, hmidi slim wrote:
>> Is there an other optimized solution to make a query such this:
>> select * from (
>> select e.name, e1.name, e.id
>> from establishment as e, establishment as e1
>> where e.id <> e1.id
>> and e1.id =
On Sat, 17 Feb 2018, Rich Shepard wrote:
That's what I was thinking, too. I can remove the 10.2 package, rebuild
and re-install it. Run initdb, then, as postgres, read in the .sql file.
This is probably the pragmatic thing to do.
Rather than doing this my reading of the 10.2 initdb pages sug
On 02/18/2018 08:05 AM, Rich Shepard wrote:
On Sat, 17 Feb 2018, Rich Shepard wrote:
That's what I was thinking, too. I can remove the 10.2 package, rebuild
and re-install it. Run initdb, then, as postgres, read in the .sql file.
This is probably the pragmatic thing to do.
Rather than doin
On Sun, Feb 18, 2018 at 7:41 AM, Vitaliy Garnashevich <
vgarnashev...@gmail.com> wrote:
>
> In the case when shared_buffers cover most of RAM, most of writes should
> happen by checkpointer, and cache hit ratio should be high. So a
> hypothetical question: Could shared_buffers=200GB on a 250 GB RA
On Sun, 18 Feb 2018, Adrian Klaver wrote:
Is this appropriate?
Yes.
Adrian,
Thanks for confirming
They could not have been removed as they are in the file. I am guessing
you are saying they are not in use as far as you know. Just a warning(from
experience), memory is a tricky thing and
On Sun, 18 Feb 2018, Rich Shepard wrote:
Thanks for confirming
Removed all files in the data/ directory, re-initialized the cluster, and
restored the dumped .sql file (minus three databases and their roles
manually deleted). All works well now.
Thanks, Adrian!
Best regards,
Rich
On Wed, Jan 17, 2018 at 9:34 PM, Jacek Kołodziej
wrote:
> Hi Tom,
>
> On Wed, Jan 17, 2018 at 7:56 PM, Tom Lane wrote:
>
>> =?UTF-8?Q?Jacek_Ko=C5=82odziej?= writes:
>> > Here's what happening to me: the "A" query occasionally (in my case: on
>> the
>> > order of tenths per day) returns an ID _h
Rich Shepard writes:
> On Sun, 18 Feb 2018, Tim Cross wrote:
>
>> This may not be relevant,
>
> Tim,
>
>Nope. Pat goes for stability, not cutting edge. No systemd in the
> forthcoming 15.0, either.
>
> Thanks,
>
> Rich
No worries, though I'm not sure you can call systemd 'cutting edge'
anym
Rich Shepard writes:
> On Sun, 18 Feb 2018, Tim Cross wrote:
>
>>> # ll /usr/bin/postgres
>>> lrwxrwxrwx 1 root root 35 Feb 17 09:30 /usr/bin/postgres ->
>>> ../lib/postgresql/10.2/bin/postgres*
>
>> Try doing an 'll' on the second part of that output i.e.
>> ll /usr//lib/postgresql/10.2/bin/po
On Mon, 19 Feb 2018, Tim Cross wrote:
It is possible for the target of a symbolic link to be changed, deleted
etc (a dangling sym link).
Tim,
Broken symlinks display in a different color, black on a red background if
I remember correctly, rather than the light cyan of a working symlink. I'v
Rich Shepard writes:
> On Mon, 19 Feb 2018, Tim Cross wrote:
>
>> It is possible for the target of a symbolic link to be changed, deleted
>> etc (a dangling sym link).
>
> Tim,
>
>Broken symlinks display in a different color, black on a red background if
> I remember correctly, rather than t
Evening all.
Looking to use pgBackRest to take a backup from a hot standby. I'm reading
that pgBackRest still needs to connect to the primary and copy some files.
My questions are:
1. What files does it need to copy? Config files? WAL files?
2. How does it connect? SSH?
3. Does pgBackRe
On Sun, Feb 18, 2018 at 06:34:46PM -0600, Don Seiler wrote:
> Looking to use pgBackRest to take a backup from a hot standby. I'm reading
> that pgBackRest still needs to connect to the primary and copy some files.
> My questions are:
>
>
>1. What files does it need to copy? Config files? WAL
On Sun, Feb 18, 2018 at 6:43 PM, Michael Paquier
wrote:
>
> I am adding in CC: Stephen Frost and David Steele who work on the took.
>
I assumed Stephen was already on this list, and I communicate with him
regularly on Slack as well but just throwing this out there on a Sunday
night.
> You may w
On Sun, Feb 18, 2018 at 06:48:30PM -0600, Don Seiler wrote:
> On Sun, Feb 18, 2018 at 6:43 PM, Michael Paquier wrote:
>> You may want to contact the maintainers directly through github where
>> the project is maintained:
>> https://github.com/pgbackrest/pgbackrest
>
> Is that the place to just as
Hi,
We’re seeing deadlock semi-regularly (0-2 per day) that I’m really having
trouble getting to the bottom of.
Process 7172 waits for ShareLock on transaction 4078724272; blocked by process
7186.
Process 7186 waits for ShareLock on transaction 4078724210; blocked by process
7172.
The two qu
Hi everybody,
I published a tool that makes it easy to migrate a database from other
DBMSs to Postgres:
https://github.com/isapir/Migrate2Postgres
Currently it supports migrations from MS SQL Server, but it is written in a
way that will make it easy to migrate from other DBMSs as well.
I also pu
Hi. Does any of the two tables have triggers? What's the database /
transaction isolation level? Do the updates run in a transaction among
other read / write operations within the same transaction ?
Regards.
2018-02-18 23:28 GMT-06:00 David Wheeler :
> Hi,
>
> We’re seeing deadlock semi-regularly
23 matches
Mail list logo
