Thank you, Kevin, for this detailed info. It was very helpful.
Best wishes,
-igor
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: June-06-12 12:39 PM
To: Igor Shmain; pgsql-admin@postgresql.org
Subject: RE: [ADMIN] Data split -- Creating a copy of
M
To: Igor Shmain
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Data split -- Creating a copy of database without
outage
Hi Igor,
On Tue, May 29, 2012 at 2:13 PM, Igor Shmain wrote:
I need to design a solution for a database which will grow and will require
a horizontal split at some mome
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: June-02-12 11:12 AM
To: igor.shm...@gmail.com; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Data split -- Creating a copy of database without
outage
"Igor Shmain" wrote:
> I need to design a solutio
Thank you Craig and thank you Amador for your great help!
Craig's ideas are very useful - I definitely want to look deeper into
Londiste and to use partitioning.
Amador's approach makes perfect sense to me.
Best wishes,
-igor
[mailto:liuhaif...@live.com]
Sent: May-29-12 9:13 PM
To: Igor Shmain
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Data split -- Creating a copy of database without
outage
Why not use a partitioned table? You can write a trigger to control which
partition the coming data should be insert
Can you please help with advice?
I need to design a solution for a database which will grow and will require
a horizontal split at some moment.
Here is how I am planning to do it: Every record in every table has a shard
number. After the database becomes too large (gets too many requests), the
