Re: [GENERAL] Understanding 'could not read block'

2009-10-02 Thread Joshua D. Drake
On Thu, 2009-09-24 at 05:14 -0700, stevesub wrote: > Hi, > > I have a table of about 693 million rows (80gb) of position data (standard > object,timestamp,position,etc). > > Every time I try to build some statistics by creating a table, such as: > > create table pos_stats1 as > > select id,year,m

Re: [GENERAL] Understanding 'could not read block'

2009-09-24 Thread Tom Lane
=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= writes: > On Thu, Sep 24, 2009 at 1:14 PM, stevesub wrote: >> I get an error: >> ERROR: could not read block 8519713 of temporary file: Permission denied > try switching off any antivirus software running. The usual advice is to actually *uninstall* whateve

Re: [GENERAL] Understanding 'could not read block'

2009-09-24 Thread Grzegorz Jaƛkiewicz
On Thu, Sep 24, 2009 at 1:14 PM, stevesub wrote: > > Hi, > > I have a table of about 693 million rows (80gb) of position data (standard > object,timestamp,position,etc). > > Every time I try to build some statistics by creating a table, such as: > > create table pos_stats1 as > > select id,year,m

[GENERAL] Understanding 'could not read block'

2009-09-24 Thread stevesub
Hi, I have a table of about 693 million rows (80gb) of position data (standard object,timestamp,position,etc). Every time I try to build some statistics by creating a table, such as: > create table pos_stats1 as > select id,year,month,count(1) from positions group by id,year,month; I get an err