Re: Huge table pg_shdepend

Hi zuhair

Thank's for your quick response. To use pg_repack it is not an option
unfortunately, because it's not possible to install additional software
at the db server. Are there other options to do with the postgresql
onboard tools?

Regards
Horst

Am 21.01.19 um 11:33 schrieb Zuhair Khayyat:
> Hi Horst,
>
> Try pg_repack 
> http://reorg.github.io/pg_repack/
>
> On Mon, 21 Jan 2019 at 1:18 PM Horst Düster
> <horst(dot)duester(at)sourcepole(dot)ch <mailto:horst(dot)duester(at)sourcepole(dot)ch>> wrote:
>
> Hi
>
> I'm struggling with a huge table pg_shdepend. My database has a
> size of
> 640MB exclude the size of the system tables. But the real size of
> the db
> is more than 2GB. The reason is a huge table pg_shdepend with more
> than
> 32000000 records.  PgAdmin3 shows a table size of
> 1885MB and an index size of 1690MB. This looks strange for me, because
> this size is a multiple amount of the db size itself. I believe, that
> there are a lot of rubbish in that table, but I'm not sure.
>
> I had run a vacuum full process, but this didn't help. Could
> anyone give
> me an advice how to clean the table pg_shdepend or reduce the
> table size?
>
> Any hit would be appreciated.
>
> Regards
> Horst
>
> --
> Dr. Horst Düster
> Managing Director
> Sourcepole AG - Linux & Open Source Solutions
> Weberstrasse 5, 8004 Zürich, Switzerland
> <https://maps.google.com/?q=Weberstrasse+5,+8004+Z%C3%BCrich,+Switzerland&entry=gmail&source=g>
> Tel: +41 (0)44 440 77 11
> Direkt: +41 (0)44 515 67 70
> horst(dot)duester(at)sourcepole(dot)ch <mailto:horst(dot)duester(at)sourcepole(dot)ch> 
> http://www.sourcepole.ch
>
> qgiscloud.com <http://qgiscloud.com> - Karten einfach vom Desktop
> ins Netz
>
>
>
>
>
> --
> <https://www.twitter.com/lucidya><https://www.linkedin.com/company/lucidya/><https://www.facebook.com/lucidya>
> Zuhair Khayyat Chief Technology Officer Lucidya
>  +966503418330 <tel:+966503418330>  lucidya.com <http://lucidya.com>
>
>  Please consider the environment before printing this email
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager. This message contains confidential information and
> is intended only for the individual named. If you are not the named
> addressee you should not disseminate, distribute or copy this e-mail.
> Please notify the sender immediately by e-mail if you have received
> this e-mail by mistake and delete this e-mail from your system. If you
> are not the intended recipient you are notified that disclosing,
> copying, distributing or taking any action in reliance on the contents
> of this information is strictly prohibited.
>

--
Dr. Horst Düster
Managing Director
Sourcepole AG - Linux & Open Source Solutions
Weberstrasse 5, 8004 Zürich, Switzerland
Tel: +41 (0)44 440 77 11
Direkt: +41 (0)44 515 67 70
horst(dot)duester(at)sourcepole(dot)ch http://www.sourcepole.ch

qgiscloud.com - Karten einfach vom Desktop ins Netz