?
--
Si Chen
Open Source Strategies, Inc.
sic...@opensourcestrategies.com
http://www.OpenSourceStrategies.com
LinkedIn: http://www.linkedin.com/in/opentaps
Twitter: http://twitter.com/opentaps
, is there any way to see what it's
trying to commit?
On Wed, Jun 11, 2014 at 9:29 AM, Jeff Janes wrote:
> On Wed, Jun 11, 2014 at 8:59 AM, Si Chen
> wrote:
>
>> I have a problem where postgresql 9.3 got stuck, and the number of
>> postgresql processes increase
The state is "idle". I don't have the state_change, but I will try to
collect it if it happens again.
On Wed, Jun 11, 2014 at 1:46 PM, Igor Neyman wrote:
> From: pgsql-general-ow...@postgresql.org [mailto:
> pgsql-general-ow...@postgresql.org] On Behalf Of Si Chen
>
Is there a way to configure postgresql to automatically release connections
that have been idle for a set amount of time?
On Wed, Jun 11, 2014 at 3:41 PM, Merlin Moncure wrote:
> On Wed, Jun 11, 2014 at 5:37 PM, Si Chen
> wrote:
> > The state is "idle". I don't h
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: Wednes
ging?
On Thu, Jun 12, 2014 at 4:55 PM, John R Pierce wrote:
> 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 po
I'm using Postgresql 9.0, and my pg_stat_activity.query seems to always be
showing when no query is being run.
Is there a way for it to show the last query, even if it was run a while
ago?
--
Si Chen
Open Source Strategies, Inc.
twitter.com/opentaps
Unify social, email, and bus
one |
state_change | timestamp with time zone |
waiting | boolean |
state| text |
query| text |
So which one is correct? Why does 9.0.13 show the processes as idle, and
9.2.6 show a query, even though
Thanks! That's very helpful and answers my question.
On Mon, Mar 31, 2014 at 12:52 PM, David Johnston wrote:
> Si Chen-2 wrote
> > I have two different postgresql servers running slightly [different]
> > versions.
>
> Versions 9.0 and 9.2 are NOT slightly diffe
s executing -- just 38 threads total. Is it possible that the table
is corrupted or needs repair?
--
Si Chen
Open Source Strategies, Inc.
sic...@opensourcestrategies.com
http://www.OpenSourceStrategies.com
LinkedIn: http://www.linkedin.com/in/opentaps
Twitter: http://twitter.com/opentaps
hey both be trying to update the same row, resulting in a deadlock?
>
>
>
> *From:* pgsql-general-ow...@postgresql.org [mailto:
> pgsql-general-ow...@postgresql.org] *On Behalf Of *Si Chen
> *Sent:* Tuesday, April 01, 2014 3:51 PM
> *To:* pgsql-general@postgresql.org
> *Sub
, Apr 1, 2014 at 1:10 PM, Igor Neyman wrote:
>
>
> From: pgsql-general-ow...@postgresql.org [mailto:
> pgsql-general-ow...@postgresql.org] On Behalf Of Si Chen
> Sent: Tuesday, April 01, 2014 3:51 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] simple update
gsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Si Chen
Open Source Strategies, Inc.
sic...@opensourcestrategies.com
http://www.OpenSourceStrategies.com
LinkedIn: http://www.linkedin.com/in/opentaps
Twitter: http://twitter.com/opentaps
he biggest advantage of version 8.0 is being able to run
in Windows.
Is that true?
Thanks,
Si Chen
---(end of broadcast)---
TIP 8: explain analyze is your friend
tibilities/modifications to databases from the earlier veresion
required?
(I am running RHEL3.)
Si Chen
Tom Lane wrote:
Si Chen <[EMAIL PROTECTED]> writes:
I read the PostgreSQL 8.0 "What's New" page
(http://www.postgresql.org/docs/whatsnew) and wasn't sure whether
versi
, with Linux it was possible to improve performance by increasing
the amount of shared memory in /etc/shmmax
(http://www.phpbuilder.com/columns/smith20010821.php3). Does this need
to be done in Windows?
Thanks!
Si Chen
---(end of broadcast)---
TIP 8
estions or comments about the survey, please email me
at [EMAIL PROTECTED]
Thank you!
Si Chen
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Hello everyone. I am trying to do an ALTER TABLE, but it hangs
indefinitely. I think the table is locked from a transaction, and in
pg_locks I found:
relation 75907
database 74861
pid 29604
mode AccessExclusiveLock
granted f
Is there a way to release this lock? Or does the database need to
Thanks, Michael, for the input. Is there anyway in PostgreSQL to force
some transactions to close (rollback if necessary)? I notice there is no
way to release a LOCK manually.
Si
Michael Fuhr wrote:
On Mon, Jan 31, 2005 at 10:13:26AM -0800, Si Chen wrote:
Hello everyone. I am trying to do
s) in
the transaction?
Thanks,
Si
Michael Fuhr wrote:
On Mon, Jan 31, 2005 at 11:43:45AM -0800, Si Chen wrote:
Thanks, Michael, for the input. Is there anyway in PostgreSQL to force
some transactions to close (rollback if necessary)? I notice there is no
way to release a LOCK manually.
it.
Si
Michael Fuhr wrote:
On Tue, Feb 01, 2005 at 10:53:11AM -0800, Si Chen wrote:
I would like to track down what in the application is causing the
deadlock,
Are you sure you understand what "deadlock" means? Deadlock occurs,
for example, when connection A holds a lock that
Hello everyone.
Are there any recommended ways for doing postgresql replication?
Si Chen
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
22 matches
Mail list logo
