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 19:44, Sergio Lifschitz wrote: Indeed, hypothetical indexes are good to check potentially good configurations without harming the whole system with actual index creation. Please observer that we've added an explain hypothetical command, that will include plans considering hypothetical indexes! We'll try to add a simple case study that would help those wondering about this project. That sounds very useful indeed! Jeroen
[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 feedback. Link to project: http://sourceforge.net/projects/hypotheticalind/ Thanks, Sergio Lifschitz Ana Carolina Almeida
[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 take RelOptInfo by these parameters? I thought in use find_base_rel, but it needs the PlannerInfo structure that I don't have. Do you recommend another function? How can I find PlannerInfo with parameters that I have (Eg.: PlannedStmt)? Thanks, Ana Carolina
[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: $ pg_ctl start server starting $* LOG: could not bind IPv4 socket: Address already in use HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.* LOG: database system was shut down at 2009-03-18 11:32:55 BRT LOG: autovacuum launcher started LOG: database system is ready to accept connections What's wrong? Why do I receive these messages (about IPv4 socket and HINT)? Can you help me? Thanks, Ana Carolina
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 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: $ pg_ctl start server starting $* LOG: could not bind IPv4 socket: Address already in use HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.* LOG: database system was shut down at 2009-03-18 11:32:55 BRT LOG: autovacuum launcher started LOG: database system is ready to accept connections What's wrong? Why do I receive these messages (about IPv4 socket and HINT)? Can you help me? Thanks, Ana Carolina
[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 run gdb, but I dont enter in backend. See this: [EMAIL PROTECTED]:/home/anacrl$ gdb postgres GNU gdb 6.8 Copyright (C) 2008 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later http://gnu.org/licenses/gpl.html This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type show copying and show warranty for details. This GDB was configured as i686-pc-linux-gnu... (gdb) run Starting program: /usr/local/pgsql8/bin/postgres Failed to read a valid object file image from memory. LOG: database system was shut down at 2008-05-01 22:56:41 BRT LOG: database system is ready to accept connections LOG: autovacuum launcher started So, I think that have something wrong (Failed to read a valid object file image from memory). Can you help me? I tried run psql and attached process pid too, but no success. :-( Thanks, Ana Carolina
[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 to max_connections? And can you help me with this error (stack smashing)? I tried run this with Ubuntu, Debian and Fedora, but I have not success. Sorry about my english. Thanks, Ana Carolina