Re: Partitioning

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: Partitioning
Дата
Msg-id 20070110210931.GY12217@nasby.net
обсуждение исходный текст
Ответ на Re: Partitioning  ("Jeremy Haile" <jhaile@fastmail.fm>)
Ответы Re: Partitioning  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: Partitioning  ("Jeremy Haile" <jhaile@fastmail.fm>)
Список pgsql-performance
On Wed, Jan 10, 2007 at 03:28:00PM -0500, Jeremy Haile wrote:
> This seems so much more intuitive and simpler than what is required to
> set it up in PostgreSQL.  Does PostgreSQL's approach to table
> partitioning have any advantage over MySQL?  Is a "nicer" syntax planned
> for Postgres?

The focus was to get the base functionality working, and working
correctly. Another consideration is that there's multiple ways to
accomplish the partitioning; exposing the basic functionality without
enforcing a given interface provides more flexibility (ie: it appears
that you can't do list partitioning with MySQL, while you can with
PostgreSQL).
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Steven Flatt"
Дата:
Сообщение: Re: table partioning performance
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: High inserts, bulk deletes - autovacuum vs scheduled vacuum