[PERFORM] Partitioned Tables Foreign Key Constraints Problem

Hi all, Have a problem related to partition tables. We have the following schema's : master - id integer (PRIMARY KEY) cid integer child1, child2 are the child tables of master table. Here "cid" is the field used for partitioning. We have another table called other_tbl - id integer (PRIMARY KE

Re: [PERFORM] how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence

Miernik wrote: Scott Marlowe <[EMAIL PROTECTED]> wrote: won't ever run into. Why such an incredibly limited virtual machine? Even my cell phone came with 256 meg built in two years ago. Because I don't want to spend too much money on the machine rent, and a 48 MB RAM Xen is about all I can ge

Re: [PERFORM] how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence

A Dimecres 23 Juliol 2008, Miernik va escriure: > I have a PostgreSQL database on a very low-resource Xen virtual machine, > 48 MB RAM. When two queries run at the same time, it takes longer to > complete then if run in sequence. Is there perhaps a way to install > something like a query sequencer,