Hi Michael,
> To answer to your question based on the code, you can check for the
> code paths calling CheckForStandbyTrigger() in xlog.c when it comes to
> promotion detection in the WAL replay. In short,
> WaitForWALToBecomeAvailable() tells that after the promotion is
> detected in the startu
Hi Ishii-san,
On Fri, Jan 29, 2021 at 07:59:26AM +0100, Paul Förster wrote:
> On 29. Jan, 2021, at 03:51, Tatsuo Ishii wrote:
>>
>> Does anybody know whether a standby server waits for pending WAL
>> records/files while promotion is requested? I assume that no data
>> update is performed on the
Hi Tatsuo,
> On 29. Jan, 2021, at 03:51, Tatsuo Ishii wrote:
>
> Does anybody know whether a standby server waits for pending WAL
> records/files while promotion is requested? I assume that no data
> update is performed on the primary server while promotion.
>
> I imagine that a standby server
Does anybody know whether a standby server waits for pending WAL
records/files while promotion is requested? I assume that no data
update is performed on the primary server while promotion.
I imagine that a standby server stops to replay WAL and promotes as
soon as SIGUSR1 signal is received.
The
Assuming that the system is online and in use, you may want to consider
doing analyze first to ensure stats are proper, and then vacuum all
less-used tables that should be quick then larger/more active tables with
the verbose option to see details of why it might be taking time. If you
are seeing m
> -Ursprüngliche Nachricht-
> Von: Laurenz Albe
> Gesendet: Donnerstag, 28. Januar 2021 17:39
> An: Zwettler Markus (OIZ) ; pgsql-
> gene...@postgresql.org
> Betreff: Re: running vacuumlo periodically?
>
> On Thu, 2021-01-28 at 13:18 +, Zwettler Markus (OIZ) wrote:
> > Short question.
On Thu, Jan 28, 2021 at 06:44:37PM +0200, Yambu wrote:
> Hello
>
> May I know where I can get freelancer jobs for postgres?
Well, we have a jobs email list:
https://wiki.postgresql.org/wiki/Job_postings
and instructions on how to post job _openings_. I think it can also be
used for peo
Hello
May I know where I can get freelancer jobs for postgres?
regards
On Thu, 2021-01-28 at 13:18 +, Zwettler Markus (OIZ) wrote:
> Short question. Is it recommended - or even best practice – to run vacuumlo
> periodically as a routine maintenance task?
>
> We don't do it. I think if this would be recommended it would have been
> implemented as an autotask li
On 2021-Jan-28, Ravi Krishna wrote:
> > Everyone is free to use whatever he/she wants. For me a we based MUA
> > would be the worst thing ever.
>
> Oh well. I have created a seperate email account for this to keep the
> clutter out.
In any half-decent email program, you can tag incoming email
> Everyone is free to use whatever he/she wants. For me a we based MUA
> would be the worst thing ever.
Oh well. I have created a seperate email account for this to keep the clutter
out.
thanks all who took time to reply to this.
On Thu, Jan 28, 2021 at 4:27 PM Alvaro Herrera wrote:
>
> On 2021-Jan-28, Ravi Krishna wrote:
>
> > I am planning to switch to a web based tool to read this mailing list.
>
> That's great.
>
> > While reading is easy via web, how do I post a reply from web.
>
> Yeah, "how" indeed.
>
> > I recollec
El día jueves, enero 28, 2021 a las 12:27:21p. m. -0300, Alvaro Herrera
escribió:
> On 2021-Jan-28, Ravi Krishna wrote:
>
> > I am planning to switch to a web based tool to read this mailing list.
>
> That's great.
>
> > While reading is easy via web, how do I post a reply from web.
Everyone
Hi,
We have DB of 400GBs, Server RAM is 160GBs. CPU consumption is 1-3% only.
We have configured maintenance_work_mem to 10GBs and restarted the
postgres service.
We have done upgrade from postgres 9.5 to 9.6, then when we run vacuum
analyze on database, it is taking more than 5 hours and stil
> Gmail is a web interface... :)
I was gonna say that Ron, but I figured it would not be polite to say the
least
On 1/28/21 9:27 AM, Alvaro Herrera wrote:
On 2021-Jan-28, Ravi Krishna wrote:
I am planning to switch to a web based tool to read this mailing list.
That's great.
While reading is easy via web, how do I post a reply from web.
Yeah, "how" indeed.
Gmail is a web interface... :)
--
Angular
On 2021-Jan-28, Ravi Krishna wrote:
> I am planning to switch to a web based tool to read this mailing list.
That's great.
> While reading is easy via web, how do I post a reply from web.
Yeah, "how" indeed.
> I recollect there use to be a website from where one can reply from web.
The commun
>Is there a central place where i can get postgres blogs as they are
>written by different blog sites, e.g. can google news app be tuned
to just bring postgres blogs only?
I use https://planet.postgresql.org/
Yambu schrieb am 28.01.2021 um 16:21:
> Is there a central place where i can get postgres blogs as they are
> written by different blog sites
That would be https://planet.postgresql.org/
Hi
Is there a central place where i can get postgres blogs as they are written
by different blog sites, e.g. can google news app be tuned to just bring
postgres blogs only?
I am planning to switch to a web based tool to read this mailing list. While
reading is easy via web, how do I post a reply from web.I recollect there use
to be a website from where one can reply from web.
thanks
Short question. Is it recommended - or even best practice - to run vacuumlo
periodically as a routine maintenance task?
We don't do it. I think if this would be recommended it would have been
implemented as an autotask like autovacuum. No?
Thanks, Markus
Many thanks for the fast response.
Using an SRF is an interesting idea, I'll have a play and see if we can
make that work.
Cheers,
Kai
On Wed, Jan 27, 2021 at 3:27 PM Tom Lane wrote:
> Kai Daguerre writes:
> > We often have virtual tables where a list operation is not
> viable/possible
> > wi
23 matches
Mail list logo
