amp - '300 days'::interval);
---delete from visit where date(created_stamp) <
date(current_timestamp - '240 days'::interval);
---...
Why does the postmaster need so much memory to delete tuples?
Thanks in advance.
Alexander Elgert
---(e
Marc Evans schrieb:
Some people may find this interesting reading.
http://us.devloop.org.uk/
Nice, but it would be interesting which storage engine was used for
mysql - ok, default is MyIsam.
Does mysql (in the latest version) still use a single write-thread for
writing?
In mysql 3, a ba
Richard Huxton schrieb:
Shelby Cain wrote:
Excerpt from the document:
===
2. What is compared here - "Apples and Oranges"
The setups are as standard as can be. The only principle guiding the
installation of all the software is simplicity. No op
Hello.
Richard Huxton schrieb:
Alexander Elgert wrote:
Hello,
given is a postgres database in version
PostgreSQL 7.4.8 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2
Upgrade to 7.4.16 as soon as is convenient
Hello,
thank you for the information, but it seems my messages are hold for
moderator approval.
A few of them seems to be dropped - I don't know.
Richard Huxton schrieb:
Alexander Elgert wrote:
Hello,
given is a postgres database in ve
talogs, but the page:
http://www.postgresql.org/docs/8.2/interactive/information-schema.html
says they are not stable.
And - of course - it is much easier to type! ;)
Greetings,
Alexander Elgert
---(end of broadcast)---
TIP 9: In versions belo
Richard Huxton schrieb:
Alexander Elgert wrote:
Hello,
I programmed a little script which iterates over all databases in a
DBMS, iterating over all tables and then over all columns.
This skript works for mysql and postgres.
1. Solution overview
foreach database
ot that the first query is so slow,
it's that it's so fast.
AAAH! That is the reason.
So creating a temporary table from the information schema would speedup
the whole thing by factor 10 (at least), I guess.
Thanks a lot!
;)
Greetings,
Alexander Elgert
-
