"Tom Lane" writes:
> We can see from this that the server spent 10 seconds in CommitTransaction,
> so the question is what took so long.
I'd wonder first about end-of-transaction triggers (have you got foreign keys
on that table? maybe an event trigger?), and then second about delays in
writ
Hey Tiff,
We're in a similar boat. We currently lean on (mostly custom) ansible
scripting to automate all the repeatable tasks we can, but automation of
major PG version upgrades is something we are yet to tackle -- although we
plan to start this effort in the short term.
Would you mind sharing a
Yes, it is.
I continue to extract data as promised, but I think I see some pattern.
"chicken or egg"
To work with the NPGSQL library, I created a cast. They are created after
the views in which I use them.
Here is the order
279: CREATE TYPE bpd.cclass_prop
4646: CREATE VIEW bpd.vclass_prop
4784: CR
Yes, it is.
I'll leave behind the lost features, views, table definitions, and
dependent objects. It will take some time.
thanks, for the help.
пн, 15 нояб. 2021 г. в 20:49, Tom Lane :
> =?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?=
> writes:
> > Is it ok to attach a 5MB data schema or is it
Yes, it is.
I did so (--schema-only). Removing unnecessary definitions.
That is, you do not need to attach files?
пн, 15 нояб. 2021 г. в 20:49, Tom Lane :
> =?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?=
> writes:
> > Is it ok to attach a 5MB data schema or is it not possible? Copy one by
> on
=?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?= writes:
> Is it ok to attach a 5MB data schema or is it not possible? Copy one by one
> to a letter?
Is it smaller if you omit the data (-s switch)? Shouldn't be relevant
here.
regards, tom lane
Thanks for the feedback!
Is it ok to attach a 5MB data schema or is it not possible? Copy one by one
to a letter?
It would be nice if in the end I could rebuild the base without hindrance.
Thank you in advance.
Restore Windows 10 PostgreSQL 12.9, compiled by Visual C++ build 1914,
64-bit -> Debian
Yarden:
On Mon, 15 Nov 2021 at 10:30, yarden tamam wrote:
> i have data bast that represents basketball teams. and i'm trying to find one
> team that has not won yet but has gain that most points during their games
> from the other team who have not won yet.
> i wrote a query that is checking i
"Chen, Yan-Jack (NSB - CN/Hangzhou)" writes:
> We recently encounter one issue about PostgreSQL ODBC client doesn¡¯t
> receive response from PostgreSQL server in time (client set 5 seconds
> timeout) occasionally (1 or 2 times per 24 hours). Both PostgreSQL and its
> client are deployed in V
On Mon, Nov 15, 2021 at 09:30:03AM -0500, Bruce Momjian wrote:
>
> Due to time constraints, I do not directly answer general PostgreSQL
> questions. For assistance, please join the appropriate mailing list and
> post your question:
>
> https://www.postgresql.org/community
>
> You can also
Due to time constraints, I do not directly answer general PostgreSQL
questions. For assistance, please join the appropriate mailing list and
post your question:
https://www.postgresql.org/community
You can also try the #postgresql IRC channel on irc.freenode.net. See
the PostgreSQL FA
Hi,
Every year we spent a lot of time planning and manually performing major
PostgreSQL upgrade on many of our on-prem and RDS instances. I’m wondering
if there is a better way of managing these upgrades through automation. Can
anyone share their experiences?
Thanks.
Tiff
i have data bast that represents basketball teams. and i'm trying to find
one team that has not won yet but has gain that most points during their
games from the other team who have not won yet.
i wrote a query that is checking if a team has not won at all. but i'm
trying to figure out how to coun
13 matches
Mail list logo
