Reaching the maxPoolSize from the minPoolSize means creating the
connections at the crucial moment where the client application is in the
desperate need of completing an important query/transaction which the
primary responsibility since it cannot hold the data collected.
So here the connection cre
fsync
... taking more knowledge around this will shed some light to understand
this problem "slave ahead of master"
"there was silence, because master hang."
... replication halted here, master holds the latest copy which is missing
at both the slaves
"I decided to promote one of the slaves"
...
http://www.postgresql.org/docs/current/static/hot-standby.html#HOT-STANDBY-CAVEATS
On Fri, Oct 18, 2013 at 11:49 PM, sparikh wrote:
> Anybody has any idea, or pointer ? This is a high priority issue I have
> resolve at work. Any help would be of great help.
>
>
>
> --
> View this message in co
http://sourceforge.net/mailarchive/forum.php?forum_name=osdldbt-general&max_rows=25&style=nested&viewmonth=201104
- Sethu
On Thu, May 12, 2011 at 5:22 AM, Robert Haas wrote:
> On Tue, Apr 12, 2011 at 3:51 AM, Sethu Prasad
> wrote:
> > Anyone lucky to have dbt5
Performance, as I
have the advice earlier stating that read and write are treated same with
Fio drives.
Any suggestions on configuration changes to have read-only hot standby
faster on READs.
- Sethu
On Sun, May 8, 2011 at 11:08 AM, Simon Riggs wrote:
> On Tue, May 3, 2011 at 10:02 AM, Se
I did the hot standby configured earlier and at that time I started
using(querying) the standby database.
May be something missed on the archive command.
On Wed, May 4, 2011 at 8:44 PM, Josh Berkus wrote:
>
> > While doing so I got the "*Query failed ERROR: catalog is missing 1
> > attribute(s
B + Fusion IO Drive is not advisable?!
Regards,
Sethu Prasad. G.
Just want to share the DBT(2&5) thing
http://archives.postgresql.org/pgsql-performance/2011-04/msg00145.php
http://sourceforge.net/mailarchive/forum.php?forum_name=osdldbt-general&max_rows=25&style=nested&viewmonth=201104
On Wed, Apr 27, 2011 at 11:55 PM, Greg Smith wrote:
> Tomas Vondra wrot
Hi List,
I am using PostgreSQL 9.0.3 and I have a need to dump only the selective
data from partial list of tables of a database. Is there a straight way to
do it with pg_dump or any alternative work around to suggest here?!
Sethu Prasad. G.
You mean the maintenance instead of mentioning the recovery? If yes
The following types of administration commands are not accepted during
recovery mode:
-
* Data Definition Language (DDL) - e.g. CREATE INDEX*
-
* Privilege and Ownership - GRANT, REVOKE, REASSIGN*
-
* Mainten
Hi,
Anyone lucky to have dbt5 run for PostgreSQL 9.0.3?!
I am trying on Novell SuSE Linux Enterprise Server 11 SP1 x86_64 with a
virtual machine and bit hard with no success run yet. If you can help me
with any docs will be more of a support.
Regards,
Sethu Prasad
Also you can try to take the help of pgtune before hand.
pgfoundry.org/projects/*pgtune*/
On Mon, Apr 4, 2011 at 12:43 PM, Scott Marlowe wrote:
> On Mon, Apr 4, 2011 at 3:40 AM, Adarsh Sharma
> wrote:
> > Dear all,
> >
> > I have a Postgres database server with 16GB RAM.
> > Our application ru
12 matches
Mail list logo
