previous block
(block 40) to create block boundary, making free space?
So from these logs, this looks like this is happening at file level or
hardware level, Am I correct?
Thank you again.
- Nachiket
On Thu, May 23, 2013 at 6:22 AM, Tom Lane wrote:
> PG User writes:
> > ... Later
Hi All,
We are facing one strange problem about data file corruptions.
We have many postgres databases. At some point, one simple query on one
database started crashing back-end.
The query is
select count(*), col1 from tab1 group by col1;
After using pg_filedump (http://pgfoundry.org/projects
b garbage? Looking at the
code for enough_space(), it is almost hard to believe that a lot of time is
being spent here, but perhaps it's just getting called a LOT from
repair_frag(). I'm no stranger to hacking code if I have tothanks!
Sam
On Fri, Jan 22, 2010 at 4:06 PM, PG User 2010 wro
Hi Tom,
As always, your insight is VERY helpful. We'll try your suggestions and see
if that helps things out... Thanks!
Sam
On Fri, Jan 22, 2010 at 4:01 PM, Tom Lane wrote:
> PG User 2010 writes:
> > 1) is there any easy way to fiddle with the vacuum process so that it is
Hi there,
I originally posted these questions to the pgsql-performance mailing list,
but due to lack of response, I think that these may be more general in
nature--so I'm re-posting them here. Apologies for the cross-posting ahead
of time.
We are having real issues trying to reclaim dead blob sp
