Hi,
> Hello everybody
>
> Does anyone user pg-pool II on real production ?
Yes, I have customers who are using pgpool-II.
> How many slave do you have? and how many size of database ?
Mostly one slave, some of them use more than one, up to four or so.
I am not sure how big their databases are
I’m familiar with both PostgreSQL and Riak (1.4, not 2.0).
I know that Riak 2.0 now offers strong consistency. Have not yet seen what that
does to performance.
Big plusses for PostgreSQL:
- you can do both relational and NOSQL tasks (the Binary JSON in the latest
PostgreSQL).
- well-tested
On Dec 29, 2014, at 5:36 PM, Mike Cardwell wrote:
> So the system I've settled with is storing both the originally supplied
> representation, *and* the lower cased punycode encoded version in a separate
> column for indexing/search. This seems really hackish to me though.
I actually do the same
On 1/5/2015 10:37 AM, xu xiut wrote:
Hello, I am looking at creating a toy project which may turn into an
actual business if I'm lucky, the ideal is generally just an exchange
for people to trade some type of asset.
I'm looking at using either PostgreSQL or Riak, and I'm wondering if
there are o
On 01/05/2015 11:27 AM, Ravi Kiran wrote:
hi,
I am going through the hashjoin algorithm in postgres. I find a function
ExecHashjoin , which is called each time a new tuple is required by the
hash join *Node.*
*
*
could someone explain what exactly node mean in postgres.
I believe a good place
hi,
I am going through the hashjoin algorithm in postgres. I find a function
ExecHashjoin , which is called each time a new tuple is required by the
hash join *Node.*
could someone explain what exactly node mean in postgres.
Thanks
tuanhoanganh wrote:
> Does anyone user pg-pool II on real production ?
> How many slave do you have? and how many size of database ?
a little bit, one client, some hundred GB. 2-3 years in production mode
without problems.
>
> I need config my old retail system to support ~ 1500 user with 100
Hello everybody
Does anyone user pg-pool II on real production ?
How many slave do you have? and how many size of database ?
I need config my old retail system to support ~ 1500 user with 1000GB over
4 years. I want to try pgpool-II but don't found real system use it.
My system use direct SQL SE
While attempting to alter a table to add a global sequence as a primary key
using the following commands:
CREATE SEQUENCE my_table_id_seq USING bdr;
ALTER TABLE my_table
ADD COLUMN id integer PRIMARY KEY NOT NULL DEFAULT
nextval('my_table_id_seq'::regclass);
I started to notice some issue
I'm still experiencing similar problems. I'm not certain what parameter you
are referring to when you say 'ehost'. Otherwise, I did want to clarify a
couple of things. I have tried several combinations, each one fails in
various ways. So ...
(1) What is the exact syntax when calling bdr_init_copy
We have been trying to load our existing database that contains local
sequences into a BDR-based database with global sequences. So, we update our
schema in the new database to USING bdr for all sequences. We make certain
all tables have a primary key. Then we dump our data from our existing
databa
On Mon, 5 Jan 2015 11:37:37 -0500
xu xiut wrote:
> Hello, I am looking at creating a toy project which may turn into an actual
> business if I'm lucky, the ideal is generally just an exchange for people
> to trade some type of asset.
>
> I'm looking at using either PostgreSQL or Riak, and I'm wo
Hello, I am looking at creating a toy project which may turn into an actual
business if I'm lucky, the ideal is generally just an exchange for people
to trade some type of asset.
I'm looking at using either PostgreSQL or Riak, and I'm wondering if there
are opinions and suggestions that someone wo
Hello!
I would like to use "pagination" in my intranet client app.
My aims:
- allow user to open and scroll large lists from query (without narrowing
the query)
- at the same time minimize time until the showing of large lists to the user
- and at the same time minimize backend-frontend t
On 05-01-2015 10:02, Michael Paquier wrote:
On Mon, Jan 5, 2015 at 6:51 PM, Edson Carlos Ericksson Richter
wrote:
Would this kind of count being recorded somewhere else?
How does the server knows that the wal_segments have been exhausted?
You should evaluate the amount of wal_keep_segments nec
Hi all.
I have a simple script for planned switchover of PostgreSQL (9.3 and 9.4)
master to one of its replicas. This script checks a lot of things before doing
it and one of them is that all data from master has been received by replica
that is going to be promoted. Right now the check is done
On Mon, Jan 5, 2015 at 6:51 PM, Edson Carlos Ericksson Richter
wrote:
> Would this kind of count being recorded somewhere else?
> How does the server knows that the wal_segments have been exhausted?
You should evaluate the amount of wal_keep_segments necessary using
the replication lag in terms of
On 05-01-2015 02:08, Michael Paquier wrote:
On Sun, Jan 4, 2015 at 1:48 AM, Edson Carlos Ericksson Richter
wrote:
How to query current segments allocation relative to "Wal keep segments" in
each master server?
What is your server version? You can have a look at
pg_stat_replication on the mast
18 matches
Mail list logo
