Hi,
Recently we upgraded our production server RAM from 7.5GB to 15GB for the
following reasons:
1. to solve performance issues
2. the number of concurrent users increased from 150 to 300
Our production server is not a dedicated database server and is being shared
with our other
Hi,
we are contemplating the possibilities for a Postgres HA installation.
As the rollout is targeted towards the end of the year, 9.0 and it's new
features might be an option for us.
Now from a HA point of view, what is the major difference between 9.0's Hot
Standby and 8.x's Warm Standby?
You can use
select client_addr, current_query from pg_stat_activity;
to show all db-connection and the running queries.
Regards,
murphy
Von: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org]
Im Auftrag von VĂtor
Gesendet: Freitag, 2. Juli 2010 14:10
An:
Gnanakumar gna...@zoniac.com wrote:
max_connection
From - 500
To - 500
PGPOOL configuration
-
num_init_children
From - 150
To - 420
child_max_connections
From - 20
To - 30
We have more than 300 Users accessing our server
Hello everyone,
We had a problem with one of our servers and had noticed that the
postgres/8.3/main folder had become quite large (650mb).
PostgreSQL confirmed this via a query but when I queried the size of the
tables I was barely reaching 3mb.
After looking around, I found one file with about
Hi,
Recently we upgraded our production server from 7.5GB RAM to 15GB RAM.
1. To solve performance issue.
2. Also the number of concurrent users increased from 150 to 300.
Our production server is not dedicated server. We have also
1. Tomcat
2. Apache
3. Cron based
On Fri, Jul 9, 2010 at 7:31 AM, Henry, Frank frank.he...@barco.com wrote:
Hello everyone,
We had a problem with one of our servers and had noticed that the
postgres/8.3/main folder had become quite large (650mb).
PostgreSQL confirmed this via a query but when I queried the size of the
tables
Scott Marlowe scott.marl...@gmail.com writes:
On Fri, Jul 9, 2010 at 7:31 AM, Henry, Frank frank.he...@barco.com wrote:
What is it?
Why don't you tell us?
The exact name of the file might be useful information, too.
regards, tom lane
--
Sent via pgsql-admin mailing
On Fri, Jul 9, 2010 at 4:51 AM, Thomas Kellerer spam_ea...@gmx.net wrote:
Hi,
we are contemplating the possibilities for a Postgres HA installation.
As the rollout is targeted towards the end of the year, 9.0 and it's new
features might be an option for us.
Now from a HA point of view,
Hi,
Rob Wultsch wrote on 09.07.2010 18:14:
I am aware that I can use the 9.0 standby server for read only queries, but
that is (currently) not something we need
Taking SQL backups without impacting the master might be something to consider.
Interesting point. Thanks for mentioning that.
Thomas Kellerer spam_ea...@gmx.net wrote:
So my assumption is correct that streaming replication does mean
that in case of a failover less transactions are lost?
Yes, that is correct.
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your
On Fri, 2010-07-09 at 18:31 +0200, Thomas Kellerer wrote:
Hi,
Rob Wultsch wrote on 09.07.2010 18:14:
I am aware that I can use the 9.0 standby server for read only queries, but
that is (currently) not something we need
Taking SQL backups without impacting the master might be
Since the topic is very relevant to me right now I would like to ask if anyone
is running a HA solution in the cloud?
Thanks,
Kasia
-Original Message-
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Brad Nicholson
Sent: Friday, July 09,
On Wed, Jul 7, 2010 at 9:49 AM, Rob Richardson
rob.richard...@rad-con.comwrote:
I wanted to try using the ODBC driver for PostgreSQL 8.4. But when I
installed it, I was surprised and dismayed to see that the old driver no
longer appeared in the list of available drivers when I tried to
On Fri, 2010-07-09 at 15:31 +0200, Henry, Frank wrote:
Hello everyone,
We had a problem with one of our servers and had noticed that the
postgres/8.3/main folder had become quite large (650mb).
PostgreSQL confirmed this via a query but when I queried the size of the
tables I was barely
On Fri, Jul 9, 2010 at 7:31 AM, Henry, Frank frank.he...@barco.com wrote:
Hello everyone,
We had a problem with one of our servers and had noticed that the
postgres/8.3/main folder had become quite large (650mb).
PostgreSQL confirmed this via a query but when I queried the size of the
tables
On Fri, 2010-07-09 at 10:25 -0700, Kasia Tuszynska wrote:
Since the topic is very relevant to me right now I would like to ask if
anyone is running a HA solution in the cloud?
While running databases in a cloud does come with it's own set of
issues/challenges, I don't see what would be
17 matches
Mail list logo