[PERFORM] database design for large data.

Hi, I am using postgresql for application. daily i will get more than 5,00,000 records. i have done the partitioning of the table for each month. while generating reports, i will do join on some other table with the large table it takes too much time to get the d

[PERFORM] Need Help selecting Large Data From PQSQL

Hi, I am using Postgresql 8.1 for handling large data. I am having One Parent Table and Child Table I.e.inherits from parent table. The constraint for partitioning table is date range. I have to generate monthly report, report generation query contains union with