Oh yeah, sorry - I forgot to comment on my environment:
-PostgreSQL 6.5.2
-RedHat 6.0
-Intel Pentium II 400mhz 160mb RAM
-Java/JDBC
On Sat, 18 Dec 1999, Andy Lewis wrote:
> This has also happened to me.
>
> I had another programmer write a query that was requesting a field from a
> table but,
This has also happened to me.
I had another programmer write a query that was requesting a field from a
table but, forgot to include the name of the table in the query. It was a
3 table query and he accidentally included a fourth table field but didn't
add the table in the clause.
I was suprised
Hi Folks,
When I write a query with a "WHERE" claused constrained by the "OR"
operator, postgresql creates the enormous pg_sorttemp~ files in
~pgsql/data/base/dbName/ that basically eat up all remaining disk space in
a matter of seconds. These files are 1.8GB+ by the time the partition is
full.
> On Fri, 17 Dec 1999, Bruce Momjian wrote:
>
> > > It would be nice for new users; I think it would make it easier
> > > for them to actually set out and do it. Many new users are
> > > of the not-so-knowledgable variety, and shell scripting isn't
> > > something they want to undertake.
> >
>
