Make SHOW command subqueriable?
Started by Christopher Kings-Lynnealmost 22 years ago3 messages
Is this a neat idea?
SELECT * FROM (SHOW ALL);
eg.
SELECT * FROM tab WHERE character_length(f) > (SHOW block_size);
etc.
Chris
Re: Make SHOW command subqueriable?
On Fri, 16 Jan 2004, Christopher Kings-Lynne wrote:
Is this a neat idea?
SELECT * FROM (SHOW ALL);
So neat in fact that it has been implemented.
SELECT * FROM pg_settings;
Kris Jurka
Re: Make SHOW command subqueriable?
So neat in fact that it has been implemented.
SELECT * FROM pg_settings;
Damn! I knew that as well! *sigh*
I'm not thinking right from my current 'shocking postgres performance
problems nightmare day' today :(
Think massively concurrent table that almost everything on the site
relates to causing heaps of select queries to pile up and use all I/O,
getting worse, etc...
Chris