* Tom Lane (t...@sss.pgh.pa.us) wrote:
Even if we thought the functionality was worth the trouble, which I
continue to doubt, this particular syntax proposal is a disaster.
Agreed. While there might be things worthwhile to add to psql's
backslash commands, this isn't one of those.
On Sun, Jul 21, 2013 at 12:47 AM, Pavel Stehule pavel.steh...@gmail.com wrote:
Hello all
I very often use a little bit adjusted psql system queries to
detection TOP N sized tables. I am thinking so it can be useful for
all users
I propose a few new commands
\dts [N|size] ... show N
2013/7/22 Robert Haas robertmh...@gmail.com:
On Sun, Jul 21, 2013 at 12:47 AM, Pavel Stehule pavel.steh...@gmail.com
wrote:
Hello all
I very often use a little bit adjusted psql system queries to
detection TOP N sized tables. I am thinking so it can be useful for
all users
I propose a
On Mon, Jul 22, 2013 at 2:03 PM, Robert Haas robertmh...@gmail.com wrote:
On Sun, Jul 21, 2013 at 12:47 AM, Pavel Stehule pavel.steh...@gmail.com
wrote:
Hello all
I very often use a little bit adjusted psql system queries to
detection TOP N sized tables. I am thinking so it can be useful
On Mon, Jul 22, 2013 at 3:13 PM, Merlin Moncure mmonc...@gmail.com wrote:
On Mon, Jul 22, 2013 at 2:03 PM, Robert Haas robertmh...@gmail.com wrote:
On Sun, Jul 21, 2013 at 12:47 AM, Pavel Stehule pavel.steh...@gmail.com
wrote:
Hello all
I very often use a little bit adjusted psql system
2013/7/22 Merlin Moncure mmonc...@gmail.com:
On Mon, Jul 22, 2013 at 2:03 PM, Robert Haas robertmh...@gmail.com wrote:
On Sun, Jul 21, 2013 at 12:47 AM, Pavel Stehule pavel.steh...@gmail.com
wrote:
Hello all
I very often use a little bit adjusted psql system queries to
detection TOP N
On 07/22/2013 03:11 PM, Pavel Stehule wrote:
2013/7/22 Robert Haas robertmh...@gmail.com:
Rather than just continuing to add more imposible-to-remember syntax,
we really need a better design here.
do you have any tip?
I agree with Robert. My tip is this: when you're in a hole, the first
On Mon, Jul 22, 2013 at 12:40 PM, Andrew Dunstan and...@dunslane.net wrote:
On 07/22/2013 03:11 PM, Pavel Stehule wrote:
2013/7/22 Robert Haas robertmh...@gmail.com:
Rather than just continuing to add more imposible-to-remember syntax,
we really need a better design here.
do you have any
Pavel Stehule pavel.steh...@gmail.com writes:
SELECT * from top5();
$ TABLE top5; -- add a view on top of the SRF
you cannot use parameters - then I have to have prepared files like
top10, top20, ... what is not too friendly
The SRF could be using custom GUCs so that you can parametrize
On Mon, Jul 22, 2013 at 02:44:59PM -0700, Dimitri Fontaine wrote:
Pavel Stehule pavel.steh...@gmail.com writes:
SELECT * from top5();
$ TABLE top5; -- add a view on top of the SRF
you cannot use parameters - then I have to have prepared files like
top10, top20, ... what is not too
On Mon, Jul 22, 2013 at 03:55:33PM -0700, David Fetter wrote:
On Mon, Jul 22, 2013 at 02:44:59PM -0700, Dimitri Fontaine wrote:
Pavel Stehule pavel.steh...@gmail.com writes:
SELECT * from top5();
$ TABLE top5; -- add a view on top of the SRF
you cannot use parameters - then I
Jeff Janes jeff.ja...@gmail.com writes:
Is looking for the biggest tables a common enough thing that it should
be available to everyone, without needing custom customization?
I don't really think so. It's surely not much harder than
select relname, pg_relation_size(oid) from pg_class
On 07/22/2013 04:26 PM, Jeff Janes wrote:
On Mon, Jul 22, 2013 at 12:40 PM, Andrew Dunstan and...@dunslane.net wrote:
On 07/22/2013 03:11 PM, Pavel Stehule wrote:
2013/7/22 Robert Haas robertmh...@gmail.com:
Rather than just continuing to add more imposible-to-remember syntax,
we really
I agree with Robert. My tip is this: when you're in a hole, the first thing
to do is to stop digging.
I don't think that Pavel believes himself to be in a hole.
After setting up my .psqlrc file as I normally do, I could do this:
:rtsize limit 10;
But it doesn't have the 'MB' feature, and
2013/7/23 Tom Lane t...@sss.pgh.pa.us:
Jeff Janes jeff.ja...@gmail.com writes:
Is looking for the biggest tables a common enough thing that it should
be available to everyone, without needing custom customization?
I don't really think so. It's surely not much harder than
select
2013/7/22 Dimitri Fontaine dimi...@2ndquadrant.fr:
Pavel Stehule pavel.steh...@gmail.com writes:
SELECT * from top5();
$ TABLE top5; -- add a view on top of the SRF
you cannot use parameters - then I have to have prepared files like
top10, top20, ... what is not too friendly
The SRF
2013/7/23 Pavel Stehule pavel.steh...@gmail.com:
2013/7/22 Dimitri Fontaine dimi...@2ndquadrant.fr:
Pavel Stehule pavel.steh...@gmail.com writes:
SELECT * from top5();
$ TABLE top5; -- add a view on top of the SRF
you cannot use parameters - then I have to have prepared files like
Robert Haas robertmh...@gmail.com writes:
On Sun, Jul 21, 2013 at 12:47 AM, Pavel Stehule pavel.steh...@gmail.com
wrote:
I propose a few new commands
\dts [N|size] ... show N largest tables | show tables larger than size
ordered by size
\dis [N|size] ... show N largest indexes | show
2013/7/23 Tom Lane t...@sss.pgh.pa.us:
Robert Haas robertmh...@gmail.com writes:
On Sun, Jul 21, 2013 at 12:47 AM, Pavel Stehule pavel.steh...@gmail.com
wrote:
I propose a few new commands
\dts [N|size] ... show N largest tables | show tables larger than size
ordered by size
\dis [N|size]
19 matches
Mail list logo