Le 03/03/2022 à 19:43, Tom Lane a écrit :
=?UTF-8?Q?Marc_Recht=c3=a9?= writes:
Le 03/03/2022 à 16:31, Tom Lane a écrit :
Does memory consumption hold steady if you drop the FK constraints?
Actually the number of rows is 232735712.
Accordingly the RAM consumption would be x12 x3 = 7.8 GiB.
Le 03/03/2022 à 16:31, Tom Lane a écrit :
=?UTF-8?Q?Marc_Recht=c3=a9?= writes:
We have a pg_restore which fails due to RAM over-consumption of the
corresponding PG backend, which ends-up with OOM killer.
The table has one PK, one index, and 3 FK constraints, active while
restoring.
The dump
Em qui., 3 de mar. de 2022 às 05:59, Marc Rechté escreveu:
Hello,
We have a pg_restore which fails due to RAM over-consumption of
the corresponding PG backend, which ends-up with OOM killer.
The table has one PK, one index, and 3 FK constraints, active
while restoring
Hello,
We have a pg_restore which fails due to RAM over-consumption of the
corresponding PG backend, which ends-up with OOM killer.
The table has one PK, one index, and 3 FK constraints, active while
restoring.
The dump contains over 200M rows for that table and is in custom format,
which
Hi,
Le jeu. 7 mai 2020 à 11:13, Marc Rechté <mailto:ma...@rechte.fr>> a écrit :
Hello,
It is possible to startup an instance with min > max, without the
system
complaining:
mrechte=# show min_wal_size ;
2020-05-07 11:12:11.422 CEST [11098] LOG: duré
Hello,
It is possible to startup an instance with min > max, without the system
complaining:
mrechte=# show min_wal_size ;
2020-05-07 11:12:11.422 CEST [11098] LOG: durée : 0.279 ms
min_wal_size
--
128MB
(1 ligne)
mrechte=# show max_wal_size ;
2020-05-07 11:12:12.814
On Tue, 2020-05-05 at 07:56 +0200, Marc Rechté wrote:
Thanks for answers. Further readings make me think that we should *not*
start postgres with numactl --interleave=all: this may have counter
productive effect on backends anon memory (heap, stack). IMHO, what is
important is to use Huge Pages
Hi,
On 2020-04-29 10:50:54 +0200, Laurenz Albe wrote:
On Wed, 2020-04-29 at 08:54 +0200, Marc Rechté wrote:
I am trying to figure out the recommended settings for a PG dedicated
machine regarding NUMA.
I assume that the shared buffers are using Huge Phages only. Please
correct if I am wrong
Hello,
I am trying to figure out the recommended settings for a PG dedicated
machine regarding NUMA.
I assume that the shared buffers are using Huge Phages only. Please
correct if I am wrong:
1) postgres is started with numactl --interleave=all, in order to spread
memory pages evenly on
This refers to /doc/src/sgml/html/querytree.html, where one mentions a
qualification part in the Query Tree. While reading the Query node
(parsenode.h) and output from the log with debug_print_parse = on, I
cannot see either this part. Is it gone in profit of join tree ?
https://wiki.postgresql.org/wiki/Developer_FAQ
This link is dead: introduction to Hacking PostgreSQL - With lots of
code review!
https://linux.org.au/conf/2007/att_data/Miniconfs(2f)PostgreSQL/attachments/hacking_intro.pdf
Hello,
Don't know if this the correct list to submit this issue.
On the https://www.postgresql.org/developer/backend/, it mentions a
Query.qual field which does not exist in the Query structure.
Thanks
Hello,
I am trying to get sound passing trough a Display Port connected monitor.
Configuration has been loaded here:
http://www.alsa-project.org/db/?f=63ef0d739185fc6876cdad6afbe2b67cc0d1cc0f
$ speaker-test -Dhdmi:CARD=HDMI,DEV=0 -c2
or whatever device (0, 1, 2) does not produce any sound.
Bonjour,
Nous recherchons un développeur Gnome pour migrer une application
complexe de Gnome 2 à Gnome 3. Il s'agit d'une mission d'au moins 3 mois
sur Toulouse. Auriez-vous quelques suggestions à nous faire ? D'avance
merci.
Statut: freelance, CDD, stage
Description succincte du projet: Il
Do you set the type to 'normal'?
I cannot create from the tree hierarchical view (Financial / Analytic
Accounts), but I can with the tabular view (Financial / Analytic Accounts /
Analytic Accounts)
Thanks
Please give the full explaination and the queries you are analyzing
otherwise it is useless.
SELECT account_move.id AS id,account_move.create_uid AS
create_uid,account_move.create_date AS
create_date,account_move.centralised_line AS
centralised_line,account_move.post_number AS
I used the interactive pgAdmin query tool
Paste each query in that tool window and press F7 (or query / explain menu)
I'd say accounting in Tryton is better than in OpenERP:
You misunderstood me, I did not intend to compare the functional aspect of
the two products. OpenERP may have more real case implementations than
Tryton and therefore is faced with practical considerations like
performance and
Hello,
Most queries on the acoount_move table usually require access to the
company relation.
It is too far (one must go through period.fiscalyear.company), and it may
seriously impact performance on such a big table.
I suggest to denormalise the table to include the company field.
Thanks
For instance, if we consider the General Ledger report, and the simple
table scan on account_move:
clause = [
...,
('period.fiscalyear.company', '=', data['company']),
]
return Move.search(clause,
order=[('date', 'ASC'), ('id',
For the accounting module, I designed a draft journal report that hooks
into the Financial / Entries menu.
It's purpose is to report ones entries that are in draft state in order to
review them before posting.
This is a first stage towards batch posting.
Shall I submit it on Roundup as a
Le vendredi 29 mars 2013 10:42:26 UTC+1, Cédric Krier a écrit :
On 29/03/13 00:52 -0700, Marc Rechté wrote:
For the accounting module, I designed a draft journal report that
hooks
into the Financial / Entries menu.
It's purpose is to report ones entries that are in draft state
Le vendredi 29 mars 2013 11:20:40 UTC+1, Cédric Krier a écrit :
On 29/03/13 03:16 -0700, Marc Rechté wrote:
Le vendredi 29 mars 2013 10:42:26 UTC+1, Cédric Krier a écrit :
On 29/03/13 00:52 -0700, Marc Rechté wrote:
For the accounting module, I designed a draft journal report
Hello,
While making the package I get the out
...
checking alt pid path... /var/state/ups
checking driver path... ${exec_prefix}/bin
checking cgi path... /usr/share/webapps/nut
...
This brings also problems in systemd scripts which are not well expanded
after installation:
# cat
OK I found a former thread where you conclude
(https://groups.google.com/forum/?fromgroups=#!searchin/tryton/gpl/tryton/85G3MbUUp_M/vw85C3RkVpAJ):
If it is a derivative work then yes we want it to be under GPL.
If it is not a derivative work then do what you want.
This seem contradictory with
Thanks
--
--
tryton@googlegroups.com mailing list
Hello. Must tryton modules be developed under GPL or can they be closed
source ? Thanks
--
--
tryton@googlegroups.com mailing list
Hello,
I would like to know whether it would be possible to create custom
fields in calendar events ?
Thanks
--
users@sogo.nu
https://inverse.ca/sogo/lists
Eric,
How would you know (debug) that size+time compare fails in a rsync session ?
Thanks
Marc
Le 12/06/2012 15:39, ericbamba...@discover.com a écrit :
Alan,
What is the rsync command used? If it hits a large group of files
with no differences (easy to believe across 12TB) but has
Thanks Eric,
I have been struggling for a few days (see my former message --stats and
performance issue) with a similar problem to Alan's. They are very long
pauses and very few files / byte transferred.
For instance one run gave:
Mon Jun 11 18:01:34 CEST 2012
Number of files: 1187751
Hello,
My question is regarding the interpretation of --stats output and
whether I have a performance issue or not.
Can the client/server architecture (rsync client on one machine, rsync
server on another machine) be far slowlier than a local rsync session ?
This is the ouput of an rsync
Hello,
I am using samba 3.5 (Red Hat Linux 6) which comes with idmap_hash plugin.
I have put the following in smb.conf:
workgroup = WORKGROUP
password server = *
security = domain
idmap backend = hash
idmap uid = 500-33554431
idmap gid = 500-33554431
winbind nss info = hash
It is now working OK. Thanks a lot.
--
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/939653
Title:
Install / RedHat 6.2 / pip fails with InstallationError
Status in OpenERP Server:
Thank you Francis.
Le 06/04/2012 14:33, Francis Lachapelle a écrit :
Hello Marc
On 2012-04-06, at 7:10 AM, Marc Rechté wrote:
I wondered why is sogo-tool not included in the rpm package ?
sogo-tool has its own rpm package.
yum install sogo-tool
:)
Francis
--
flachape...@inverse.ca
Hello,
I wondered why is sogo-tool not included in the rpm package ?
Thanks
--
users@sogo.nu
https://inverse.ca/sogo/lists
name was Beta. Those aren't actually the names BUT the alphabetical
order was the same. An offline Win 7 user if unable to login as
BETA\username might be able to login as ALPHA\username.
On 10/19/2011 12:59 PM, Marc Rechté wrote:
Hello,
I am faced with the exact same problem described here
Hello,
I am faced with the exact same problem described here:
http://lists.samba.org/archive/samba/2008-October/144077.html
Viz my server is out of order and nobody (except one lucky user) can
open his session from the Windows cache.
I am quite sure that the problem resides in the domain
Hello,
1) Have you tried to check the mysql log for any related message ?
2) Can you connect to my sql, using tcp/ip, with the same account ?
3) May be you can try plain password first
Regards
Le 14/09/2011 00:21, Christoph a écrit :
Hi,
we are using SOGo in a couple of environments and are
Hello,
I would like to know which version of Samba is requied, if possible at
all, to perform the following:
I have a Samba domain (server is configured as a PDC) that requires to
trust an AD domain (two-way) in order to share network ressources on
both domains ?
Many thanks
--
To
Hello,
I would like to know which version of Samba is requied, if possible at
all, to perform the following:
I have a Samba domain (server is configured as a PDC) that requires to
trust an AD domain (two-way) in order to share network ressources on
both domains ?
Many thanks
--
To
Hello Gaiseric,
Thank you for your answer.
My last experience in Windows server was on NT, therefore my knowledge
on AD is rather limited. I however work with an AD admin who may answer
to some questions.
He said the server with which the relation has to be set is in a 2003
level forest
Hello Wolfy,
This is what I wanted to avoid: tempering with Red Hat supplied files,
especially these scripts may be tricky and also are overwritten by
initscripts updates. I think that for the time being I will not not
shutdown the UPS (though this was working with a serial driver).
Thanks
Hello Charles,
Thanks for your feedback.
This is Red Hat EL 4.
You seem to be right about the mounted filesystem. This is the last
lines of halt script:
# Try all file systems other than root and RAM disks, one last time.
mount | awk '!/( \/ |^\/dev\/root|^\/dev\/ram| \/proc )/ { print $3
Hi,
I am facing a similar problem to what I faced sometime ago with Excel 11
when saving a modified xls file on a smb share: the application was
saying the file is already used by another user (although this was not
the case). The Excel problem was solved by adding a registry string
somewhere in
Please do not consider my former post regarding that subject: the
problem was due to BitDefender anti-virus program. Since we disabled the
scanning of dwg files the problem is gone. Sorry for disturbing the list.
Best regards
--
To unsubscribe from this list go to the following URL and read
Sorry to have disturbed the list for that problem that seems not related
to Samba. We discovered that BitDefender antivirus real time
protection is the cause. We are going to submit the issue to them.
Regards.
--
To unsubscribe from this list go to the following URL and read the
instructions:
Hi,
I am facing a similar problem to what I faced sometime ago with Excel 11
when saving a modified xls file on a smb share: the application was
saying the file is already used by another user (although this was not
the case). The Excel problem was solved by adding a registry string
Hello Loney Wolf,
Thanks for the explanation. I have learnt something new...
lonely wolf a écrit :
On 03/13/2007 05:51 PM, Arnaud Quette wrote:
2007/3/13, [EMAIL PROTECTED] [EMAIL PROTECTED]:
Hi,
In Red Hat /etc/init.d/halt script, it expects upsdrvctl to be in
/sbin rather
than /bin
Arnaud,
This is the piece of information:
[EMAIL PROTECTED] hylafax]# ldd /bin/newhidups
libusb-0.1.so.4 = /usr/lib64/libusb-0.1.so.4 (0x003d1760)
libc.so.6 = /lib64/tls/libc.so.6 (0x003709d0)
/lib64/ld-linux-x86-64.so.2 (0x003709b0)
Thanks for the
Hi Arjen,
Thanks for your prompt answer.
I checked the ups.conf and newhidups man pages and could not locate the
pollfreq parameter. Do you mean pollinterval ?
Best regards.
Marc.
Arjen de Korte a écrit :
ups.conf is:
[EMAIL PROTECTED] rules.d]# cat /etc/ups/ups.conf
# UPS Conf for NUT
Thanks Arnaud for your prompt answer.
Please find attached the required log (interrupted after a few minutes run).
Best regards
Marc.
Arnaud Quette a écrit :
salut Marc,
2007/3/12, [EMAIL PROTECTED] [EMAIL PROTECTED]:
...
Howerver starting upsmon keeps reporting:
Mar 12 16:19:46 serveur1
52 matches
Mail list logo
