On 2019-08-15 23:27, Rich Shepard wrote:
On Thu, 15 Aug 2019, stan wrote:
I need to put a few bossiness constants, such as a labor rate
multiplier
in an application. I am adverse to hard coding these things. The best
plan
i have come up with so far is to store them in a table, which would
hav
Simon Windsor writes:
> Since then, large bulk inserts of configuration changes are failing with
> this Error, but adhoc and small changes are working ok.
Might it be that things work as long as the trigger is only tasked with
redirecting to the same child table (or limited set of child tables)
On 16/08/2019 04:35, Simon Windsor wrote:
Hi
The Full system used to in an Oracle DB and was ported to Postgres 9.5
about 2+ years ago, and partitioned using inheritance tables.
Since then pg_upgrade has been used to upgrade to pg10 (with apt
upgrade to take to 10.5 occasionally).
Last wee
-Original Message-
From: Tom Lane
Sent: Thursday, August 15, 2019 6:13 PM
To: stan
Cc: pgsql-gene...@postgresql.org
Subject: Re: Variable constants ?
stan writes:
> Failing a better way is there some way I can limit this table to only
> allow one row to exist?
I was recently reminded
stan writes:
> Failing a better way is there some way I can limit this table to only allow
> one row to exist?
I was recently reminded of a cute trick for that: make a unique index
on a constant.
regression=# create table consts(f1 int, f2 int);
CREATE TABLE
regression=# create unique index cons
On Thu, 15 Aug 2019, stan wrote:
I need to put a few bossiness constants, such as a labor rate multiplier
in an application. I am adverse to hard coding these things. The best plan
i have come up with so far is to store them in a table, which would have
only 1 row, and a column for each needed c
On 8/15/19 1:56 PM, stan wrote:
I need to put a few bossiness constants, such as a labor rate multiplier in an
application. I am adverse to hard coding these things. The best plan i have
come up with so far is to store them in a table, which would have only 1
row, and a column for each needed con
I need to put a few bossiness constants, such as a labor rate multiplier in an
application. I am adverse to hard coding these things. The best plan i have
come up with so far is to store them in a table, which would have only 1
row, and a column for each needed constant.
Anyone have a better way t
On 8/15/19 12:09 PM, PegoraroF10 wrote:
last values for autovacuum and autoanalyse are Null.
Thanks, I´ll change and see if that solve our problem
I thought we had been down this trail before:
https://www.postgresql.org/message-id/1564168884421-0.post%40n3.nabble.com
--
Sent from: https:
last values for autovacuum and autoanalyse are Null.
Thanks, I´ll change and see if that solve our problem
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
Are you autovacuuming and analyzing aggressively enough? Is there bloat or
other concern for these system tables? I expect it may be a concern based
on what I remember about your environment having thousands of tables and
perhaps autovacuum not keeping up (re: Too slow to create new schema and
thei
Hi
The Full system used to in an Oracle DB and was ported to Postgres 9.5
about 2+ years ago, and partitioned using inheritance tables.
Since then pg_upgrade has been used to upgrade to pg10 (with apt upgrade
to take to 10.5 occasionally).
Last week, pg_upgrade was againn used to upgrade to
Simon Windsor writes:
> I have just upgraded a Db from pg 10.5 to pg11.4 and almost immediately we
> are seeing errors like
> ERROR,XX000,"cache lookup failed for type 22079"
> When inserting into a a partitioned table. About 30% of inserts are
> reporting this error.
Hmm ... can you show the ful
The driver I´m using does some queries on system tables and obviously I
cannot change them because are driver inside. These two queries are usually
fast, but sometimes they take 8 or 15 times more to run. The question is,
can I change something on these tables ? Can i create an index, can I load
th
Hi
I have just upgraded a Db from pg 10.5 to pg11.4 and almost immediately we
are seeing errors like
ERROR,XX000,"cache lookup failed for type 22079"
When inserting into a a partitioned table. About 30% of inserts are
reporting this error.
How do I determine what type 22079 refers to? I have ch
Hello,
I need guidance on sending notification (data) to a soap server when
transaction occur in PostgreSQL server? How can I accompany this?
Your help will be highly appreciated.
Thank you.
Regards,Sahoong
Hi,I am a begginer of PostgreSQL.Is it possible to store some database in
user's harddisk?There is a main server but I want to save some data such as
preference in user's hard disk (not main server).Thank you for your kind
comments.Best regards,Jaehyun삼성 갤럭시 스마트폰에서 보냈습니다.
17 matches
Mail list logo
