Re: [BUGS] Locale (unsupported) bug. uk_UA.KOI8-U

2008-10-09 Thread Peter Eisentraut
Tom Lane wrote: Peter Eisentraut <[EMAIL PROTECTED]> writes: ivocs admin wrote: The database cluster will be initialized with locale uk_UA.KOI8-U. could not determine encoding for locale "uk_UA.KOI8-U": codeset is "KOI8-U" initdb: could not find suitable text search configuration for locale uk

Re: [BUGS] BUG #4462: Adding COUNT to query causes massive slowdown

2008-10-09 Thread Tom Lane
"Jussi Pakkanen" <[EMAIL PROTECTED]> writes: > Given that PostgreSQL does the scan even with the huge seqscan > penalty, I can think of only two different causes: > 1) some sort of a bug in the query analyzer > 2) SELECT COUNT(DISTINCT x) for some reason requires information that > is not available

Re: [BUGS] BUG #4462: Adding COUNT to query causes massive slowdown

2008-10-09 Thread Jussi Pakkanen
On Thu, Oct 9, 2008 at 3:05 PM, Peter Eisentraut <[EMAIL PROTECTED]> wrote: > Jussi Pakkanen wrote: >> >> However when I try to count the amount of distinct codes, I get this: >> >> >> EXPLAIN SELECT COUNT(DISTINCT code) FROM log; >> QUERY PLAN >> >> -

Re: [BUGS] BUG #4461: Should avoid create tblspcs in system location

2008-10-09 Thread toruvinn
On Thu, 09 Oct 2008 14:06:35 +0200, Peter Eisentraut <[EMAIL PROTECTED]> wrote: If this is the location you give it, why should it avoid creating tablespaces there? I believe this is called "making things `idiot-proof'". This is the direction Microsoft's software takes, and I wouldn't be real

Re: [BUGS] Locale (unsupported) bug. uk_UA.KOI8-U

2008-10-09 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > ivocs admin wrote: >> The database cluster will be initialized with locale uk_UA.KOI8-U. >> could not determine encoding for locale "uk_UA.KOI8-U": codeset is "KOI8-U" >> initdb: could not find suitable text search configuration for locale >> uk_UA.KO

Re: [BUGS] BUG #4461: Should avoid create tblspcs in system location

2008-10-09 Thread Peter Eisentraut
Dmitry Orlov wrote: if I issue create tablespace user_ts location '/var/lib/postgresql/8.3/main/pg_tblspc' then appears nested links in /var/lib/postgresql/8.3/main/pg_tblspc. So should avoid to create tablespaces in pg_tblspc If this is the location you give it, why should it avoid creating t

Re: [BUGS] BUG #4462: Adding COUNT to query causes massive slowdown

2008-10-09 Thread Peter Eisentraut
Jussi Pakkanen wrote: However when I try to count the amount of distinct codes, I get this: EXPLAIN SELECT COUNT(DISTINCT code) FROM log; QUERY PLAN - Aggregate (cost=100801488.

Re: [BUGS] Locale (unsupported) bug. uk_UA.KOI8-U

2008-10-09 Thread Peter Eisentraut
ivocs admin wrote: initdb -E ISO-8859-1 -D data/ This is probably not a good idea. You should specify a locale and let initdb figure out the matching encoding. Otherwise you might end up with an incompatible locale/encoding combination. (initdb would probably not even allow this to procee

[BUGS] Locale (unsupported) bug. uk_UA.KOI8-U

2008-10-09 Thread ivocs admin
initdb -E ISO-8859-1 -D data/ The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale uk_UA.KOI8-U. could not determine encoding for locale "uk_UA.KOI8-U": codeset is "KOI8-U"

[BUGS] BUG #4462: Adding COUNT to query causes massive slowdown

2008-10-09 Thread Jussi Pakkanen
The following bug has been logged online: Bug reference: 4462 Logged by: Jussi Pakkanen Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Ubuntu x86 8/04 Description:Adding COUNT to query causes massive slowdown Details: I have a table in

[BUGS] BUG #4461: Should avoid create tblspcs in system location

2008-10-09 Thread Dmitry Orlov
The following bug has been logged online: Bug reference: 4461 Logged by: Dmitry Orlov Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Ubuntu Hardy 8.04.1 Description:Should avoid create tblspcs in system location Details: if I issue crea