On 05/17/2012 03:44 PM, Clemens Eisserer wrote:
Hi,
Recently single postgres processes are killed by SIGNAL 9 on our
virtual vvmware managed server without any manual interaction -
causing lost transactions.
Any ideas what could be the reason? Could postmaster the source of the signal?
We are r
"John Watts" writes:
> I have a database query which executes normal (under 1s) with 21 steps
> according to the query paln. However, when the database is dumped and
> restored on the _same_ PostgreSQL server, the query plan takes 34 steps
> to complete and it executes in excess of 90 seconds!
Us
Hi folks,
I have a database query which executes normal (under 1s) with 21 steps
according to the query paln. However, when the database is dumped and
restored on the _same_ PostgreSQL server, the query plan takes 34 steps
to complete and it executes in excess of 90 seconds!
Why is the query pla
Hi,
Recently single postgres processes are killed by SIGNAL 9 on our
virtual vvmware managed server without any manual interaction -
causing lost transactions.
Any ideas what could be the reason? Could postmaster the source of the signal?
We are running postgreql 8.4.7 on Linux 64-bit.
Thank you
Sorry if this is a dumb question. Feel free to just point me to a doc.
I've read a little about Postgres replication and the concept of a
master and one or more slaves. If one db is down then you just switch
to one that's still running. There's even additional software like
pgpool to make the swit
On 05/17/2012 11:54 AM, leaf_yxj wrote:
I know we can know the currenct activity via pg_stat_activity. What's else
you guys use to debug.
And for some times back, how can we check the activities?
Thanks.
Grace
Performance is a complex enough issue to warrant its own mailing list
(CPU type, num
On 05/17/2012 11:30 AM, leaf_yxj wrote:
Hi Guys. Please help me about this.
For postgres database, it looks like we need analyze and vacuum all the
tables periodly. I need to write a script which can be executed in crontab.
I don't have any clues about that. I only know the command :
analyze ta
I know we can know the currenct activity via pg_stat_activity. What's else
you guys use to debug.
And for some times back, how can we check the activities?
Thanks.
Grace
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-to-debug-the-performance-issues-via-which-syste
Hi Guys. Please help me about this.
For postgres database, it looks like we need analyze and vacuum all the
tables periodly. I need to write a script which can be executed in crontab.
I don't have any clues about that. I only know the command :
analyze tablename;
vacuum tablename;
Please helps.
No change I'm afraid :(
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: 17 May 2012 22:59
To: John Watts
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] difference in query plan when db is restored
"John Watts" writes:
> I have a database query which execu
Adrian Schreyer writes:
> I am trying to compile the www_fdw foreign data wrapper on PostgreSQL
> 9.2 beta but I am getting the following error:
We changed the planner API for foreign data wrappers in 9.2, so you
won't be able to compile 9.1 FDWs until their code is updated.
Trying to reply to Rob:
Apologies if this does not end up in the thread (gmail is just driving me
mad, I can't seem to receive messages, so I've subscribed again)
For some reason Limit 1 cause my query to go on for minutes without a
response, which was not the case.
The following query takes abo
Hi all,
I am trying to compile the www_fdw foreign data wrapper on PostgreSQL
9.2 beta but I am getting the following error:
cp sql/www_fdw.sql sql/www_fdw--0.1.0.sql
gcc -g -O2 -fstack-protector --param=ssp-buffer-size=4 -Wformat
-Wformat-security -Werror=format-security -fPIC -DLINUX_OOM_ADJ=0
Yes, that was the results of our tests ...
It seems we'll have to do a lot of work on the application to separate
the queries in order to achieve the load-balancing.
Thanks anyway,
Best regards,
Paulo Correia
On 17/05/12 09:32, Sumit Raja wrote:
Unsure you can achieve this without a read on
On 05/17/2012 03:06 AM, Seref Arikan wrote:
I have a key value table in my Postgresql db, which represents
hierarchical data through parent_feature_mapping column that points to
id of feature_mapping_id column of the same table.
I need to select root nodes that has children which satisfy vario
I have a key value table in my Postgresql db, which represents hierarchical
data through parent_feature_mapping column that points to id of
feature_mapping_id column of the same table.
I need to select root nodes that has children which satisfy various
conditions. The conditions may extend to chil
Unsure you can achieve this without a read only and a read write
application set up, I've always had RW application servers separate
from RO ones.
You could disable the application connection pool completely and let
pg-pool do the pooling for you (not sure of performance impact, if
any) as the ses
17 matches
Mail list logo
