Re: [PERFORM] Question about partitioned query behavior

2010-07-06 Thread Ranga Gopalan
artitioned query behavior > > Ranga, > > * Ranga Gopalan (ranga_gopa...@hotmail.com) wrote: > > It seems that this is an issue faced by others as well - Please see this > > link: > > http://stackoverflow.com/questions/2236776/efficient-querying-of-multi-partiti

Re: [PERFORM] Question about partitioned query behavior

2010-07-06 Thread Ranga Gopalan
Hi, It seems that this is an issue faced by others as well - Please see this link: http://stackoverflow.com/questions/2236776/efficient-querying-of-multi-partition-postgres-table Is this a known bug? Is this something that someone is working on or is there a known work around? Thanks, Ranga

[PERFORM] Question about partitioned query behavior

2010-07-02 Thread Ranga Gopalan
Hi, My question is regarding ORDER BY / LIMIT query behavior when using partitioning. I have a large table (about 100 columns, several million rows) partitioned by a column called day (which is the date stored as mmdd - say 20100502 for May 2nd 2010 etc.). Say the main table is called FA