Okay, so why does wrapping the order by in a function fix it? (or not doing
a join, or doing an implicit join)
Cody Cutrer
On Wed, May 22, 2013 at 11:36 AM, Tom Lane wrote:
> Cody Cutrer writes:
> > create table test1 (id integer, sortable_name varchar);
> > create table te
name FROM users
ORDER BY sortable_name. The application code always appends
sortable_name to the select list because, depending on available
features, sortable_name might be a function call and in a GROUP BY.
Thanks for any insight,
Cody Cutrer
the bulk of the I/O to
the non-participating replica, while still doing the "critical" parts
of the backup against the master.
Cody Cutrer
On Tue, Jun 26, 2012 at 10:04 PM, Cody Cutrer wrote:
> I've got a few questions about initing a new replica. We have a
> modestly la
ad on the new master.
Thanks for any help,
Cody Cutrer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
That's awesome, thanks! Yeah, I doubt I'll do that to our production
database, but maybe I'll try it on a copy sometime down the line.
Adjusting the cost for pg_table_is_visible is working well enough so
far.
Cody Cutrer
On Wed, Mar 21, 2012 at 12:17 PM, Tom Lane wrote:
> C
e_is_visible (rel oid) cost 50;" the query planner is now
avoiding that function, and doing other filtering first. The queries
are all a few seconds now, but not multiple minutes.
Cody Cutrer
On Tue, Mar 20, 2012 at 6:06 PM, Tom Lane wrote:
> Cody Cutrer writes:
>> I've got a
o test by copying
it to a temporary table and adding the index there). My question is if
there is a way to create the index on the system table somehow for
just my database, and if not how would the developer community react
to the suggestion of adding an index to a system table in the default
pos
o test by copying
it to a temporary table and adding the index there). My question is if
there is a way to create the index on the system table somehow for
just my database, and if not how would the developer community react
to the suggestion of adding an index to a system table in the default
pos
