I'm in the process of migrating a web application from a dedicated server to
VPS Hosting (Slicehost). During the test phase I've spotted a huge
performance advantage for the old dedicated server for some queries and I
need some help interpreting the execution plans.
Plan 1 - Dedicated Server Athlon
Hello
I have problem in my applications and don't know how to fix it.
This is the table and one of the indexes:
CREATE TABLE foo
(
id serial NOT NULL,
foo_name character varying(100),
realm_id integer
... and about 50 other columns
)
CREATE INDEX idx_foo_name_realm
ON foo
USING btr
The below statement is now running for 18 hours on a table with ~8 Million
Rows, no triggers no fancy stuff. The database is otherwise performing very
well and the server is a development server that's currently idle except for
the update statement. Any suggestions why it takes so long to update a
This is my table:
CREATE TABLE item_names
(
item_name character varying(255) NOT NULL,
culture_id integer NOT NULL,
item_id integer NOT NULL,
ft_idx_config regconfig,
CONSTRAINT pk_item_names PRIMARY KEY (item_id, culture_id)
)
Basically the table stores strings with varying language (a
Hi
I run a site with several MediaWiki installations all running on PostgreSQL
8.2.5 utilizing TSearch2. Is there something like a Migration Guide from 8.2to
8.3 for tsearch2 users?
Cheers
Oliver
