Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #14399: Order by id DESC causing bad query plan - Mailing list pgsql-bugs

From Jamie Koceniak
Subject Re: BUG #14399: Order by id DESC causing bad query plan
Date
Msg-id 40BA41BD-88B4-4CDB-8528-60E2CE5B0B34@mediamath.com
Whole thread Raw
List pgsql-bugs
Tree view 
SGkgSSB3YXMgd29uZGVyaW5nIGlmIHRoaXMgY291bGQgZ2V0IGFwcHJvdmVkIGJ5IHRoZSBtb2Rl
cmF0b3IuDQoNCk9uZSBhZGRlZCBub3RlOiBpZiBJIGFjdHVhbGx5IGRyb3AgdGhlIGluZGV4IHRo
ZW4gdGhlIHF1ZXJ5IHBsYW4gZG9lcyBhIHRvcC1OIGhlYXAgc29ydCBpbnN0ZWFkIG9mIG5lc3Rl
ZCBqb2luIGZpbHRlciBhbmQgcnVucyBpbiAyOG1zLg0KDQpTb3J0IE1ldGhvZDogdG9wLU4gaGVh
cHNvcnQgIE1lbW9yeTogOTRrQg0KDQoNClRoYW5rcyENCg0KDQoNCk9uIDEwLzI3LzE2LCA1OjE2
IFBNLCAiamtvY2VuaWFrQG1lZGlhbWF0aC5jb20iIDxqa29jZW5pYWtAbWVkaWFtYXRoLmNvbT4g
d3JvdGU6DQoNCj5UaGUgZm9sbG93aW5nIGJ1ZyBoYXMgYmVlbiBsb2dnZWQgb24gdGhlIHdlYnNp
dGU6DQo+DQo+QnVnIHJlZmVyZW5jZTogICAgICAxNDM5OQ0KPkxvZ2dlZCBieTogICAgICAgICAg
SmFtaWUgS29jZW5pYWsNCj5FbWFpbCBhZGRyZXNzOiAgICAgIGprb2Nlbmlha0BtZWRpYW1hdGgu
Y29tDQo+UG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjQuNg0KPk9wZXJhdGluZyBzeXN0ZW06ICAgTGlu
dXgNCj5EZXNjcmlwdGlvbjogICAgICAgIA0KPg0KPk9uZSB0YWJsZSBoYXMgMk0gcmVjb3JkcyAo
b3JkZXJzKSBqb2luaW5nIHRvIGFub3RoZXIgdGFibGUgd2l0aCA3NUsgcmVjb3Jkcw0KPihjdXN0
b21lcnMpLg0KPg0KPlF1ZXJ5Og0KPnNlbGVjdCAqICBGUk9NDQo+ICAgICAgICAgIG9yZGVycyB0
MQ0KPiAgICAgICAgICBKT0lOIGN1c3RvbWVyIHQyIE9OICh0MS5jdXN0b21lcl9pZCA9IHQyLmlk
KQ0KPiAgICAgICAgV0hFUkUNCj4gICAgICAgICAgdDIuaWQgSU4gKHNlbGVjdCBkaXN0aW5jdCBj
dXN0b21lcl9pZCBmcm9tIHZhbGlkX2N1c3RvbWVycykNCj4gICAgICAgIE9SREVSIEJZIHQxLmlk
ICAgICAgICAgICAgICANCj4gICAgICAgIExJTUlUIDEwIDsNCj4NCj4tLSB2YWxpZCBjdXN0b21l
cnMgc3VicXVlcnkgY29udGFpbnMgMjAwIHJlY29yZHMuDQo+DQo+Rm9yIHNvbWUgcmVhc29uIHRo
ZSBuZXN0ZWQgam9pbiBpcyBkb2luZyBmaWx0ZXI6DQo+ICAgUm93cyBSZW1vdmVkIGJ5IEpvaW4g
RmlsdGVyOiA0MTA5NzY0MTUNCj4NCj5TZWUgYW5vbnltaXplZCBxdWVyeSBwbGFuIGhlcmU6DQo+
aHR0cHM6Ly9leHBsYWluLmRlcGVzei5jb20vcy9rOXM1DQo+DQo+SWYgSSByZW1vdmVkIG9yZGVy
IGJ5LCBxdWVyeSByZXR1cm5zIGluIDEuNW1zDQo+DQo=

pgsql-bugs by date:

Previous
From: vcolborn@gmail.com
Date:
Subject: BUG #14408: Schema not found error when 2 or more indices declared on temporary table
Next
From: Tom Lane
Date:
Subject: Re: BUG #14408: Schema not found error when 2 or more indices declared on temporary table