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
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,
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
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
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
> 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
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
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
