Table partitioning problem

Поиск
Список
Период
Сортировка
Искать
От
Samba GUEYE
Тема
Table partitioning problem
Дата
Msg-id
4D764F04.7020400@intesens.com
Список
Дерево обсуждения
Table partitioning problem Samba GUEYE <samba.gueye@intesens.com>
Re: Table partitioning problem Jim Nasby <jim@nasby.net>
Re: Table partitioning problem Samba GUEYE <samba.gueye@intesens.com>
Re: Table partitioning problem Robert Haas <robertmhaas@gmail.com>
Re: Table partitioning problem Samba GUEYE <samba.gueye@intesens.com>
Re: Table partitioning problem Robert Haas <robertmhaas@gmail.com>
Re: Table partitioning problem Samba GUEYE <samba.gueye@intesens.com>
Re: Table partitioning problem Shaun Thomas <sthomas@peak6.com>
Re: Table partitioning problem Samba GUEYE <samba.gueye@intesens.com>
Re: Table partitioning problem Conor Walsh <ctw@adverb.ly>
Hello,
I have a problem with table partitioning because i have a foreign key 
applied on the partionned table and it throw a constraint violation 
error during inserts.
I saw on the manual 
(http://www.postgresql.org/docs/8.4/interactive/ddl-inherit.html caveats 
section) that it's a limitation due to postgrsql table inheritance 
select queries performance are really bad without partitionning and i'm 
looking for a workaround to this foreign key problem or another solution 
for improve performance for larges tables.

Thanks in advance for your responses

В списке pgsql-performance по дате отправления
От: Andy Colson
Дата:
Сообщение: Re: Performance issues
От: Andreas Forø Tollefsen
Дата:
Сообщение: Re: Performance issues
FAQ