Re: [HACKERS] Hypothetical Indexes - PostgreSQL extension - PGCON 2010

Jeroen, We add a simple case study (sourceforge page): http://sourceforge.net/projects/hypotheticalind/files/TUTORIAL_8_4.pdf/download Although this tutorial is for version 8.4, it also applies to other versions. Att, Ana Carolina 2010/12/3 Jeroen Vermeulen j...@xs4all.nl On 2010-12-03

[HACKERS] Hypothetical Indexes - PostgreSQL extension - PGCON 2010

Hackers, We would like to inform you all that our extension to PostgreSQL, that includes hypothetical indexes (and soon index self-tuning), is available through a sourgeforge project. This was suggested at PgCon 2010 and we hope some of you may find it useful, contribute and give us your

[HACKERS] PlannerInfo Structure

Hi all, I created a function which needs build or find a relation (RelOptInfo). The build is ok. On the other hand, I can't find the relation. I have all informations that pg_plan_query has: querytree (Query), cursorOptions (int), boundParams(ParamListInfo) and plan (PlannedStmt). So, how can I

[HACKERS] could not bind IPv4 socket

Hi all, I installed postgresql 8.3.5 with these commands: - ./configure --enable-thread-safety (I need this because of dbt2) - make - make install I executed initdb. It's ok. I changed postgresql.conf file: listen_addresses = '*'. So, when I started postgresql, I receive these messages: $

Re: [HACKERS] could not bind IPv4 socket

Hi all, I resolved this problem. I had another postgresql installed and it started automatically when I restarted my computer. Thanks. 2009/3/18 Ana Carolina Brito de Almeida ana...@ig.com.br Hi all, I installed postgresql 8.3.5 with these commands: - ./configure --enable-thread-safety (I

[HACKERS] Copy PlannerInfo structure

Hi all, How can I copy the PlannerInfo structure? I have *root variable that is PlannerInfo and I would like to pass this value to another variable that I created (the same type - PlannerInfo). Can you help me? I only found function that copies PlannedStmt structure. Thanks, Ana Carolina

[HACKERS] Bucket and batch

Hi! I saw that functions which use hash join, like as ExecHashGetBucketAndBatch and ExecScanHashBucket, have bucket and batch concepts. So, I would like to know the differences between bucket and batch. I dont understand tables partitioning mechanism in hash join. Thanks, Ana Carolina

[HACKERS] GDB X Postgresql 8 - Failed to read a valid object file image from memory

Hi! I tried to use GDB with postgresql 8 and I didnt have success. Can you help me? I tried like as I did in postgresql 7.4 I run configure like this: ./configure --prefix=/usr/local/pgsql8 --enable-debug --enable-cassert --enable-depend After, I run make, make install, initdb After this, I tried

[HACKERS] stack smashing detected

Hi! I'm trying test a version extended of Postgresql, but when I run a command after 9 times, I receive this message in psql: ***stack smashing detected*** And Log said that postgres terminated with signal 6. I increased buffer to 120MB and the linux buffer (shmmax) to 2GB. What value can I put