| From: | darcy(at)druid(dot)net (D'Arcy J(dot)M(dot) Cain) |
|---|---|
| To: | jdiehl(at)sandia(dot)gov (Diehl Jeffrey) |
| Cc: | jdiehl(at)sandia(dot)gov (Diehl Jeffrey), pgsql-sql(at)postgresql(dot)org (''pgsql-sql(at)postgresql(dot)org' ') |
| Subject: | Re: Out of free buffers... HELP! |
| Date: | 2001-09-18 11:22:36 |
| Message-ID: | 20010918112236.2E90F1A6F@druid.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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 perhaps you need another table
instead of/in addition to this one that just tracks the counts. You
can use a trigger to increment it. If you only allow inserts this
should be easy. Deletes are easy too. Updates are a little trickier.
--
D'Arcy J.M. Cain <darcy(at){druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Haller Christoph | 2001-09-18 13:17:50 | Re: Out of free buffers... HELP! |
| Previous Message | Haller Christoph | 2001-09-18 11:19:08 | Re: How to see the definition of an existing table? |