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
Based on your criteria (I never really had thought about Thanksgiving
before, as far as when it hits), but here is a small Tcl proc that I
think will do it. You may need to add error checking. Takes the year
(i.e. 2001), and returns the day date (i.e. 22).
> 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
Not that this is the best solution, but I read in a book (SQL for smarties
I think) the following (maybe I'm wrong, but this is what I remember :)
Create a holidays table. Put in all the holidays. Do the math yourself
and just put them in there manually for the next 10 years or so (and then
rem
Hello !
TRES URGENT : N'utilisez PLUS DU TOUT Microsoft Internet Explorer pour
l'instant, à la place vous pouvez utiliser Netscape (http://www.netscape.com)
Infos peu claires : http://slashdot.org/articles/01/09/18/151203.shtml
En effet, un nouveau virus infecte des sites web, et à cause d'un
On 17 Sep 2001 14:54:51 +0200, Kovacs Baldvin wrote:
> Hi!
>
> I am in the university now, not be able to test what I
> say, so please forgive me if it is buggy or wrong.
>
> So does it helps you?:
That works correctly. Thanks very much for the tip
.
Do not forget to DROP the sequence afterwar
>
> CREATE FUNCTION my_function ( ...
>
>
> IF NOT table_exists(''my_table'') THEN
> CREATE TABLE ...
> END IF;
>
>
>
> Got the idea?
Not bad... Well, I am not the person questioned... But let me
share a few ideas about it.
The solution what I gave was a "more SQL way" of doing i
"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
I have followed
the instructions in the Bruje Momjian´s book to register afunction, and i
got this message: ERROR:/load of file /home/postgres/ctof.so
failed: /home/postgres/ctof.soELF file´s phentsize not the expected
size.What is going on? I have tried to get more documentation about how
On 17 Sep 2001, Pasha wrote:
> Hello to Every1.
> I'm trying to find if anyone knows how to find out when the stored
> procedure was used last time (not created).
I don't think there's any real way to do that apart from having your
procedure keep track of that itself.
-
[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
Hi,
I have a table which basically looks like this:
create table (userid text, val integer, ts timestamp);
This table holds multiple values for users, timestamped for history
reasons.
Now I need to fetch the latest val for each userid to insert into a new
table (with about the same schema, exc
Folks,
I'm spec'ing a calendar app for PostgreSQL, and was wondering if anyone
had already solved the following problem:
How can I calculate the dates of American holidays?
Obviously, Christmas & New Year's are easy. As is July 4.
However, Thanksgiving is the last Thursday in November, unless
Hello to Every1.
I'm trying to find if anyone knows how to find out when the stored
procedure was used last time (not created).
Thank You.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unre
On Mon, 17 Sep 2001 14:51:52 + (UTC), ke wang <[EMAIL PROTECTED]> wrote:
> Is there any command or query to see the definition of an existing table,
> like which is the primary key, which is not null etc.
>
In psql:
\d tablename
to see what the exact query is, start psql with the -E flag:
p
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
Within psql you can do commands like
\d
to learn rudimentary information about
a table.
Try this to learn more sophisticated information
select u.usename, t.typname, a.attname, a.atttypid, a.attlen, a.attnotnull, a.attnum
from pg_user u, pg_type t, pg_attribute a
where u.usesysid = t.typo
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
19 matches
Mail list logo
