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
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
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
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?
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/
>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/
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
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
> Gmail is a web interface... :)
I was gonna say that Ron, but I figured it would not be polite to say the
least
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
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
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
> 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 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
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
Hello
May I know where I can get freelancer jobs for postgres?
regards
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
> -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.
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
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
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
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 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
23 matches
Mail list logo
