[postgis-users] evaluation tools?

[Christian Schwartze]

Check what kind of help tables were created regarding your original table 
(toast tables, toast index tables in case of variable field lengths - bytea 
or varchar types for instance) Therefor, have a look to the system table 
pg_class ...

Christian.

--------------------------------------------------
From: "Biddy" <newskatze at riomhphost.net>
Sent: Wednesday, June 02, 2010 4:28 PM
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Subject: Re: [postgis-users] evaluation tools?

> Hi Christian,
>
> thanks for the quick answer.
> My result set for that query is empty though.
>
> B.
>
> Zitat von Christian Schwartze <christian.schwartze at uni-jena.de>:
>
>>
>> Perhaps, one starting point may be:
>>
>>    select relpages from pg_class where relname='<your_table_name>_pk'
>>
>> Christian
>>
>>
>> --------------------------------------------------
>> From: "Biddy" <newskatze at riomhphost.net>
>> Sent: Wednesday, June 02, 2010 4:13 PM
>> To: <postgis-users at postgis.refractions.net>
>> Subject: [postgis-users] evaluation tools?
>>
>>> Hi everyone,
>>>
>>> I was wondering what is the best way in postgis to get 
>>> performance/benchmark infos about your database.
>>>
>>> For example, where do I find how much physical space my index takes  up 
>>> or the actual table? And how do you best record how long a  typical 
>>> query takes - let's say I let it run for a 100 times over  various 
>>> parts of the dataset from a little java program, how do I  best collect 
>>> the times it took to execute the queries?
>>>
>>> Thanks,
>>> B.
>>>
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users