Hello,
We have an issue with fsm_relations utilization reaching 99%, I was able to
vacuum a handful of tables, but it wasn't enough to make a noticeable
difference. I think at this point we will need to increase the number of
fsm_relations from 80,000 to 100,000 which will require a restart. Bec
Hello.
At Fri, 17 May 2019 11:04:58 +0300, ayaho...@ibagroup.eu wrote in
> Can frequent database operations cause getting a standby server behind? Is
> there a way to avoid this situation?
> I checked that walsender works well in my test if I set
> wal_sender_timeout at least to 5 second.
It
On 23/5/19 5:05 μ.μ., ayaho...@ibagroup.eu wrote:
Hello Everyone!
I can simplify and describe the issue I faced.
I have 2 nodes in db cluster: master and standby.
I create a simple table on master node by a command via psql:
CREATE TABLE table1 (a INTEGER);
After this I fill the table by COPY co
čt 23. 5. 2019 v 23:38 odesílatel Alastair McKinley <
a.mckin...@analyticsengines.com> napsal:
> Hi Andrew,
>
> Thanks for your in-depth response. I found that adding the stable
> qualifier didn't solve the issue unfortunately. I actually encountered the
> same issue (or at least extremely simil
Hi Andrew,
Thanks for your in-depth response. I found that adding the stable qualifier
didn't solve the issue unfortunately. I actually encountered the same issue
(or at least extremely similar) today and made a bit more progress on defining
it.
I have a carefully indexed and optimised query
Hi List ... I'm investigating how to port our data and applicationsfrom our
in-house developed database server to PostgreSQL.
One of the challenges I'm running into is in replicating an 'autonumber'
column type.. we're used to having a primary key that will autogenerate a
31bit integer that will a
Hello Everyone!
I can simplify and describe the issue I faced.
I have 2 nodes in db cluster: master and standby.
I create a simple table on master node by a command via psql:
CREATE TABLE table1 (a INTEGER);
After this I fill the table by COPY command from a file which contains
200 (2 millio
On Thu, 23 May 2019, Frank Alberto Rodriguez wrote:
If you have the database modeled, the most quickly think I can thinks is
with python framework Django. Configure the connection to the DB and make
reverse engineer with Django, this create the entities class, then
activate the administration fo
If you have the database modeled, the most quickly think I can thinks
is with python framework Django. Configure the connection to the DB and
make reverse engineer with Django, this create the entities class,
then activate the administration forms and configure each form for the
entities (few line
Not exactly sure how much coding you are interested in doing.I use access and
Libre Base to prototype data entry from time to time.Been pretty happy with
Lazarus lately. A free Delphi/Pascal IDE, that runs x-platform.You can put
stuff together pretty quickly.Best
Original message --
On 2019-05-20 23:30, Tom Lane wrote:
> Hmm ... given that pg_get_publication_tables() shouldn't return any
> duplicate OIDs, it does seem unnecessarily inefficient to put it in
> an IN-subselect condition. Peter, is there a reason why this isn't
> a straight lateral join? I get a much saner-looki
Quoting Achilleas Mantzios :
as of 10 (same with 11) you (IL) must be the owner of relation SCD.TEMPL_BK .
Create your tables with a user who has correct privileges on both
tables/schemas.
Not what I hope for but was afraid of. thank you for the answer.
--
Achilleas Mantzios
IT DEV Lead
I
On 23/5/19 8:46 π.μ., Thiemo Kellner wrote:
Hi all
I am wondering if table inheritance is possible over the boundaries of schemata
and different owners.
I have database act with schemata il and scd. When I issue as IL
create table IL.INHERITANCE_TEST() inherits (SCD.TEMPL_BK);
I get
[Code:
I looked at quite a few options. Some constraints on my side that our
direction is open source, with Linux development and servers.
Radzen is .NET: I could just as well use MS Access to cobble together a
front end.
CUBA and OpenXava are Java based and seem to require writing Java for
logic: I l
14 matches
Mail list logo
