Re: [HACKERS] [BUG] Checkpointer on hot standby runs without looking checkpoint_segments

2012-04-23 Thread Heikki Linnakangas
On 23.04.2012 02:59, Fujii Masao wrote: On Thu, Apr 19, 2012 at 2:20 PM, Kyotaro HORIGUCHI wrote: Hello, this is new version of standby checkpoint_segments patch. Thanks for the patch! This still makes catching up in standby mode slower, as you get many more restartpoints. The reason for

Re: [HACKERS] Gsoc2012 idea, tablesample

2012-04-23 Thread Sandro Santilli
On Mon, Apr 23, 2012 at 08:34:44PM +0300, Ants Aasma wrote: > On Mon, Apr 23, 2012 at 4:37 PM, Sandro Santilli wrote: > > I'd love to see enhanced CTID operators, to fetch all visible tuples in a > > page > > using a tidscan.  Something like: WHERE ctid =~ '(501,*)' or a ctidrange. > > Among oth

Re: [HACKERS] [BUG] Checkpointer on hot standby runs without looking checkpoint_segments

2012-04-23 Thread Kyotaro HORIGUCHI
Hello, > >  - xlog.c: Make StandbyMode shared. > > > >  - checkpointer.c: Use IsStandbyMode() to check if postmaster is > >   under standby mode. > > IsStandbyMode() looks overkill to me. The standby mode flag is forcibly > turned off at the end of recovery, but its change doesn't need to be shar

[HACKERS] Usage of planner_ctx

2012-04-23 Thread Amit Kapila
PlannerInfo->planner_ctx is assigned with either MessageContext or PortalHeapMemory depending on the flow from which planner is invoked. My doubt is that during whole planning process till the Plan is stored in PlannedStmt, all the memory is from CurrentMemoryContext which is same as PlannerInfo->

Re: [HACKERS] Aggressive memory consumption in {ts,array}_typanalyze

2012-04-23 Thread Robert Haas
On Wed, Apr 18, 2012 at 11:09 AM, Robert Haas wrote: > On Mon, Apr 16, 2012 at 4:58 PM, Noah Misch wrote: >> The size hint I chose is fairly arbitrary.  Any suggestions for principled >> alternatives? > > Based on your test results, it doesn't seem like it matters very much > what you put in ther

Re: [HACKERS] Patch: add timing of buffer I/O requests

2012-04-23 Thread Robert Haas
On Sat, Apr 14, 2012 at 10:33 PM, Tom Lane wrote: > Robert Haas writes: >> The internal representation doesn't have to be (and certainly >> shouldn't be) numeric.  But if you translate to numeric before >> returning the data to the user, then you have the freedom, in the >> future, to whack aroun

Re: [HACKERS] Gsoc2012 idea, tablesample

2012-04-23 Thread Ants Aasma
On Mon, Apr 23, 2012 at 4:37 PM, Sandro Santilli wrote: > I'd love to see enhanced CTID operators, to fetch all visible tuples in a page > using a tidscan.  Something like: WHERE ctid =~ '(501,*)' or a ctidrange. Among other things, this would enable user-space implementation of tablesample. Give

[HACKERS] psql omits row count under "\x auto"

2012-04-23 Thread Noah Misch
I've been enjoying "\x auto" in .psqlrc, but I noticed the row count footer missing when it chooses ordinary output: [local] test=# \x off Expanded display is off. [local] test=# select 1; ?column? -- 1 (1 row) [local] test=# \x auto Expanded display is used automatically. [local

Re: [HACKERS] B-tree page deletion boundary cases

2012-04-23 Thread Noah Misch
On Sun, Apr 22, 2012 at 12:13:34AM +0530, Nikhil Sontakke wrote: > Was wondering if there's a similar bug which gets triggered while using > VACUUM FULL. See for instance this thread: > > http://postgresql.1045698.n5.nabble.com/index-corruption-in-PG-8-3-13-td4257589.html > > This issue has been

Re: [HACKERS] ECPG FETCH readahead

2012-04-23 Thread Boszormenyi Zoltan
Hi, 2012-04-17 06:48 keltezéssel, Michael Meskes írta: On Tue, Apr 17, 2012 at 06:02:34AM +0200, Boszormenyi Zoltan wrote: I listed two scenarios. 1. occasional bump of the readahead window for large requests, for smaller requests it uses the originally set size 2. permanent bump of the rea

[HACKERS] Namespace of array of user defined types is confused by the parser in insert?

2012-04-23 Thread Krzysztof Nienartowicz
Hello, Sorry for re-posting - I initially posted this in pgsql.sql - probably this group is more appropriate. I have a bizzare problem that started to manifest itself after addition of field being the array of compound UDTs to the table declared in multiple schemas. It is clearly related to how th

Re: [HACKERS] Gsoc2012 idea, tablesample

2012-04-23 Thread Sandro Santilli
On Sat, Apr 21, 2012 at 02:28:52PM +0800, Qi Huang wrote: > > Hi, Heikki ... > > Another idea that Robert Haas suggested was to add support doing a TID > > scan for a query like "WHERE ctid< '(501,1)'". That's not enough work > > for GSoC project on its own, but could certainly be a part of it.

Re: [HACKERS] [PATCH] lock_timeout and common SIGALRM framework

2012-04-23 Thread Marc Cousin
On Mon, 2012-04-23 at 10:53 +0200, Boszormenyi Zoltan wrote: > 2012-04-10 09:02 keltezéssel, Boszormenyi Zoltan írta: > > 2012-04-06 14:47 keltezéssel, Cousin Marc írta: > >> On 05/04/12 08:02, Boszormenyi Zoltan wrote: > >>> 2012-04-04 21:30 keltezéssel, Alvaro Herrera írta: > I think this pa

[HACKERS] Patch: add conversion from pg_wchar to multibyte

2012-04-23 Thread Alexander Korotkov
Hackers, attached patch adds conversion from pg_wchar string to multibyte string. This functionality is needed for my patch on index support for regular expression search http://archives.postgresql.org/pgsql-hackers/2011-11/msg01297.php . Analyzing conversion from multibyte to pg_wchar I found fol