T1 and T2?
Do I need to use a full outer
join in order to propagate the LIMIT clause?
Thanks
Gregor
Zeitlinger
LUCAS Product Development
Torex Retail Solutions GmbH
Schwedenstr. 9,
D-13359 Berlin
Tel. +49 (0) 30
49901-243
Fax +49 (0) 30
49901-139
Mailto:[EMAIL PROTECTED]
http
As per docs, if the databases are rarely updated it could take a long
time for the WAL segment to roll over.
Yes, therefore I want to copy the current WAL (as I said earlier).
When restoring, I also want to make sure that I restore exactely to the point
when I copied the current WA segment.
method is awkward.
Yes, what I am planning to do:
1) drop the corrupted database
2) restore the base backup
3) replay all incremental backups (in the sense of my original mail)
Gregor Zeitlinger
LUCAS Product Development
Torex Retail Solutions GmbH
Schwedenstr. 9, D-13359 Berlin
Tel. +49 (0
Hello,
as far as I have understood, the WAL backup that you control via
archive_command is the PostgreSQL equivalent to what other databases let you
do with an incremental backup. That is, if you don't forget to include the
current WAL block.
I have found a script to determine the current
larger (100 MB+)
b) XML is a big buzzword, and people have been able to succesfully
attract research funds or vulture capital on the basis of
having that acronym in a proposal?
That time's over anyways, isn't it?
--
Gregor Zeitlinger
[EMAIL PROTECTED]
---(end
On Thu, 23 Oct 2003, Christopher Kings-Lynne wrote:
4. Extend the contrib/ltree gist-based tree indexing scheme to work on
xml and hence the operations in no.3 above are really fast...
but then, the plain xml data is still stored in a database colum, if I
understand correctly?
--
Gregor
an implementation is a real proof.
--
Gregor Zeitlinger
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
, the previous, the next elemnt or the first or last child.
I use XML a lot for all sorts of purposes, but it is appropriate for
data transfer rather than data storage, IMNSHO.
Right now, you're quite right. But I want to change that.
--
Gregor Zeitlinger
[EMAIL PROTECTED
efficent RDBMS than xml databases, I agree. Otherwise, I
don't see your point.
--
Gregor Zeitlinger
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
first
or you don't know what you're proving.
agreed.
Anyway, I don't think you an borrow code from any existing relational
database,since an XML database would be radically different structurally.
I'm getting this impression, too.
--
Gregor Zeitlinger
[EMAIL PROTECTED
was that I doesn't work too well in a
relational database.
I was just wondering wheater I have to reinvent the wheel of database
technology when it comes to transaction processing, ACID, and Indexes,
which a native xml database ought to have as well.
--
Gregor Zeitlinger
[EMAIL PROTECTED
databases it's too slow to store them in
relational tables. After all, if you were designing a database for xml
data only - would you come up with tables to store them?
--
Gregor Zeitlinger
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting
? And are you interested in having a
fast, scalable XML access method?
--
Gregor Zeitlinger
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
13 matches
Mail list logo