Re: Huge memory consumption during vacuum (v.8.0)
From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc:
Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Huge memory consumption during vacuum (v.8.0)
Date:
2005-02-01 21:26:02
Message-ID:
19089.1107293162@sss.pgh.pa.us (view raw or flat )
Thread:
2005-01-30 06:14:06 from Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
2005-01-30 06:51:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-01-30 06:58:19 from Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
2005-01-30 07:04:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-01-30 07:10:34 from Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
2005-01-30 07:23:53 from Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
2005-02-01 20:11:15 from Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
2005-02-01 21:26:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-02-01 21:30:37 from Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
2005-02-02 07:27:02 from Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Lists:
pgsql-hackers
Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> writes:
> I see that pgsql_tmp/ contains files, looks like clustered table.
> What postmaster is doing if disk usage doesn't changed ?
Most likely doing a disk-based merge sort ...
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Oleg BartunovDate: 2005-02-01 21:30:37
Subject : Re: Huge memory consumption during vacuum (v.8.0)
Previous :From : Tom LaneDate : 2005-02-01 21:23:56
Subject : Re: FunctionCallN improvement.