Re: What's a reasonable maximum number for table partitions?
| От | Vick Khera |
|---|---|
| Тема | Re: What's a reasonable maximum number for table partitions? |
| Дата | |
| Msg-id | CALd+dcffktmS3x7bCgtbJvfdrkP46AtKwqxsZJ+tUJ3NVVpYJg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: What's a reasonable maximum number for table partitions? (Seref Arikan <serefarikan@kurumsalteknoloji.com>) |
| Ответы |
Re: What's a reasonable maximum number for table partitions?
|
| Список | pgsql-general |
On Fri, Feb 13, 2015 at 11:29 AM, Seref Arikan <serefarikan@kurumsalteknoloji.com> wrote:
Hi Bill,Could you point at some resource(s) that discuss inserting directly into the partition? Would it be possible to read directly from the partition as well?
When preparing your SQL statement, you just specify the partition directly like this. Here's a snippet from my code in perl.
my $msg_recipients_modulo = 100; # number of partitions
sub msg_recipients_part($) {
use integer;
my $id = shift;
my $part = $id % $msg_recipients_modulo;
return 'msg_recipients_' . sprintf('%02d',$part);
}
then in when generating sql you do
$table = msg_recipients_part($msg_id);
$sql = "SELECT FROM $table WHERE ..."
or something similar for insert/update.
В списке pgsql-general по дате отправления: