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?  (Seref Arikan <serefarikan@kurumsalteknoloji.com>)
Список 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 по дате отправления:

Предыдущее
От: Seref Arikan
Дата:
Сообщение: Re: What's a reasonable maximum number for table partitions?
Следующее
От: Seref Arikan
Дата:
Сообщение: Re: What's a reasonable maximum number for table partitions?