Re: Unable to Vacuum Large Defragmented Table

Pavel, On Mon, Apr 8, 2019 at 8:29 AM Pavel Stehule wrote: > > > po 8. 4. 2019 v 17:22 odesílatel Igal Sapir napsal: > >> Pavel, >> >> On Sun, Apr 7, 2019 at 11:22 PM Pavel Stehule >> wrote: >> >>> >>> po 8. 4. 2019 v 7:57 odesílatel Igal Sapir napsal: >>> David, On Sun, Apr

Re: Unable to Vacuum Large Defragmented Table

Pavel, On Sun, Apr 7, 2019 at 11:22 PM Pavel Stehule wrote: > > po 8. 4. 2019 v 7:57 odesílatel Igal Sapir napsal: > >> David, >> >> On Sun, Apr 7, 2019 at 8:11 PM David Rowley >> wrote: >> >>> On Mon, 8 Apr 2019 at 14:57, Igal Sapir wrote: >>> > However, I have now deleted about 50,000 rows

Re: Unable to Vacuum Large Defragmented Table

po 8. 4. 2019 v 17:22 odesílatel Igal Sapir napsal: > Pavel, > > On Sun, Apr 7, 2019 at 11:22 PM Pavel Stehule > wrote: > >> >> po 8. 4. 2019 v 7:57 odesílatel Igal Sapir napsal: >> >>> David, >>> >>> On Sun, Apr 7, 2019 at 8:11 PM David Rowley < >>> david.row...@2ndquadrant.com> wrote: >>>

Re: Unable to Vacuum Large Defragmented Table

po 8. 4. 2019 v 7:57 odesílatel Igal Sapir napsal: > David, > > On Sun, Apr 7, 2019 at 8:11 PM David Rowley > wrote: > >> On Mon, 8 Apr 2019 at 14:57, Igal Sapir wrote: >> > However, I have now deleted about 50,000 rows more and the table has >> only 119,688 rows. The pg_relation_size() still

Re: Unable to Vacuum Large Defragmented Table

David, On Sun, Apr 7, 2019 at 8:11 PM David Rowley wrote: > On Mon, 8 Apr 2019 at 14:57, Igal Sapir wrote: > > However, I have now deleted about 50,000 rows more and the table has > only 119,688 rows. The pg_relation_size() still shows 31MB and > pg_total_relation_size() still shows 84GB. > >

Re: Unable to Vacuum Large Defragmented Table

On Mon, 8 Apr 2019 at 14:57, Igal Sapir wrote: > However, I have now deleted about 50,000 rows more and the table has only > 119,688 rows. The pg_relation_size() still shows 31MB and > pg_total_relation_size() still shows 84GB. > > It doesn't make sense that after deleting about 30% of the

Re: Unable to Vacuum Large Defragmented Table

David, On Sun, Apr 7, 2019 at 7:28 PM David Rowley wrote: > On Mon, 8 Apr 2019 at 14:19, Igal Sapir wrote: > > > > On Sun, Apr 7, 2019 at 6:20 PM David Rowley < > david.row...@2ndquadrant.com> wrote: > >> > >> On Mon, 8 Apr 2019 at 10:09, Igal Sapir wrote: > >> > > >> > I have a table for

Re: Unable to Vacuum Large Defragmented Table

On Mon, 8 Apr 2019 at 14:19, Igal Sapir wrote: > > On Sun, Apr 7, 2019 at 6:20 PM David Rowley > wrote: >> >> On Mon, 8 Apr 2019 at 10:09, Igal Sapir wrote: >> > >> > I have a table for which pg_relation_size() shows only 31MB, but >> > pg_total_relation_size() shows a whopping 84GB. >> > >>

Re: Unable to Vacuum Large Defragmented Table

David, On Sun, Apr 7, 2019 at 6:20 PM David Rowley wrote: > On Mon, 8 Apr 2019 at 10:09, Igal Sapir wrote: > > > > I have a table for which pg_relation_size() shows only 31MB, but > pg_total_relation_size() shows a whopping 84GB. > > > > The database engine is running inside a Docker

Re: Unable to Vacuum Large Defragmented Table

On Mon, 8 Apr 2019 at 10:09, Igal Sapir wrote: > > I have a table for which pg_relation_size() shows only 31MB, but > pg_total_relation_size() shows a whopping 84GB. > > The database engine is running inside a Docker container, with the data > mounted as a volume from a partition on the host's

Re: Unable to Vacuum Large Defragmented Table

On 4/7/19 3:08 PM, Igal Sapir wrote: I have a table for which pg_relation_size() shows only 31MB, but pg_total_relation_size() shows a whopping 84GB. What does: pg_indexes_size() show. Also how many indexes are on the table? The database engine is running inside a Docker container, with

Unable to Vacuum Large Defragmented Table

I have a table for which pg_relation_size() shows only 31MB, but pg_total_relation_size() shows a whopping 84GB. The database engine is running inside a Docker container, with the data mounted as a volume from a partition on the host's file system. When I try to run `VACUUM FULL`, the disk usage