On Tuesday 11 May 2004 09:44 am, Bruce Momjian wrote:
[snip]
> > > > Bruce Momjian kirjutas E, 10.05.2004 kell 06:58:
> > > > > Added to TODO:
> > > > >
> > > > > * Add MERGE command that does UPDATE, or on failure, INSERT
> > > >
[snip]
Hello all.
I have been lurking here for a bit and the
Hello,
Andrew Kopciuch has submit new version of his "Introduction to tsearch2",
which is available from
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html
He added explanation of how to backup and restore databases that
features tsearch2.
Regards,
Hello,
new version of contrib/pg_trgm (former trgm) is available for
download from http://www.sai.msu.su/~megera/postgres/gist/pg_trgm
One bug was fixed, upgrade is simple, no index rebuilding is required.
contrib/pg_trgm module provides fuzzy search with GiST index support
based on trigram stat
I have 2 query that differ only for order by clause.
The time of execution of the two query is a lot of different.
1) explain analyze
select
tkstore.gruppo,tkstore.cassa,enabledcodes.sala,spettacoli.code
from
tkstore,enabledcodes,spettacoli
where
We had a power failure (and a UPS failure) on our database machine. It's
back up now but some spooky stuff is happening. Here's an example:
(Names changed to protect the guilty.) First, the table:
---
CREATE TABLE foo
(
id SERIAL PRIMARY KEY,
barINT NOT NULL REFERENCES b
Thanks for all your comments.
Is it really true that the sequences in the tables in the Slaves will not be
in sync with those in the Master ? If so then this is a show-stopper factor
for us to consider using dbmirror, as we use sequences as a unique key in
many of the tables in our application.
W
On Monday 09 February 2004 19:27, you wrote:
> One of our test boxes runs a full installation of: Oracle, Postgres,
> MySql. Other than swapping if they are all used at the same time (and
> the resulting slowdown), it works fine.
> Actually what is SQLNet ? Whatever it might be, I suppose it can't
