Merlin Moncure wrote:
> we have to be careful to rule out some underlying possible
> contributing factors before switching up things up to much.
Agreed.
> THP compaction in particular has plaguing servers throughout the
> company I work for;
I've seen many support tickets where turning off Tra
Eric Ridge writes:
> As best I can guess, Postgres has some kind of memory leak around (at least)
> temporary tables flagged to drop on commit. It's fairly easy to reproduce:
I don't see any memory leak with this example.
What I do see is the process's use of shared memory grows slowly until i
On 6/12/2014 4:24 PM, Si Chen wrote:
PgBouncer looks pretty cool. Do you recommend using it with jdbc with
about 50 - 100 normal connections?
Java has quite a few built in connection pooling options.
they all work best if your software is configured to grab a connection,
use it for a transac
On Thu, Jun 12, 2014 at 1:57 PM, Christopher Nielsen
wrote:
> Lately, though, about once a day now, for about a week, we have been
> experiencing periods of stalling. When Postgres stalls, we haven't been able
> to recover, without restarting the database, unfortunately.
Just the db and not t
PgBouncer looks pretty cool. Do you recommend using it with jdbc with
about 50 - 100 normal connections?
On Thu, Jun 12, 2014 at 6:35 AM, Igor Neyman wrote:
> From: pgsql-general-ow...@postgresql.org [mailto:
> pgsql-general-ow...@postgresql.org] On Behalf Of Si Chen
> Sent: Wednesday, June 11
# select version();
version
---
PostgreSQL 9.
On Thu, Jun 12, 2014 at 3:32 PM, Kevin Grittner wrote:
> Merlin Moncure wrote:
>
>> or something else entirely.
>
>
> It strikes me that this might be relevant:
Agreed. The stock advice to many, many problems of this sort is 'use
pgbouncer' but it can be hard to work in a lot of code bases and
On 6/12/2014 12:57 PM, Christopher Nielsen wrote:
With a problem like this, I am not exactly positive how to proceed. I
am really looking forward to hearing your thoughts, and opinions, if
you can share them.
keep a shell session open with a superuser role (eg, postgres), and next
time its
Merlin Moncure wrote:
> or something else entirely.
It strikes me that this might be relevant:
http://wiki.postgresql.org/wiki/Number_Of_Database_Connections
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-general mailing list (pgsq
Thank you for the response.
On further investigation, we found out that select statements were happening
normally. But DMLs (writes to the DB) were hung for minutes at a time, and some
of them went through. And we had 2 checkpoints during this period. Yesterday
when we had the issue, we had 759
Thanks Merlin.
We did look at the locks in the DB and all we saw were RowExclusiveLock,
AccessShareLock, RowShareLock, AccessExclusiveLock. The ExclusiveLocks we saw
were all in the virtualxids.
I think the max_connections maxing out is due to the DB not being able to write
and complete existi
Hi,
when a row is updated a RowExclusiveLock is obtained on the updated row
and on every related index.
Is the order in which these locks are acquired defined in some way?
Thanks,
Torsten
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscriptio
On Thu, Jun 12, 2014 at 1:51 PM, Vasudevan, Ramya
wrote:
> Thanks Merlin.
>
> We did look at the locks in the DB and all we saw were RowExclusiveLock,
> AccessShareLock, RowShareLock, AccessExclusiveLock. The ExclusiveLocks we saw
> were all in the virtualxids.
>
> I think the max_connections ma
Si Chen writes:
> Is there a way to configure postgresql to automatically release connections
> that have been idle for a set amount of time?
I've seen recent discussion in hackers that this may be added to an
upcoming release.
> On Wed, Jun 11, 2014 at 3:41 PM, Merlin Moncure wrote:
>
>
On Thu, Jun 12, 2014 at 10:22 AM, Torsten Förtsch
wrote:
> Hi,
>
> our developers use a ORM tool which generates updates that write all
> columns of a table. In most cases, however, very few columns actually
> change. So, those updates mostly write the same value that already is
> there in the co
On Thu, Jun 12, 2014 at 1:23 PM, Vasudevan, Ramya
wrote:
> Thank you for the response.
>
> On further investigation, we found out that select statements were happening
> normally. But DMLs (writes to the DB) were hung for minutes at a time, and
> some of them went through. And we had 2 checkpoin
On Wed, Jun 11, 2014 at 7:24 PM, Tom Lane wrote:
> Robert Haas writes:
> > On Tue, Jun 10, 2014 at 7:19 PM, Tom Lane wrote:
> >> Given the lack of previous complaints, I'm not sure this amounts to
> >> a back-patchable bug, but it does seem like something worth fixing
> >> going forward.
>
> >
Hi,
our developers use a ORM tool which generates updates that write all
columns of a table. In most cases, however, very few columns actually
change. So, those updates mostly write the same value that already is
there in the column.
Now, if there is an index on such columns, does Postgres recogn
On 06/12/14 10:01, CS_DBA wrote:
>
> We would like to setup a hot standby server with a forced delay.
> Is it possible to setup a hot standby based ONLY on WAL shipping and NOT
> use streaming replication?
Yes it is. Though, I assume you mean 'forced max sync period' as
opposed to 'forced delay
Let's assume there's a table dem.address
CREATE TABLE address (
id integer NOT NULL,
id_street integer NOT NULL,
aux_street text,
number text NOT NULL,
subunit text,
addendum text,
lat_lon point
)
Hi All;
We would like to setup a hot standby server with a forced delay.
Is it possible to setup a hot standby based ONLY on WAL shipping and NOT
use streaming replication?
Thanks in advance
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscri
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of boca2608
> Sent: Thursday, June 12, 2014 12:33 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Re: Cannot start Postgresql 9.3 as a service in Windows
> 201
After adding the domain user account into the local users group, the
postgresql service can be started successfully now. We will do more testing
to make sure that all postgresql functions are working. But I want to give
my big thanks to Krystian Bigaj, Igor Neyman and Raymond O'Donnell for
offeri
On 6/12/2014 2:06 AM, Khangelani Gama wrote:
Was the database server restarted after the new version was built?
It was not restarted - Should I do so?
why aren't you running the version in the pgdg yum repository, which
includes XML support and a lot more.
--
john r pierce
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of boca2608
Sent: Thursday, June 12, 2014 11:05 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Re: Cannot start Postgresql 9.3 as a service in Windows 2012
Server with a domain account
Igor,
Igor,
Our network security policy requires that such database services run under a
dedicated domain account. (Postgresql does run successfully under local
system account and the default NETWORK SERVICE account.)
Thanks,
John
From: Igor Neyman [via PostgreSQL]
[mailto:ml-node+s1045698n5
(re-posting, because I've used Reply, instead of Reply all, thanks)
On 11 June 2014 18:05, boca2608 wrote:
>
> When trying to start postgresql as a service with a domain account on a
> windows 2012 server, the service starts and stops immediately. The Windows
> event log showed a terse error abou
On 12 June 2014 15:59, boca2608 wrote:
> Krystian Bigaj replied this in a separate email, which led to some
> interesting information that I would like to share in this mailing list.
>
> He suggested the use of the "Process Monitor" app to log the process events
> during the startup of the servic
On Thu, Jun 12, 2014 at 8:43 AM, Saravanan Subramaniyan
wrote:
> Hi All,
> Recently OpenSSL released Security Advisory. Please refer below link
>
> http://www.openssl.org/news/secadv_20140605.txt.
>
> We are using postgresql version 9.2.8 which is vulnerable. Is postgresql
> planning to release
Hi All,
Recently OpenSSL released Security Advisory. Please refer below link
http://www.openssl.org/news/secadv_20140605.txt.
We are using postgresql version 9.2.8 which is vulnerable. Is postgresql
planning to release new version which include OpenSSL 1.0.1h?
Thanks
V.S.Saravanan
On 12/06/2014 14:51, boca2608 wrote:
> Thanks Ray. But unfortunately, there is no log entry in the postgresql log
> (as in the data/pg_log folder). The log file is empty. I checked the log
> before and after the error.
OK. You may need to enable logging (though I thought the EnterpriseDB
install
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of boca2608
> Sent: Thursday, June 12, 2014 10:00 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Re: Cannot start Postgresql 9.3 as a service in Windows
> 201
Krystian Bigaj replied this in a separate email, which led to some
interesting information that I would like to share in this mailing list.
He suggested the use of the "Process Monitor" app to log the process events
during the startup of the service and look for "ACCESS DENIED" errors. Here
is wh
Thanks Ray. But unfortunately, there is no log entry in the postgresql log
(as in the data/pg_log folder). The log file is empty. I checked the log
before and after the error.
Thanks,
John
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Cannot-start-Postgresql-9-3-as
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Si Chen
Sent: Wednesday, June 11, 2014 10:44 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] what does pg_activity mean when the database is stuck?
Is there a way to configure postgresql t
> Was the database server restarted after the new version was built?
> It was not restarted - Should I do so?
Yes, otherwise the old binary will still be running.
Do also take note of Craig Ringer's email on this thread; in particular you
should always run the latest minor version, which is curr
On Thu, Jun 12, 2014 at 6:34 PM, Michael Paquier
wrote:
> On Thu, Jun 12, 2014 at 11:44 AM, Si Chen
> wrote:
>> Is there a way to configure postgresql to automatically release connections
>> that have been idle for a set amount of time?
> Not directly. However with 9.3 you could use a background
On Thu, Jun 12, 2014 at 11:44 AM, Si Chen
wrote:
> Is there a way to configure postgresql to automatically release connections
> that have been idle for a set amount of time?
Not directly. However with 9.3 you could use a background worker like this one:
https://github.com/michaelpq/pg_plugins/tre
On 14/06/12 18:06, Khangelani Gama wrote:
> On 14/06/12 17:23, Khangelani Gama wrote:
>> Hi all
> (...)
>> I then did the following:
>>
>> 1. We installed library 'xml2' (version >= 2.6.23) 2. ./configure
>> --with-libxml 3. gmake 4. gmake install
>>
>> I did not touch the database. They‘re ge
-Original Message-
From: Ian Barwick [mailto:i...@2ndquadrant.com]
Sent: Thursday, June 12, 2014 11:05 AM
To: Khangelani Gama; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postgres 9.2.4 - rebuild PostgreSQL
using --with-libxml
On 14/06/12 17:23, Khangelani Gama wrote:
> Hi all
(...
On 14/06/12 17:23, Khangelani Gama wrote:
> Hi all
(...)
> I then did the following:
>
> 1. We installed library 'xml2' (version >= 2.6.23)
> 2. ./configure --with-libxml
> 3. gmake
> 4. gmake install
>
> I did not touch the database. They‘re getting the same error. Please advise
> if there
On 06/12/2014 04:23 PM, Khangelani Gama wrote:
> 2. ./configure --with-libxml
Check your config.log to make sure it actually found libxml.
Depending on how you installed it, it might not be found by configure
without an explicit path - a --with-libxml=/path/to/libxml/install/dir
Why aren't you
*From:* pgsql-general-ow...@postgresql.org [mailto:
pgsql-general-ow...@postgresql.org] *On Behalf Of *John R Pierce
*Sent:* Thursday, June 12, 2014 10:34 AM
*To:* pgsql-general@postgresql.org
*Subject:* Re: [GENERAL] Postgres 9.2.4 - rebuild PostgreSQL using
--with-libxml
On 6/12/2014 1:23 AM,
On 6/12/2014 1:23 AM, Khangelani Gama wrote:
I then did the following:
1.We installed library 'xml2' (version >= 2.6.23)
2../configure --with-libxml
3.gmake
4.gmake install
was the previous version custom built with /no/ options ?
what OS/distribution is this on?
--
john r pierce
Hi all
I was asked by application dev to rebuild PostgreSQL with libxml because
they get the following error from the server.
WITH x(col) AS (SELECT 'ERROR_MISSING_DATA'::xml)
SELECT xpath('./status/text()', col) AS status
FROM x;
LINE 1: WITH x(col) AS (SELECT '= 2.6.23)
2. ./config
45 matches
Mail list logo
