Re: [BUGS] BUG #5059: Planner ignores estimates when planning an IN () subquery

My apologies, I meant user_activity_log, and not user_anime_log in the previous email. This isn't a huge issue as the query could easily be rewritten using a more pragmatic join structure, but I thought it would be worth mentioning as occasionally bugs involve more than just what meets the eye. Th

Re: 답장: [BUGS] bug report

Craig Ringer writes: > On Thu, 2009-09-17 at 12:06 +0900, 황수진 wrote: >> Pg version is 8.4.1. >> I am using Windows XP. > Please reply to the list, not just to me. I've cc'd the bugs list. > I don't have much idea what could be causing your issue personally, as I > have practically zero kn

Re: 답장: [BUGS] bug report

On Thu, 2009-09-17 at 12:06 +0900, 황수진 wrote: > Pg version is 8.4.1. > I am using Windows XP. > Please reply to the list, not just to me. I've cc'd the bugs list. I don't have much idea what could be causing your issue personally, as I have practically zero knowledge about locale handling on

Re: [BUGS] BUG #5059: Planner ignores estimates when planning an IN () subquery

On Wed, Sep 16, 2009 at 6:39 PM, Kenaniah Cerny wrote: > I can provide the output of statistics queries if you would like. Just let > me know which statistics you want and I'll pastebin them. > > As far as selectivity goes, the selectivity estimate for the > user_anime_log.user_account_id was defi

Re: [BUGS] ERROR: invalid page header in block 502758 of relation base/16388/16403

fous velkej writes: > ok, so i did reindexing ending with following error > proxylog=# REINDEX TABLE user_record ; > ERROR: concurrent insert in progress So that page header wasn't the only corrupted data in your database. Maybe you'd better take a step back and tell us some context about your p

Re: [BUGS] bug report

황수진 wrote: > > postgres=# \encoding > EUC_KR > postgres=# CREATE DATABASE 수진이_친구; > WARNING: could not determine encoding for locale "Korean_Korea.949": codeset > is > "CP949" > 상세정보: Please report this to http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #5060: 8.2 bin install

Attila Somogyi wrote: > I have a special problem, I use a java based software that use postgresql, > but as I know the sql queries cahnged in 8.3 and the manufacturer of my > software support only 8.2 or earlier version. I look for a long time a > binary install package on the Internet but didn't

Re: [BUGS] BUG #5059: Planner ignores estimates when planning an IN () subquery

I can provide the output of statistics queries if you would like. Just let me know which statistics you want and I'll pastebin them. As far as selectivity goes, the selectivity estimate for the user_anime_log.user_account_id was definitely miscalculated. The user_anime_log contains up to 15 entrie

Re: [BUGS] BUG #5059: Planner ignores estimates when planning an IN () subquery

On Tue, Sep 15, 2009 at 11:35 PM, Kenaniah Cerny wrote: > > The following bug has been logged online: > > Bug reference:      5059 > Logged by:          Kenaniah Cerny > Email address:      kenan...@gmail.com > PostgreSQL version: 8.4.1 > Operating system:   Centos5.2 > Description:        Planner

[BUGS] 'missing parameter $1' for sql or pl/pgsql COPY

The following functions fail: create or replace function docopy(int[]) returns int as $$ copy (select unnest($1)) to stdout; select 0; $$ language sql; ERROR: there is no parameter $1 create or replace function docopy(int[]) returns int as $$ begin copy (select unnest($1)) to stdout; e

Re: [BUGS] strange bug with gist over box and circle

On Wed, 2009-09-16 at 10:36 -0400, Tom Lane wrote: > This is expected, no? Those opclasses use the STORAGE option. I see, that makes sense. I was making the assumption that the types matched in my new patch, and obviously that's incorrect. Regards, Jeff Davis -- Sent via pgsql-bugs

[BUGS] bug report

postgres=# \encodingEUC_KRpostgres=# CREATE DATABASE 수진이_친구;WARNING:  could not determine encoding for locale "Korean_Korea.949": codeset is "CP949"상세정보:  Please report this to .WARNING:  could not determine encoding for locale "Korean_Korea.949": codeset is "CP949"상세정

Re: [BUGS] strange bug with gist over box and circle

Jeff Davis writes: > If I create a gist index over a box and a circle, the index attributes > appear to both have type box. This is expected, no? Those opclasses use the STORAGE option. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) T

Re: [BUGS] ERROR: invalid page header in block 502758 of relation base/16388/16403

ok, fault on my side this is maybe better code dd if=16403.3.orig of=16403.3 bs=8192 count=109542 dd if=/dev/zero bs=8192 count=1 >> 16403.3 dd if=16403.3.orig skip=109543 bs=8192 >> 16403.3 but now, it says ERROR: index "day" contains unexpected zero page at block 502758 HINT: Please REINDEX i

Re: [BUGS] ERROR: invalid page header in block 502758 of relation base/16388/16403

fous velkej writes: > hi again > i've stopped postgres and done this > dd if=16403.3.orig of=16403.3 bs=8192 count=109541 > dd if=/dev/zero bs=8192 count=1 >> 16403.3 > dd if=16403.3.orig skip=109542 bs=8192 >> 16403.3 > then started postgres, but did not help, the same error appears. > ERROR: i

Re: [BUGS] BUG #5061: pg_autovacuum is not in 8.4 Version

On Wed, Sep 16, 2009 at 14:50, Smrti Atrey wrote: > > The following bug has been logged online: > > Bug reference:      5061 > Logged by:          Smrti Atrey > Email address:      smriti.at...@globallogic.com > PostgreSQL version: 8.4 > Operating system:   Suse 11.1 > Description:        pg_autov

Re: [BUGS] ERROR: invalid page header in block 502758 of relation base/16388/16403

hi again i've stopped postgres and done this dd if=16403.3.orig of=16403.3 bs=8192 count=109541 dd if=/dev/zero bs=8192 count=1 >> 16403.3 dd if=16403.3.orig skip=109542 bs=8192 >> 16403.3 then started postgres, but did not help, the same error appears. ERROR: invalid page header in block 502758

[BUGS] BUG #5061: pg_autovacuum is not in 8.4 Version

The following bug has been logged online: Bug reference: 5061 Logged by: Smrti Atrey Email address: smriti.at...@globallogic.com PostgreSQL version: 8.4 Operating system: Suse 11.1 Description:pg_autovacuum is not in 8.4 Version Details: Hi We are using slony 2.0.2

[BUGS] BUG #5060: 8.2 bin install

The following bug has been logged online: Bug reference: 5060 Logged by: Attila Somogyi Email address: satt...@freemail.hu PostgreSQL version: 8.3 Operating system: Gentoo/Debian Linux Description:8.2 bin install Details: Hello Support, I have a special problem, I