El lun, 12-09-2016 a las 20:00 +0200, Poul Kristensen escribió: > > Thanks a lot. > > How to size HW resources on a physical server for PG95+? Please create a new thread and try to avoid mixing subjects > > What does PG95+ like? Cpu? L1(expensive I think) 2 or 3 cache level?. > RAM? > > Any idea? > > Thanks > > Poul > > > > 2016-09-12 13:56 GMT+02:00 Tom Lane <tgl@xxxxxxxxxxxxx>: > > hubert depesz lubaczewski <depesz@xxxxxxxxxx> writes: > > > \df gives you list of user functions. you can add more > > parameters, to > > > limit/extend the list. > > > like: > > > \df pg_* > > > will list all functions (including system one) that start with > > pg_ > > > \dfS > > > will list all system functions > > > \df+ *xlog* > > > will list all functions (including system) that contain "xlog" in > > their > > > name, with some additional columns, which include "description" - > > one > > > line info about the function. > > > > Also, you can make your own queries on pg_proc, which is all that > > psql is > > doing here. A nice abbreviated form is > > > > select oid::regprocedure, obj_description(oid, 'pg_proc') from > > pg_proc; > > > > which gives you just the name, arg types, and comment for each row. > > > > Keep in mind that > > > > 1. This will show you an awful lot of stuff that's not meant to be > > called > > directly from SQL, eg I/O functions, operator implementation > > functions, > > aggregate support functions, cast functions, index support > > functions. > > I count 2831 rows in pg_proc in a virgin installation as of HEAD, > > and > > probably not even 1000 of them are really meant to be called as > > functions > > in ordinary queries. > > > > 2. This will not show you some things that look like functions but > > are > > implemented by special grammar productions. For that you'd have to > > look into src/backend/parser/gram.y. > > > > regards, tom lane > > > > > -- > Med venlig hilsen / Best regards > Poul Kristensen > Linux-OS/Virtualizationexpert and Oracle DBA -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
