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