On Wed, Apr 25, 2001 at 12:52:15PM -0400, Tom Lane wrote:
> Jan Ploski <[EMAIL PROTECTED]> writes:
> > Here, v_wutest is a view which returns two rows. Shouldn't the SUM
> > aggregate simply add these two values? To me, it looks like a bug.
>
> Does the view conta
On Wed, Apr 25, 2001 at 04:26:14PM +0200, Jan Ploski wrote:
> Hello,
>
> I have run into the following problem:
>
> workunit=> select * from v_wutest;
> estimate
> --
> 1650
> 100
> (2 rows)
>
> workunit=> select sum(estimate
> I have a database of ISO standards ... my clients want to be able to do a
> full document search ... but it's not a document ... it's a database
> Is there a way (more likely a query question) to
> select * from tablename where like '%term%'??
This query will work, but I suspect th
Hello,
Is there a way to monitor query performance on the database server level?
What I am doing now is tweaking the JDBC driver to log slow queries
(slow = taking longer than some arbitrary threshold), but it appears to
me that the db server itself should be the ideal place for such tasks.
Can
On Wed, Mar 14, 2001 at 09:09:33PM +0100, Jan Ploski wrote:
> Hi,
>
> I just checked out 7.1 from CVS and am trying to compile the JDBC driver:
yeah right, next time I configure it --with-java and it'll be fine ;-)
-JPL
---(en
Hi,
I just checked out 7.1 from CVS and am trying to compile the JDBC driver:
[javac] /home/jpl/pgsql/src/interfaces/jdbc/org/postgresql/Driver.java:199: ';'
expected
[javac] return ${major};
[javac] ^
It looks like there are (CVS?) tags in the Java source code which should
be
Hello,
When large databases, complex queries and frequent access are combined,
the database backend may become a performance bottleneck. This is quite
obvious.
Do I assume correctly that CPU will be the earliest limiting factor
for a database (if we have a reasonable amount of memory in the box)
Hi,
Thanks for all your remarks regarding 7.1's stability. I'm going to get
it running as our mail/news database backend and come back with bug
reports ;-)
Another question which comes to my mind: what would be the best way to
implement a search feature for such a database? I know that there are
