RE: PG 9.5 2 tables same DDL with diff size

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: RE: PG 9.5 2 tables same DDL with diff size
From: Isabella Ghiurea <isabella.ghiurea@xxxxxxxxxxxxxx>
Date: Wed, 10 Jan 2018 08:48:16 -0700 (MST)
In-reply-to: <BL2PR17MB0897AB4A9B93B23BE1921F09DA110@BL2PR17MB0897.namprd17.prod.outlook.com>
References: <20b07dd9-ab4e-5d48-6fbd-66e1d9161524@nrc-cnrc.gc.ca> <BL2PR17MB0897AB4A9B93B23BE1921F09DA110@BL2PR17MB0897.namprd17.prod.outlook.com>

I run full vacuum and reindex on largest table (50GB) while there was no
server activities  so I assume no transaction was holding a lock on table
since the full vacuum was able to run, anything where I should consider
looking ?



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html

Follow-Ups:
- RE: PG 9.5 2 tables same DDL with diff size
  - From: Igor Neyman

References:
- PG 9.5 2 tables same DDL with diff size
  - From: ghiureai
- RE: PG 9.5 2 tables same DDL with diff size
  - From: Igor Neyman

Prev by Date: RE: PG 9.5 2 tables same DDL with diff size
Next by Date: RE: PG 9.5 2 tables same DDL with diff size
Previous by thread: RE: PG 9.5 2 tables same DDL with diff size
Next by thread: RE: PG 9.5 2 tables same DDL with diff size
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux