Some time zones have abbreviations that are identical to their names. This
query:
select name
from pg_timezone_names
where abbrev = name
order by name;
gets this result:
EST
GMT
HST
MST
UCT
UTC
This, in itself, doesn’t seem remarkable. I wondered if any time zones have
names that occur as tim
This query:
select distinct abbrev as a
from pg_timezone_names
where abbrev like '%+%' or abbrev like '%-%'
order by 1;
gets lots of rows with names like these:
+00
+01
+12
-07
-08
This query shows that none of these is found in pg_timezone_abbrevs:
with v as (
select distinct abbrev as a
>
> We found out because we are monitoring long running queries, and saw it
> had been running for a month before the restart yesterday.
> I just queried pg_stat_activity and it seems to be running since then.
>
> taimusz=# SELECT pid, query_start, usename, left(query,70)
> FROM pg_stat_activity
>
On Tue, May 18, 2021 at 6:46 AM Tom Lane wrote:
> "David G. Johnston" writes:
>
> > as well as the fact that 0 disables the logical replication
> > subscribing feature altogether, and precludes the background worker
> > scheduler process from launching at startup?
>
> I'd be in favor of mentioni
"David G. Johnston" writes:
> Given this, should the configuration description for this include the "This
> parameter can only be set in postgresql.conf file or on the server command
> line." comment,
Hmm, yeah, it does lack the standard boilerplate for a PGC_POSTMASTER
GUC. I wonder which other
On Mon, May 17, 2021 at 7:13 AM Tom Lane wrote:
> "David G. Johnston" writes:
> > On Monday, May 17, 2021, Tom Lane wrote:
> >> It looks like it won't be started if you set
> >> max_logical_replication_workers = 0.
>
> > I was wondering about that. Would you mind posting a link to the code
> >
>> El día lunes, mayo 17, 2021 a las 01:27:40p. m. -, haman...@t-online.de
>> escribió:
>> >> > Hi,
>> > >> > in unicode letter ä exists in two versions - linux and windows use a
>> > >> > composite whereas macos prefers
>> > the decomposed form. Is there any way to make a semi-exact match th
Hi Gianni,
many thanks for your detailed response.
It turned out that my postgresql installation is too old for normalize,so I
will probably
a) use an external script to normalize existing data
b) change application code to normalize data before inserting or searching
Regards
Wolfgang
>> On 17
=?UTF-8?Q?Hannes_K=c3=bchtreiber?= writes:
> Hello Tom, thanks for your answer!
> We found out because we are monitoring long running queries, and saw it
> had been running for a month before the restart yesterday.
> I just queried pg_stat_activity and it seems to be running since then.
Oh, that
Hello Tom, thanks for your answer!
We found out because we are monitoring long running queries, and saw it
had been running for a month before the restart yesterday.
I just queried pg_stat_activity and it seems to be running since then.
taimusz=# SELECT pid, query_start, usename, left(query,7
Hi,
I am using postgresql 12.7 on Ubunut as a datawarehouse, that is then
queried by QlikSense to produce business analytics.
One of my dataloaders, that runs multiple queries, sometimes takes about
3 hours to feed Qlik with the relevant records (about 10M records), but
sometimes goes crazy
=?UTF-8?Q?Hannes_K=c3=bchtreiber?= writes:
> We have tried logical replication in a test-setup, and it appears to
> work fine.
> However, the following statement keeps running:
> SELECT pg_catalog.set_config('search_path', '', false);
What makes you think it "keeps running"? It looks to me lik
Hello everybody,
not sure where to post this, general seems most appropriate.
We have tried logical replication in a test-setup, and it appears to
work fine.
However, the following statement keeps running:
SELECT pg_catalog.set_config('search_path', '', false);
It is issued by the user 'subs
G'day all,
A quick follow-up on this issue for interest's sake. The stalling we
were seeing turned out to be a Cloud SQL issue and not related to our
listen/notify usage.
Cloud SQL has an automatic storage increase process that resizes the
underlying disk as required to account for cluster growth
14 matches
Mail list logo
