Bruce Momjian wrote:
>
> > Hi,
> >
> > I have written a small function that show how many tuples are dead
> > etc. in a specified table. Example output is:
> >
> > test=# select pgstattuple('tellers');
> > NOTICE: physical length: 0.02MB live tuples: 200 (0.01MB, 58.59%) dead tuples:
>100 (0.00
The only problem I found using it was with a user large object type used
for OLE binary large object data. Dumpall just dumped the OID of the
items, not the items themselves
There is a -b (dump data and BLOB data) option, if it exists on your
version of pg_dump (pg_dumpall passes most parameter
> On Thu, Sep 13, 2001 at 05:38:56PM +0100, Thurstan R. McDougle wrote:
> > What I am talking about is WHEN the sort is required we could make the
> > sort more efficient as inserting into a SHORT ordered list should be
> > better than building a BIG list and sorting it, then on
HACKERS: see the end of this message about a possible optimisation for
ORDER BY+LIMIT cases (the normal use of LIMIT?)
Adam wrote:
>
> I help run a job database and have a table of search records. I want
> a query that will return the top 10 jobs by search frequency. I'm
> familiar with ORDER
R Talbot wrote:
>
> Looking at the Postgresql manual in the inheritance section I see
> abbreviations.
>
> i.e.
> SELECT c.name, c.altitude
> FROM cities* c
> WHERE c.altitude > 500;
>
> c.name of course refering to cities.name
> My question is where is there an alias reference of c AS citie
