I'm using Amarok 1.4.9.1 in kubuntu 8.04, I have a library of almost 10 000 songs so SQlite couldn't handle it, so I decided to use postgreSQL, what happens is that it is incredibly slow, when I try to search a song it takes almost 1 or 2 minutes to search it, and also when I skip a song this happen sometimes. I tried to use MySQL but I never got it running, so I decided to use postgreSQL. Also I think I have a good computer (AMD Athlon X2 2.1 GHz, 2 Gb ram). Can someone help me please?? This is very annoying.

Hard to say with that kind of input ... and I have no idea what
amarok (or Kubuntu?) does to PostgreSQL. My first impulse would
be to check amaroks output by starting it from a konsole, and to
see whether there's anything in postgres' logs. I also don't
know which version of postgres comes with kubuntu 8.04, so can't
make any recommendations regarding tuning.

Have you had a look at the database from a psql prompt, how long
do queries take that you run manually?


Cheers,
Tink

P.S.: I've reported this post to be moved to the ubuntu forum
because the question is quite vague, and requires knowledge of
the distro and how it packages the software involved to even
begin thinking about answering it ...

Moved: This thread is more suitable in Linux - Distributions -> Ubuntu and has been moved accordingly to help your thread/question get the exposure it deserves.

I will explain myself again, I'm using Amarok 1.4.9.2 in Kubuntu 8.04 and I have a library of almost 10 000 songs, Amarok has 3 ways of managing your music libarary, (SQlite, MySQL and posrgreSQL). SQlite is activated by default, but if you have a large collection of music you need another "engine" to manage your library, so I decided to use postgreSQL becauase I read in several places it was faster. What is happening is that when I search for songs or skip songs, sometimes it lasts up ti 2 minutes to perform the job and I consider that my CPU is fast enough (AMD X2 2.1 GHz and 2gb ram) so I would like to know of someone can help me with this issue that becomes very annoying sometimes.

Yes ... and you still haven't told us the postgres version number.

You also ...

• Didn't state whether you checked postgres' log(s).
• Didn't mention whether you tried running amarok from a console to see potential error messages.
• Didn't say how postgres queries work when you run them manually from the interactive psql prompt.

OK here is everything you asked for:
1) I checked postgres logs (I use postgres 8.3), and everything is empty.

2) When I run Amarok form a console this is what appears:

markez@Teresa:~$ amarokapp
kdecore (KAction): WARNING: KAction::insertKAccel( kaccel = 0x866470 ): KAccel object already contains an action name "play_pause"
QLayout "unnamed" added to QVBox "unnamed", which already has a layout
kdecore (KAction): WARNING: KAction::insertKAccel( kaccel = 0x866470 ): KAccel object already contains an action name "play_pause"
QLayout: Adding KToolBar/mainToolBar (child of QVBox/unnamed) to layout for PlaylistWindow/PlaylistWindow
QObject::connect: Incompatible sender/receiver arguments
StarManager::ratingsColorsChanged() --> ContextBrowser::ratingOrScoreOrLabelsChanged(const QString&)
STARTUP

3) When I try to run psql in my console this appears:

markez@Teresa:~$ psql
psql: FATAL: database "markez" does not exist

It's not enough to say "here amarok, use postgres db from now on...". Did you followed the steps in Postresql HowTo? When you switch to "PostgreSQL", then run "Rescan Collection" and something is wrong with your postgres connection a message should pop up saying something like "Postgres server returned the following error: bla bla".
After creating and configuring the postgres database, check if you can connect to the db ("psql <database-name> <username>" as in the HowTo).

When I type the psql command this appears, so I think everything is ok.

markez@Teresa:~$ psql amarok
Welcome to psql 8.3.5, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

amarok=#

In psql, try
\dt
to see which tables amarok defines. Then try to think up a query. :}


Cheers,
Tink

Thnak you all for your help, this happened when I typed \dt

List of relations
Schema | Name | Type | Owner
--------+-----------------+-------+--------
public | admin | table | amarok
public | album | table | amarok
public | amazon | table | amarok
public | artist | table | amarok
public | composer | table | amarok
public | devices | table | amarok
public | directories | table | amarok
public | embed | table | amarok
public | genre | table | amarok
public | images | table | amarok
public | labels | table | amarok
public | lyrics | table | amarok
public | playlists | table | amarok
public | podcastchannels | table | amarok
public | podcastepisodes | table | amarok
public | podcastfolders | table | amarok
public | related_artists | table | amarok
public | statistics | table | amarok
public | tags | table | amarok
public | tags_labels | table | amarok
public | uniqueid | table | amarok
public | year | table | amarok
(22 rows)

Hmmm ... I wouldn't have a clue which of the non-obvious
tables this has listed would hold track titles, e.g. ...

Have a play with some sql, try a
select * from tags;
or some of the other tables. My problem is that I know
nothing about amaroks internal workings (or its front-end
for that matter), so can't even begin to guess what it's
looking for where (or what your search terms were, for
instance).


Cheers,
Tink

Thanks anyway I appreciate your help!