Date: Sat, 30 Aug 2008 11:42:57 -0500From: [EMAIL PROTECTED]: [EMAIL
PROTECTED]: [ADMIN] Configure DB
Hi List, I'm working with Postgres, I'm storing spatial information, but I
have any problems when I try to acces to my data..from php, visual basic and
postgis too...This is the message erro
On Sun, 31 Aug 2008, Alvaro Herrera wrote:
Jeff Frost wrote:
I guess this isn't entirely accurate, as the above script returns 35883,
but vacuum verbose returns:
INFO: free space map contains 111435 pages in 10005 relations
Well, what this means is that not every single table has useful fr
Jeff Frost wrote:
> I guess this isn't entirely accurate, as the above script returns 35883,
> but vacuum verbose returns:
>
> INFO: free space map contains 111435 pages in 10005 relations
Well, what this means is that not every single table has useful free
space ...
--
Alvaro Herrera
Jeff Frost wrote:
> Alvaro Herrera wrote:
>> Jeff Frost wrote:
>>
>>
>>> Tom, is there an easy (or hard) way to count relations from all DBs by
>>> using the system catalogs?
>>>
>>
>> Just do a count(*) from pg_class where relkind in ('r', 't', 'i'), and
>> sum across all databases (you
