On Thu, 30 May 2024 at 09:37, Christian Schröder
wrote:
> Unfortunately, all disks have plenty of free space, so this can be ruled out
> as a reason.
> I will follow up on the other suggestions from the list.
Do not forget to check all mounted filesystems, not only disks.
Specially /dev/shm, IIR
Hi Francisco,
Unfortunately, all disks have plenty of free space, so this can be ruled out as
a reason.
I will follow up on the other suggestions from the list.
Best,
Christian
-Original Message-
From: Francisco Olarte
Sent: Wednesday, May 29, 2024 10:24 AM
To: Christian Schröder
Cc: p
Hi Salahuddin,
I had already checked most of your points, but I double checked them now.
# free -m
totalusedfree shared buff/cache available
Mem: 158821466 2692110 14147 11976
Swap: 1999 254
Hi christian:
On Thu, 30 May 2024 at 12:51, Christian Schröder
wrote:
...
> I had already checked most of your points, but I double checked them now.
...
> Shared memory limits look good to me:
> # sudo sysctl -a | grep kernel.shm
> kernel.shmall = 18446744073692774399
> kernel.shmmax = 184467440
No, I can´t use ODBC in this case, because I only access a new server. I
need the DLL in 32 bits.
Atte
Mello
Em qua., 29 de mai. de 2024 às 23:45, Juan Rodrigo Alejandro Burgos Mella <
rodrigoburgosme...@gmail.com> escreveu:
> you can use ODBC with Windev, so the best is the Postgresql connector
The RULE infrastructure permits the programmer to specify a series of
commands in the DO action
from the syntax diagram in the manual :
CREATE [ OR REPLACE ] RULE name AS ON event
TO table [ WHERE condition ]
DO [ ALSO | INSTEAD ] { NOTHING | command | ( command ; command ... ) }
The
postgresql odbc has 32 and 64 bits, and you make a System DSN and that's it
I have made implementations for PHP, .Net, C#, Python; even ASP Classic.
Atte.
JRBM
El jue, 30 may 2024 a las 13:27, José Mello Júnior (<
jose.mello.jun...@gmail.com>) escribió:
> No, I can´t use ODBC in this case, becau
Hi,
We have a postgres 10.7 database which reports a number of issues on
user-created tables as well as system tables. Most errors are one of the
following:
-- ERROR: found xmin 1888159934 from before relfrozenxid 1998177448
-- ERROR: MultiXactId 613819197 does no longer exist -- apparent wrap
Don't have more?
Em qui., 30 de mai. de 2024, 16:14, Juan Rodrigo Alejandro Burgos Mella <
rodrigoburgosme...@gmail.com> escreveu:
> postgresql odbc has 32 and 64 bits, and you make a System DSN and that's it
> I have made implementations for PHP, .Net, C#, Python; even ASP Classic.
>
> Atte.
> J
On Thu, May 30, 2024, 12:32 johnlu...@hotmail.com
wrote:
> Any thoughts?
>
Very little interest exists in working on user-specified rules. They are
practically deprecated.
>
> Any interest in perhaps providing a choice via a configuration
> parameter?
>
Almost certainly not. Configuration
On 5/30/24 11:32, johnlu...@hotmail.com wrote:
Any thoughts? Any rationales one way or the other? Any interest
in perhaps providing a choice via a configuration parameter?
1) As to using rules, stop now before you invest the time to find out is
a road you don't want to go down.
2) U
1. Is there a way to delete a specific column level stats/histogram. The
following approach does not work.
alter table abc alter column bg_org_partner set statistics 0;
analyze abc;
select *
FROM pg_stats where tablename in ('abc' ) and attname = 'bg_org_partner';
the most_common_
On 5/30/24 4:56 PM, David G. Johnston wrote:
Very little interest exists in working on user-specified rules. They
are practically deprecated.
Ah - pity - see my last comment to Adrian's
Any interest in perhaps providing a choice via a configuration
parameter?
If anythi
On Fri, 31 May 2024 at 09:28, Wong, Kam Fook (TR Technology)
wrote:
> Is there a way to delete a specific column level stats/histogram. The
> following approach does not work.
>
> alter table abc alter column bg_org_partner set statistics 0;
> analyze abc;
You'd have to:
DELETE FROM pg_stati
What type of project are you developing at Windev? As a proof of concept,
maybe using libpq.lib we can do something
Atte
JRBM
El jue, 30 may 2024 a las 16:37, José Mello Júnior (<
jose.mello.jun...@gmail.com>) escribió:
> Don't have more?
>
> Em qui., 30 de mai. de 2024, 16:14, Juan Rodrigo Alej
"johnlu...@hotmail.com" writes:
> But I suppose that my next question, given what you both say about the
> RULE system being a dead-end, is whether there is any likelihood of
> supporting an INSTEAD OF trigger on a view at statement level? Maybe
> that stands more chance of going somewhere
(please keep communication on the list)
On Fri, 31 May 2024 at 13:43, Wong, Kam Fook (TR Technology)
wrote:
>
> Silly question why did I run into this problem below? Will the autovacuum
> analyze abc reset it back which I don't want it to.
>
> DELETE FROM pg_statistic WHERE starelid = 'abc'::re
BTW here is the network configuration we set as
UTOCONNECT_PRIORITY=120
BOOTPROTO=dhcp
DEVICE=eth0
DHCPV6C=yes
HWADDR=
IPV6INIT=yes
ONBOOT=yes
TYPE=Ethernet
USERCTL=no
Regards
Mukesh Tanuku
On Wed, May 29, 2024 at 12:53 PM Mukesh Tanuku
wrote:
> Thanks Bo for your response to my email.
>
> Bel
18 matches
Mail list logo
