Re: [SQL] Partitioning and Foreign Keys

2007-11-08 Thread Vivek Khera
On Nov 4, 2007, at 12:57 PM, Volkan YAZICI wrote: major bottleneck. I planned to partition this table, but I learnt that PostgreSQL doesn't allow referencing views. Does anybody have any suggestions? I can envision writing your own custom trigger instead of using the stock FK trigger that

[SQL] Partitioning and Foreign Keys

2007-11-04 Thread Volkan YAZICI
Hi, We have a customers database growing ~1,000 rows per day. (Nearly, %40 of the table is garbage and won't get queried that often in the future. But we keep them for statistical analysing purposes of previous jobs.) Despite table allocates relatively small size on the disk, requirement of instan