Re: [ADMIN] CPU causes 100% load in user space when ntp client runs and postgresql is under heavy load

. Most Regards, Dennis Brouwer M4N On Mon, Sep 24, 2012 at 6:30 PM, Tom Lane wrote: > Dennis Brouwer writes: > > Last week I was repeatedly able to run all these tests on the database > > without any issue but recently, all of a sudden at random, some of the > > queries

Re: [ADMIN] CPU causes 100% load in user space when ntp client runs and postgresql is under heavy load

gards, Dennis Brouwer M4n On Mon, Sep 24, 2012 at 6:30 PM, Tom Lane wrote: > Dennis Brouwer writes: > > Last week I was repeatedly able to run all these tests on the database > > without any issue but recently, all of a sudden at random, some of the > > queries performed a factor 1

[ADMIN] CPU causes 100% load in user space when ntp client runs and postgresql is under heavy load

ebody from the mailing list has sufficient experience debugging this kind of behaviour to exclude a bug in postgresql. Much appreciated! Very kind regards, Dennis Brouwer M4N P.S. If required I can provide more details like: the queries, auto_explain output, iostat, top, iotop, postgresql.conf etc etc.

[ADMIN] postgresql question

to 700 from 750 ), the Postmaster starts just as it should. Why does the Postmaster not start with the group permissions changed? Is this a bug? What can I do? TIA Dennis

Re: [ADMIN] "the database system is starting up"

Hi, There was no user involved, as far as I can see. The connection attempts are refused at the door :) Mine kept going indefinitely, but by trial-and-error I found the application process causing the connection attempts. Thanks for the input though. -dennis -- Geysir IT [email protected]

Re: [ADMIN] "the database system is starting up"

On 12/04/2010, at 15.42, Kevin Grittner wrote: > Dennis Thrysøe wrote: > >> Are there any good tools or logging options for determining >> who/what? > > Are you on a recent enough version to have log_connections and > log_disconnections available? If s

Re: [ADMIN] "the database system is starting up"

On 12/04/2010, at 14.58, Devrim GÜNDÜZ wrote: > On Mon, 2010-04-12 at 14:04 +0200, Dennis Thrysøe wrote: >> I know, but a log line each second becomes a lot if the system is like >> this for weeks at a time... > > Definitely a client app which is trying to connect to the

[ADMIN] "the database system is starting up"

Hi people, I keep getting this message "the database system is starting up" in the postgres log while system is running in archive recovery mode (warm standby). Stops when system enters production mode. I have checked network traffic, but there is none for port 5432. So it must be something

Re: [ADMIN] WARM standby with pg_standby

stat `/psql_archive/0001.history': No such file or directory" By the way, one of these lines each second! "2010-04-09 09:09:49 IST FATAL: the database system is starting up" Any help appreciated. -dennis -- Geysir IT [email protected] http://geysirit.dk +45 31 51 60 00

[ADMIN] WARM standby with pg_standby

Hi, I have a few elaborating questions in regard to setting up Warm Standby. 1) The master keeps writing WAL files even though I'm quite sure nothing is happening. This seems like a large waste of diskspace? 2) Sometimes my slave does not read and delete WAL files when in recovery mode. This w

[ADMIN] Database recovery due to out of disk space

te or postgres database? Suggestions more then welcome how to force drop this table by identifying the missing records or other tricks that shouldn't be done at home. Most Regards, Dennis Brouwer -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your su

Re: [ADMIN] pg_ctl start doesn't daemonize properly

> I am having problems getting pg_ctl to detach from the controlling terminal > so that it's a proper daemon. I figured out the problem, and record it here in hopes that it will help others. The silent_mode setting was not on, so postmaster initialization was not calling setsid(), which is a nec

[ADMIN] pg_ctl start doesn't daemonize properly

I am having problems getting pg_ctl to detach from the controlling terminal so that it's a proper daemon. I am running pg_ctl start -w -s -l $logfile within a script, which is invoked from an automated test framework written in python. If the python process is stopped by Ctrl-C, postgres dies. But

Re: [ADMIN] Using GUIDs

ly I'm storing entries of different type in different tables. To have them distinct on a combined list I would need both the type and the id of a single row which would make up 16 Bytes if the type is bigserial as well (which it is in my scenario). Thanks, Aaron Thanks for your quick

[ADMIN] Using GUIDs

anyone made some test in this field and can share some experiences? Would this question be better placed in the hackers list? Best regards Dennis ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [ADMIN] binary data types and streaming

Hi David! If you need streaming access to binary data use PostgreSQL's "large objects". They provide what you might want. Greets Dennis Hi- I'm looking for information about storing binary data in postgres. I've set up a few tests where in I stored bytea data

Re: [ADMIN] Running Postgres on CD - With Win32

install postgres on any machine that DVD is run on. Most likely users won't have admin-rights or even priviledged user-rights when they use the created DVD. ...Dennis Peter Childs schrieb: If all you want is a client you should just be able to write it and it will connect to the server and

[ADMIN] Running Postgres on CD - With Win32

g-files to nirvana (like the good old BOFH used to do) or into a memdrive. Has anybody accomplished the task to run PostgreSQL from CD (even on Linux) and is willing to contribute some of his/her experiences? Any help is greatly appreciated. ...Dennis ---(end of

Re: [ADMIN] configuring pg_hba.conf file

Hi Jagdish, You shouldn't be listing each IP address in the file. If you want a specific IP address then the netmask should have been 255.255.255.255 to indicate that all octets are required for the address comparison. For your subnet you should have an IP subnet of 192.168.0.0 and a netmask o

Re: [ADMIN] [PERFORM] Quad processor options

are lucky that can help. -- /Dennis Björklund ---(end of broadcast)--- TIP 8: explain analyze is your friend

[ADMIN] Statistical Reporting

owever we understand that currently there is not a stable replication solution for Postgresql 7.32 Does anybody have any suggestion on how to handle this query more efficiently? Thanks in Advance. Dennis (a non-technical person) ---(end of broadcast)-

Re: [ADMIN] concat_ws

his inlining taking place and what is the logic? I just want to make sure that there is no code in pg that will unfold forever, say for example for a recursive fac() function. From the above it sounds like that might be a problem. -- /Dennis ---(end

[ADMIN] Disk Page Fetches

When you use explain, it gives you a cost estimate in units of disk page fetches. How can I tell how many disk page fetches my machine is likely to do/second and how long the query might actually take? -Dennis ---(end of broadcast)--- TIP 5

Re: [ADMIN] Trouble installing PostgreSQL

m.y >> /usr/bin/yacc: f - maximum table size exceeded >> gmake: *** [parse.h] Error 2 >> >> If someone knows what to do, please help me. >> >> Thanks >> >> Roman Smutny >> >> > > >-- > Bruce Momjian| http://www.op.net/~candle > [EMAIL PROTECTED]| (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 Dennis Barnett [EMAIL PROTECTED]