Hi,
I am working on a POC of setting up PGPOOL with postgresql for failover and
recovery.
Everything is working fine but I am observing huge performance delay with
transaction.
Following is my setup..
PGPOOL : Running on separate Amazon Instance (Used for fail-over and
recovery[No loa balancing
On Wed, 2012-02-01 at 10:51 +, Kieran McCusker wrote:
> Sorry
>
> A slip of the mind - I'm actually using 1.14.1 - I had just checked the
> development log before sending to see if a fix or problem was reported
> in 14.2.
>
OK.
> I'm not sure what you mean by "This kind of trigger shouldn't
Sorry
A slip of the mind - I'm actually using 1.14.1 - I had just checked the
development log before sending to see if a fix or problem was reported
in 14.2.
I'm not sure what you mean by "This kind of trigger shouldn't be
displayed. It's fixed in the source code, but not yet available to the
gen
Hi,
On Wed, 2012-02-01 at 10:28 +, Kieran McCusker wrote:
> [...]
> I've noticed the performance of version 14.2 is very slow when clicking
> on tables.
>
If by 14.2, you mean 1.14 beta 2, you first need to upgrade to 1.14.1.
Don't use a beta release when the stable one is released.
> ~3 se
Hi
I've noticed the performance of version 14.2 is very slow when clicking
on tables.
~3 seconds for V14.2.
Looking at the logs I see the following:-
SELECT pr.oid, pr.xmin, pr.*, format_type(TYP.oid, NULL) AS typname,
typns.nspname AS typnsp, lanname, proargnames,
pg_get_expr(proargdefaults, '
On Thu, Jun 2, 2011 at 11:29 AM, Dave Page wrote:
> On Thu, Jun 2, 2011 at 9:46 AM, Kieran McCusker
> wrote:
>> If we cannot go back to lazy loading these tabs would it be possible to
>> disable or hide these tabs and the corresponding querys in File ->
>> Options (similar to the browser tab or m
On Thu, Jun 2, 2011 at 9:46 AM, Kieran McCusker
wrote:
> If we cannot go back to lazy loading these tabs would it be possible to
> disable or hide these tabs and the corresponding querys in File ->
> Options (similar to the browser tab or maybe a general "simple mode"
> type idea).
I'll look into
Hi
Thanks for the response. I take your point, but for ourselves where we
have ~6000 tables and almost 700 schemas speed is important. Our staff
have never looked (and never needed to) at the information in the
Statistics, Dependencies and Dependents tabs so the loss in performance
is not balanced
On 05/17/2011 01:00 PM, Kieran McCusker wrote:
> [...]
> I've noticed the performance of version 14 is noticeably worse than
> version 12 when clicking on tables.
>
> ~0.1 seconds for V12 comapared to ~0.5 seconds in V14.
>
> Looking at the logs I see that the details for all the tabs are selecte
Hi
I've noticed the performance of version 14 is noticeably worse than
version 12 when clicking on tables.
~0.1 seconds for V12 comapared to ~0.5 seconds in V14.
Looking at the logs I see that the details for all the tabs are selected
by V14 but in V12 only the details for the current tab of
Le 11/05/2010 08:34, venu madhav a écrit :
> Hi all,
> In my database application, I've a table whose records can reach 10M
> and insertions can happen at a faster rate like 100 insertions per second in
> the peak times. I configured postgres to do auto vacuum on hourly basis. I
> have fronte
Hi all,
In my database application, I've a table whose records can reach 10M
and insertions can happen at a faster rate like 100 insertions per second in
the peak times. I configured postgres to do auto vacuum on hourly basis. I
have frontend GUI application in CGI which displays the data fro
On Wed, Jun 3, 2009 at 3:27 PM, Kieran McCusker
wrote:
> Hi
>
> Could I raise a small performance issue with 1.10.
>
> When I click on a table in the object browser in my big database (5004 views
> and tables, 260 schemas, 211,493 columns) there is a noticable lag before
> the SQL pane refreshes.
Hi
Could I raise a small performance issue with 1.10.
When I click on a table in the object browser in my big database (5004
views and tables, 260 schemas, 211,493 columns) there is a noticable lag
before the SQL pane refreshes. Enabling debugging show the following for
the first query
2009
14 matches
Mail list logo
