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
=?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
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
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