Re: [HACKERS] Make SHOW command subqueriable?

2004-01-15 Thread Christopher Kings-Lynne 
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

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
 joining column's datatypes do not match

Re: [HACKERS] Make SHOW command subqueriable?

2004-01-15 Thread Kris Jurka 


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



---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

[HACKERS] Make SHOW command subqueriable?

2004-01-15 Thread Christopher Kings-Lynne 
Is this a neat idea?

SELECT * FROM (SHOW ALL);

eg.

SELECT * FROM tab WHERE character_length(f) > (SHOW block_size);

etc.

Chris

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
 joining column's datatypes do not match