e: [PERFORM] Occupation bloc in pages of table
>
> luchot <[EMAIL PROTECTED]> writes:
> > I would want if it is possible for each pages of a table to have the
> > occupation of blocs in percentage in order to see if the page is good full
> > or not.
>
> Th
> De : "Tom Lane" <[EMAIL PROTECTED]>
> There is not any magic way of getting that information, but you could
> modify contrib/pgstattuple to produce such a report.
Thank you for you speed answer , i will try to see what i can do in
contrib/pgstattuple
Best regards,
Luc
---
e: [PERFORM] Occupation bloc in pages of table
>
> luchot <[EMAIL PROTECTED]> writes:
> > I would want if it is possible for each pages of a table to have the
> > occupation of blocs in percentage in order to see if the page is good full
> > or not.
>
> Th
Hello,
I see in the documentation that we can obtain the number of pages for a table
with the view named pg_class.
I would want if it is possible for each pages of a table to have the occupation
of blocs in percentage in order to see if the page is good full or not.
I don’t find anything in
Hello ,
I have a problem of performance with a query. I use PostgreSQL 8.1.3.
The distribution of Linux is Red Hat Enterprise Linux ES release 4 (Nahant Update 2) and the server is a bi-processor Xeon 2.4GHz with 1 Go of Ram and the size of the database files is about 60 Go.
The problem is th
Hello,
I am doing some test with differents values for the parameter maintenance_work_mem in order to
ameliorate the time for the creation of index and and the use of vacuum and analyse.
I read in the doc that this parameter is just for create index, vacuum and analyse and foreign key .
But when i
Hello everybody ,
I use PostgreSQL 8.1.3 on a bi-processor Xeon and I would know how to do to enable a parallelism for
the execution of queries. Indeed , when I analyse the use of the cpus during a query the result is that for
some minutes a cpu is used while the other not and after it is the co
