Table partitioning problem - Mailing list pgsql-performance

From Samba GUEYE
Subject Table partitioning problem
Date
Msg-id 4D764F04.7020400@intesens.com
Whole thread Raw
Responses Re: Table partitioning problem
List pgsql-performance
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 by date:

Previous
From: Andy Colson
Date:
Subject: Re: Performance issues
Next
From: Andreas Forø Tollefsen
Date:
Subject: Re: Performance issues