Richard Broersma Jr wrote:
--- rihad <[EMAIL PROTECTED]> wrote:
UPDATE Foo foo
SET foo.baz_id=baz.id
FROM Baz baz LEFT JOIN Bar bar ON (foo.bar_id=bar.id)
WHERE bar.id IS NULL;
This query cannot work.
I know. So how do I do it efficiently?
Thanks.
---(end of broadc
Richard Broersma Jr wrote:
--- rihad <[EMAIL PROTECTED]> wrote:
UPDATE Foo foo
SET foo.baz_id=baz.id
FROM Baz baz LEFT JOIN Bar bar ON (foo.bar_id=bar.id)
WHERE bar.id IS NULL;
This query cannot work. Basiclly, you are trying to set the foo.baz_id =
baz.id for records in
foo that do not yet
A vacuum analyze that used to take about 3 minutes on a table of about
4 million rows is now taking up to 25 minutes. I changed the
statistics on two index columns to 100 recently, to improve planner
estimates. Could this have something to do with the lack of speed?
---(end
"Phoenix Kiula" <[EMAIL PROTECTED]> writes:
> A vacuum analyze that used to take about 3 minutes on a table of about
> 4 million rows is now taking up to 25 minutes. I changed the
> statistics on two index columns to 100 recently, to improve planner
> estimates. Could this have something to do wit
>>CN wrote:
> ... MyZql ... MyZql
>
> 1. "MyZql" is easier to pronounce and remember than "PostgreSQL".
Actually, that's *MySQL*.
> Yes, UNICODE results in poorer performance than SQL_ASCII. However, this
> is not a problem at all because advanced users will use "-E" when they
> only needs SQL_A
On 09/30/07 10:31, brian wrote:
[snip]
>
> The default for MySQL is latin1 with swedish sorting.
Yorn desh born, der ritt de gitt der gue
Orn desh, dee born desh, de umn børk! børk! børk!
--
Ron Johnson, Jr.
Jefferson LA USA
Give a man a fish, and he eats for a day.
Hit him with a fish, and h
Hi,
Get a VPS - Virtual Private Server. Mine is 29$ and it is fine for 480MB
RAM and enough disk space. I am a full admin on my server, so I install
and configure Postgresql without problem.
YES! I agree that the default encoding must be UTF-8. I started using
Postgresql, cause I had problems w
On Sun, Sep 30, 2007 at 11:55:00AM +0800, CN wrote:
> Various people have various perceptions. I don't feel that my suggestion
> only serves to make PostgreSQL become a software product fitting only
> *myself*. On the contrary, I believe PostgreSQL will become suitable for
> more novice users if in
Hello all,
I would like to change a pg database to another server.
The source environment is: postgresql Windows v.8.2.4 (windows xp
workstation).
The target environment is: postgresql Windows v.8.2.5 (windows 2003 Server).
I would like to do migration without pg_dumpall and I think I can do
> > Is it
> > possible to have FK that spans into child tables?
>
> This is a well known (and documented, see [1]) deficiency. It's due to
> the current implementation of indices, which are bound to exactly one
> table, meaning they do return a position within the table, but cannot
> point to di
10 matches
Mail list logo
