gt; Cc: Diehl, Jeffrey; [EMAIL PROTECTED]
> Subject: Re: [SQL] Out of free buffers... HELP!
>
>
> Diehl,
>
> > Um no, I just need a smaller problem to solve. The database worked
> > quite
> > well when the problem was half this size.
>
> > could do with 60 day
Diehl,
> Um no, I just need a smaller problem to solve. The database worked
> quite
> well when the problem was half this size.
> could do with 60 day's...!" And they are right, if it can be done...
> If it
> can't, I'll tell them and they will understand.
What I'm saying is, based on your d
MAIL PROTECTED]]
> Sent: September 19, 2001 6:36 PM
> To: Diehl, Jeffrey; 'Tom Lane'; [EMAIL PROTECTED]
> Cc: Diehl, Jeffrey; [EMAIL PROTECTED]
> Subject: Re: [SQL] Out of free buffers... HELP!
>
>
> Mike,
>
> > I recently lost a hard drive and had to re-inst
PROTECTED]
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]]
> Sent: September 20, 2001 12:56 AM
> To: Diehl, Jeffrey
> Cc: 'Haller Christoph'; [EMAIL PROTECTED]
> Subject: Re: [SQL] Out of free buffers... HELP!
>
>
> "Diehl, Jeffrey" <
"Diehl, Jeffrey" <[EMAIL PROTECTED]> writes:
> Ok, can someone explain to me why this first query might run faster than the
> second?
> select src,dst,count(dst) from data;
> select src,dst,count(*) from data;
Hmm, I'd expect the second to be marginally faster. count(*) counts the
number of rows
Mike,
> I recently lost a hard drive and had to re-install, so the PG version
> I am
> using is only about 3 weeks old. However, as I said in my original
> post, I
> have A LOT of data in this database. Brick* implies 1334 tables,
> some of
> which have 2.5M records... All told, I have about 3
"Diehl, Jeffrey" <[EMAIL PROTECTED]> writes:
> Brick* implies 1334 tables
Hmm ... I wonder if the query is somehow holding onto a buffer pin for
the last block of each successively-accessed table? Will look into it.
What -B (# of shared buffers) setting are you running the postmaster
with? Try
andia National Laboratories.
(505) 284-3137
[EMAIL PROTECTED]
> -Original Message-
> From: Haller Christoph [mailto:[EMAIL PROTECTED]]
> Sent: September 18, 2001 7:18 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: [SQL] Out of free buffers... HELP!
>
&g
EMAIL PROTECTED]
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]]
> Sent: September 18, 2001 5:26 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: [SQL] Out of free buffers... HELP!
>
>
> [EMAIL PROTECTED] (D&
Previously:
>psql ids -c 'select src,dst,count(*) from brick* where src_port=135
>group by src,dst' > /tmp/135.dat
This is just a guess, increasing the parameters shared_buffers and sort_mem
might help.
For example if your table is about 1Gb in size then try shared_buffers=1
and sort_mem
> psql ids -c 'select src,dst,count(*) from brick* where src_port=135
> group by src,dst' > /tmp/135.dat
>
> and I get:
>
> ERROR: out of free buffers: time to abort !
Does anybody knows if the buffers of pgsql are insufficient, or
the operating system cries out this error?
Regards,
Baldvin
"Diehl, Jeffrey" <[EMAIL PROTECTED]> writes:
> psql ids -c 'select src,dst,count(*) from brick* where src_port=135
> group by src,dst' > /tmp/135.dat
> and I get:
> ERROR: out of free buffers: time to abort !
Oh? What PG version is this? What is the schema you are actually
working with --- how
[EMAIL PROTECTED] (D'Arcy J.M. Cain) writes:
> Thus spake Diehl, Jeffrey
>> psql ids -c 'select src,dst,count(*) from brick* where src_port=135
>> group by src,dst' > /tmp/135.dat
> Hard to tell without knowing more but perhaps you need another table
> instead of/in addition to this one that just
Thus spake Diehl, Jeffrey
> I have a large query that I'm trying to run, but it never finishes. I
> get an error message and it quits.
>
> I'm doing:
>
> psql ids -c 'select src,dst,count(*) from brick* where src_port=135
> group by src,dst' > /tmp/135.dat
Hard to tell without knowing more but
As long as there are no nulls allowed in column 'dst' the
select src,dst,count(dst) from ...
should retrieve the same result.
Try it. It should run faster anyway.
Maybe there are other ways to word your query, but without
more knowledge about your table structure and intentions
I can't tell
Hi all.
I sent this once before, but didn't see it appear on the list... So here we
go again...
I have a large query that I'm trying to run, but it never finishes. I
get an error message and it quits.
I'm doing:
psql ids -c 'select src,dst,count(*) from brick* where src_port=135
group by src
16 matches
Mail list logo
