Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
- From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
- To: Luke Lonergan <llonergan(at)greenplum(dot)com>
- Cc: Gregory Stark <stark(at)enterprisedb(dot)com>, Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, Anton <anton200(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
- Subject: Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
- Date: Tue, 30 Oct 2007 18:46:22 +1300
Luke Lonergan wrote:
Sure - it's here: http://momjian.us/mhonarc/patches_hold/msg00381.html
To clarify - we've fixed this in Greenplum db - the patch as submitted is (hopefully) a hint about how to fix it in Postgres, rather than a working patch... as its full of non-postgres functions and macros:
CdbPathLocus_MakeHashed cdbpathlocus_pull_above_projection cdbpullup_findPathKeyItemInTargetList cdbpullup_makeVar cdbpullup_expr Cheers Mark
- Follow-Ups:
- Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
- From: Luke Lonergan
- Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
- From: Gregory Stark
- Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
- References:
- Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
- From: Luke Lonergan
- Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
- Prev by Date: Re: Suggestions on an update query
- Next by Date: Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
- Previous by thread: Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
- Next by thread: Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
- Indexes: